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.

[KostjaPwC]

Hello, 

Probably a stupid question, but you did you parse on the Label_OuterXML field? Because looks like previously you had the right format data there.

All the best,

Konstantin 

[JDong]

[KostjaPwC]

You have to enable option 8 in the import "Return outer XML" and then in parse change radio button to auto detect child and parse on field outer xml.

[VianneyM]

hi @JDong ,

Follow the first flow of your workflow 

On the input data tool activate option 8 : Return Outer XML

This will generate that in the output you get a column called Label_OuterXML

Now within the same flow use the XML parse tool and configure it like this

Let me know if you have questions

[JDong]

Tried the same settings but  I see this to be the output

Other columns needed in the data set are fine. Please let me know in case of any questions

<TEST>
<i>10</i>
<Con>Sample1</Con>
<ID ColumnIndex="10">Category</ID>
<Label>
<Label Language="Spanish">Apple</Label>
<Label Language="English">Orange</Label>
</Label>
<Typ>Li</Typ>
<Tbl>Main</Tbl>
<Col>dependent</Col>
<SearchCol>no</SearchCol>
<ParentElementID>dxc</ParentElementID>
<ReferenceTable>ref</ReferenceTable>
<Ref>no</Ref>
<ReadOnly>false</ReadOnly>
<Required>false</Required>
<SingleSelectSearch>false</SingleSelectSearch>
<DisplayStyle>default</DisplayStyle>
<SectionRow>5</SectionRow>
<SectionColumn>5</SectionColumn>
<WidthUnits>2</WidthUnits>
<HeightUnits>1</HeightUnits>
</TEST>
<TEST>
<idx>11</idx>
<Con>Sample</Con>
<ID ColumnIndex="11">id</ID>
<Label>
<Label Language="Spanish">abc</Label>
<Label Language="English">abcd</Label>
</Label>
<Typ>Li</Typ>
<Tbl>main</Tbl>
<Col>dependent</Col>
<SearchCol>no</SearchCol>
<ParentElementID>dxc</ParentElementID>
<ReferenceTable>ref1</ReferenceTable>
<Ref>no</Ref>
<ReadOnly>false</ReadOnly>
<Required>false</Required>
<SingleSelectSearch>false</SingleSelectSearch>
<DisplayStyle>default</DisplayStyle>
<SectionRow>6</SectionRow>
<SectionColumn>1</SectionColumn>
<WidthUnits>2</WidthUnits>
<HeightUnits>1</HeightUnits>
</TEST>

[benakesh]

Hi @JDong ,

I am reading this as  text file with no delimiter  \0  and  using xml parsing tool.

[Inactive User]

Can anything be done with existing Excel ? I get file regularly as excel

Thanks

[VianneyM · Accepted solution]

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