XML Parsing Help !

[JDong]

Hi All,

I am using an XML input and trying to extrac the child values. Please refer to the screenshot below :

I am getting the desired parsed output but for one column called label.

This is the xml structure for this field

Below is the output

I suspect it maybe due to there being 2 tags and the input tool not recognizing the same.

Will be great if anyone has faced this issue previously and guide.

Thanks in advance.

[WilliamR]

Hi @JDong ,

can you share a piece of your data?

[KostjaPwC]

Hello, 

Would be nice to see to see the Outer Xml, to see what Alteryx recognizes. Can you tick the option to return Outer xml?

All the best,

Konstantin 

[vmartinez]

Hi @JDong ,

On your input data configuration select Return Outer XML, this allows to get one column called Outer_Label, then use the XML parse tool

 https://help.alteryx.com/2019.4/XMLParse.htm

To get the fields of language

Let me know if this helps

Best,

Vianney

[JDong]

Please find the sample attached

[JDong]

Outer xml 

[WilliamR]

No issue for me with this configuration:

(If this post helps, then please consider it as the solution to help the other members find it more quickly).

[JDong]

Getting an error

[JDong]

The XML has lot of tags and is a large file.

Unable to share the full file, but label is tagged inside other tags.

Thanks

[vmartinez]

can you share the configuration that you used for the XML Parse tool?