Parsing Alteryx XML

[busybee]

I am trying to parse an XML file. I have attached the image of the workflow and the input XML file. When I select Return Child Values in my Input Data tool, it outputs the data in the <Values> tag as in Image1. However, I also want to output the data in the <Module> tag.

Any suggestions to resolve this? 

[Maskell_Rascal · Accepted solution]

Hi @busybee 

If you want your data in columns like the picture you attached, you can input the file as a .csv and use the XML Parse tool to get the desired output.  

Otherwise, you can get the Module to come through in the Input tool by selecting the Return Root Element option. This will spread all of your data across several columns though. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil