Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
6
Views
Topic starter
Hey,
I retrieve XML files from my ERP.
These files always have the same format:
Table "Column" type
C1
C2
C3
C4
Table "Result Line WS" type
A1
A2
A3
A4
B1
B2
B3
B4
I would like to return an array of type
C1 C2 C3 C4
A1 A2 A3 A4
B1 B2 B3 B4
The number of columns can vary and I would like a code that adapts if it is possible. I tried a whole day but I can not do it. You will find an example XML file here
https://drive.google.com/drive/folders/1JpB_OKD9h9d75STG8ARDcEe8uYbLCeIs?usp=sharing
Thank you very much.
Julien
Posted : 21/06/2019 12:03 pm
Hi Julien,
try the attached solution, should work with variable columns too.
Posted : 21/06/2019 2:14 pm
