New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Parsing XML file

AbH
Level 1
Parsing XML file

Hello !

I have a rather complex xml files which I used to create several datasets with sub-parts of the original xml files. 

Most of the times I manage to extract the data with the XPath proposed but some times, it seems it gets confused and can't recognize xml and create columns based on those data. 

The data column should be divided in columns based on the differents paths possible. I can't explain this behavior and I tried to use XPath and explicit Xpath but then the preview is empty.

Thanks for your help !

For example :

 
0 Kudos
2 Replies
AbH
Level 1
Author

I attach the file here because it seems I can't display it in the message

0 Kudos
AbH
Level 1
Author

Ok. I answer my own questions ^^

First I "folded" the data in order to obtain one array per row.

Then, I "unnested" those rows to obtain columns with the attributes and the proper value in the row.

0 Kudos
A banner prompting to get Dataiku DSS