Parse XML with multiples tag to columns

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.

35220747180625002190550050002621721452911683.XML

Tips and Tricks

Parse

Help

Accepted answers

IraWatt

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

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,

mceleavey xml.yxzp

All comments

IraWatt

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

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,

mceleavey xml.yxzp

mceleavey

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

Parse XML.yxzp

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703