Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Requesting help for extracting xml file

srk0609
8 - Asteroid

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.

 

3 REPLIES 3
Ben_H
11 - Bolide

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.

 

Ben_H_0-1659534873231.png

Ben_H_1-1659534913804.png

 

Regards,

 

Ben

srk0609
8 - Asteroid

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

 

srk0609_0-1660171873129.png

 

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
11 - Bolide

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

 

 

Labels