Requesting help for extracting xml file

[srk0609]

Hi,

Can someone please help me extract this xml file to xlsx. I need it very urgently please help and also please provide me with Alteryx wf. Excel file shows how columns need to be arranged for output xlsx file, Thank you.

[Ben_H]

Hi @srk0609,

This should do it, I've annotated the workflow so take a look and see if you can follow along with what it's doing.

Regards,

Ben

[srk0609]

Hi Ben your suggestion was helpful but there is a issue I'm facing I didn't notice earlier could you please help me?

In the image you can see within the file there are 3 different child values with Root name Trade
1OTC_CDS
2OTC_OPT
3TCI_FX
could you please tell me how to extract each one on new sheet in Excel? like 

OTC_CDS on sheet 1, OTC_OPT on sheet 2, TCI_FX on sheet 3
I'm attaching below sample data can you please help? whatever workflow you gave would have been perfect in case there were no more than 1 child in Trades

[Ben_H]

Hi @srk0609,

Something like this should work. Although there may well be better ways.

I would add in some kind of dynamic file naming into the workflow, it's just set up at the moment to show how you can get your outputs.

Regards,

Ben