Reading XML-File (AnaCredit)

[MRTN]

Hi everyone, 

I'm trying to write all datafields contained in the attached XML-file in a structured table which then can be used for further analysis. 

I tried to import the file as xml and then to utilize the xml-parse to pull the nodes, but sadly this is not working as expected. 

Any ideas on how to do this?

[DavidP · Accepted solution]

For jobs like this I normally use the Parse+XML macro available from the Public Alteryx Gallery.  

You can then tidy up the data with normal prep tools.

Attached is a packaged example that includes the macro.

[MRTN]

Hi David, sadly i'm not able to open the workflow provided by you: 

Could you provide any details on what were your settings? 

[DavidP]

Download and install parse+xml macro from galley.alteryx.com

replicate the instructions in the comment box in my screenshot around the input data tool.

add the parse xml macro

[grazitti_sapna]

@MRTN , unzip the file and then open the yxmd file in notepad and edit the version as per the version you are using.

Thanks.

[DavidP]

Unzipping might work. The macro has 2 parts to it and the workflow will have to point correctly to both.

I’d recommend installing the macro.

[DavidP]

Here's the parse+xml macro install package, which should work for you.