Hello everyone,
I have an XML file with multiples <tags> and would like to parse a few tags (I don't need all of them) as columns and rows.
I have tried to use the XML macro but it doesn't work and now I am struggling to achieve my goal.
I am attaching the XML file so you can have a look at the format.
Does anybody know how to work with this?
I appreciate all your help.
Thank you.
Solved! Go to Solution.
Hey @MadiNissi,
You may want to tick some of these boxes if the information isn't coming through:
Is there an specific tags values you want to extract? It may be that Regex is needed to get the values.
Hi @MadiNissi ,
as @IraWatt pointed out, given you have multiple outer and child xml sections you need to check the boxes in your input tool:
This allows you to return these xml sections and then run them individually through the XML parsing tool:
This will then give you the outputs:
I've attached the exported workflow which includes the xml tool.
I hope this helps,
M.
Thank you @mceleavey! It worked well!
@mceleavey How can we parse the XML which are generated in Workflow Setting of the XML view while Developing workflow.
I want to convert that XML in Excel format. Any idea or Suggestion on the Same.
Those XML Containg Node, Connection and Properties.
Thank you, @mceleavey! I am working on a XML project and looking for a way that allows me to parse the values from all levels. The parse XML macro did the magic! It's so awesome!