XML import in rows, not columns

Question

I don't really know how to describe the problem technically correctly, so maybe I'll send some sample files:

1. XML TEST.xml - sample xml file (the original has even more of the same levels)

2. XML TEST - Excel.xlsx - desired result created by XML import in Excel

3. XML TEST - Alteryx.xlsx - result created by regular XML import in Alteryx

Is it possible to create such a flow in Alteryx so that the result is output as in point 2 from Excel?

XML TEST - Alteryx.xlsx

XML TEST.xml

XML TEST - Excel.xlsx

davidskaife · Answer

Hi @Gromah

I've had a quick look, by the looks of it you need to identify which column(s) are grouped together to create the final output.

Try this for a starter: stick on a Record ID tool after the Input tool, then Transpose the data using Record ID as the Key Column and all the others as the Data Columns. From here i suspect you may need to start renaming data in the column 'Name' so you can start grouping by the required fields when you pivot the data back. You can then Cross Tab the data back out - Grouping by Record ID again and concatenating the output from the tool.

That's a high level approach, you'll probably need to do a lot of trial and error before it works.

Have a go, and if you get stuck share your workflow and more details on which column(s) it should be grouped by etc and we'll be happy to help further!

Gromah · Answer

I'll try my luck, maybe someone has at least an idea in which direction I should try to get such a result :D ?