Parsing Alteryx XML

Question

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 tag as in Image1. However, I also want to output the data in the tag. Any suggestions to resolve this? XML Input.txt Image1.PNG

Maskell_Rascal · Accepted Answer

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