Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

XML Parsing Help !

Highlighted
6 - Meteoroid

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 

Highlighted
8 - Asteroid

Gallop_0-1576840723088.png

 

Gallop_1-1576840797249.png

 

Gallop_2-1576840848827.png

Highlighted
6 - Meteoroid

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.

Highlighted
Alteryx
Alteryx

hi @Gallop ,

 

Follow the first flow of your workflow 

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

 

VianneyM_0-1576843111505.png

 

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

 

VianneyM_1-1576843166527.png

 

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

 

VianneyM_2-1576843356591.png

 

Let me know if you have questions

Best,
Vianney
Highlighted
8 - Asteroid

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

 

Gallop_0-1576846371305.png

 

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>

Highlighted
12 - Quasar

Hi @Gallop ,

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

benakesh_0-1576849754411.png

 

Highlighted
Inactive User
Not applicable

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

 

Thanks

Highlighted
Alteryx
Alteryx

Hi @Gallop,

 

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

 

VianneyM_0-1577096437990.png

 

configuration input tool:

VianneyM_1-1577096592022.png

 

Configuration Parse tool:

 

VianneyM_2-1577096745469.png

 

 

Let me know if you have any questions

 

Best,

Vianney

 

Best,
Vianney
Labels