Import multiple XML into rows

[Saravanakumar]

I'm importing multiple XML files from a directory using *.xml. However, it appends the data one beneath the other. Hence, there are same childname repeated as many times as the number of files read.

Is it possible to have the childnames as header and the values into rows.

[Saravanakumar · Accepted solution]

Found a solution here. Never mind:

https://community.alteryx.com/t5/Data-Preparation-Blending/Combine-multiple-rows-into-one-row/m-p/86...