You’re offline. This is a read only version of the page.
Good morning, everyone,
I'm currently attempting to create a flow that allows me to parse a large amount of XML files that will share the same schema and transform them into more useful excel files. The issue that I'm encountering is that there are several nested child elements within the file that contain {"xsI:nil": "true"} values that I want removed, preferably in one action. I'm very new to XML files and syntax, so I will share an example of the XML file below:
There are several books within the file and hundreds of these nil values sprinkled in between 11,000 rows of data. I need to create a flow/function that removes the entire {"@xsi:nil": "true"} value and replaces it with a null value for the conversion into excel to go smoothly. How can I achieve this and also append each book to its own array so that I may place the data within their own individual sheets on an excel file?
Surprised at not seeing any responses for this. Have you figured out any solution for this? I am also trying to replace certain values in my XML. Let me know if you found any solution.
Thanks,
Ramesh
Share
Report
All responses (
Answers (
1,113
