XML input issue

zanjam

I've never really had to deal with XML but I understand Alteryx supports XML files. Currently I'm trying to get all the fields from the attached dummy xml into Alteryx but am only getting 34 fields. I've tried playing around with the input options for xml but to no avail.

Any ideas? Thanks in advance!

Report (2).xml

WilliamR

Hello,

here is a sample workflow to read your XML (with bad tags inside), I mean tags without correct end.

The way you can work wit XML and Alteryx is to parse Tag at the root, it gives you the values at the level-1 and if you have values at other level, you have to explicitely parse the node adding a XML parser tool.

Hope this help.

If it is the case, please mark the solution as accepted.

Thanks.

Test.yxmd