Reading and Parsing XML

Question

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 , , comments>,

onto those rows? Appreciated! Jens obstructions_6265586.zip Import XML.yxmd

rkapoor · Answer

@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

Import XML.yxzp

Schochen · Answer

Thank you @RishiK.

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

rkapoor · Answer

@Schochen here's an updated version fyi.

Import XML.yxzp