Problem extracting data from XML file

[Nicolashad]

Hello everyone!

Can anyone help me extract all the information is contained in the attached XML in a tabular form . I have tried to open it with "input data "  and also with "XML parse "tool but i didn't find the way to gather the necessary information .

Thank you in advance 

[RishiK]

@Nicolashad your attached workflow didn't contain the xml files.  Could you attach them?

These links may help you parse out the XML data:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-having-trouble-reading-an-XML-...

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-37-Parsing-a-Raw-XML-File/td-p/36577

The Parse XML macro is worth a try also from our Public Gallery:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-XML-File-AnaCredit/td-p/600802

[Nicolashad]

Hello Rishik 

Thank you for your reply i am trying to upload my file but i get this error 

[randreag]

Hi @Nicolashad 

You didn't attached the file.

But you can try perhaps loading it using csv without delimiter (\0) or with .flat

I hope it helps

[RishiK]

@Nicolashad you can package the xml files by exporting your workflow:

1. First, create and save your workflow.
2. Then select Option > Export Workflow.
3. Pick a ‘Package Location’ to save your packaged workflow in that file location.
4. Make sure all the assets (aka inputs and outputs) that you want to package with your Alteryx workflow are ticked.
5. Click OK.
6. Done!
   
   

[Nicolashad]

thank you

[RishiK]

@Nicolashad I have started this off with you using the Parse XML macro. Let me know what you think.

[Nicolashad]

Hello Rishik and thank you again for your help .

Due to the fact that i am using an older version(2019.3) of alteryx i can not open the yxzp .Is there any way to send me the file to be compatible with 2019.3 version?

Thank you again 

[RishiK]

@Nicolashad I have attached the workflow unpackaged and for 2019.3.

I am using the Parse XML macro from the Gallery (I have attached it also) in case it doesn't appear in your workflow when you open it:

There is also an app for you:

https://gallery.alteryx.com/#!app/XML-Parse-App/584b5424effc2a1140cc7db9