Parse XML with multiples tag to columns

[MadiNissi]

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.

[IraWatt · Accepted 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.

[mceleavey · Accepted solution]

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.

[mceleavey]

...if the macro isn't working I've attached this as an export too.

M.

[MadiNissi]

Thank you @mceleavey! It worked well!

[rohit782192]

@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.

[Dlians]

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! 

[mceleavey]