Forum

Transform Data from...
 
Notifications
Clear all

Transform Data from XML

2 Posts
2 Users
0 Reactions
70 Views
(@omega5962)
Posts: 1
New Member
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
(@catalinb)
Posts: 1937
Member Admin
 

Hi Julien,

try the attached solution, should work with variable columns too.

 
Posted : 21/06/2019 2:14 pm
Share: