Reading and Parsing XML

[Schochen]

Hi folks,

have been breaking my head over reading the attached xml file...
Based on these insightful instructions I have managed to break it up onto two rows, but unfortunately I do not manage to split the rest of the info onto those rows. 

Any advice how I would need to proceed to get the info from <periods>, <infrastructure>, comments>, <details> onto those rows?

Appreciated!

Jens

[RishiK]

@Schochen I used the Parse XML macro to work on your XML input and updated your workflow as attached. See if this helps you further.

[RishiK]

@Schochen here's an updated version fyi. 

[Schochen]

Thank you @RishiK.

Unpacked the workflow package, but now I am not sure what to do about this invalid entry point 😞

[RishiK]

@Schochen I've repackaged the workflow with the Parse XML macro and Data Cleanse included as attached.  See if the attached workflow works.

You can get the Parse XML macro from here also: 

https://gallery.alteryx.com/#!app/Parse-XML/584b5589f499c704689e363b