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.

Developer

Accepted answers

vmartinez

Hi @JDong,

Please find attached a workflow that shows you the configuration that you can follow to be able to read the Label

configuration input tool:

Configuration Parse tool:

Let me know if you have any questions

Best,

Vianney

read_Label.yxzp

All comments

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

Sample.txt

JDong

Outer xml

JDong

Getting an error

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335