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.
Solved! Go to Solution.
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
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.
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
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>
Can anything be done with existing Excel ? I get file regularly as excel
Thanks
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