Issue parsing XML file that is a saved as TXT

[Wafarian]

Hi,

I am unable to parse XML file that we received from a server. the file is saved as XXX.xml.txt

below is my workflow, config settings and errors.

[Yoshiro_Fujimori · Accepted solution]

Hi @Wafarian ,

Thank you for the data. It makes the discussion more effective.

I tried to parse it as below. Please let me know if this is close to your needs.

Workflow

Summarize tool puts the rows into one cell together.

1st XML Parse tool focuses on "Item" tag as you says you don't need data in "Head" tag.

2nd XML Parse tool parses all the tags under "Amount" tag.

Output

[Wafarian]

Hi,

wow. thank you very much. that is exactly what I need. by the way, way the aggregation as I didn't quite get it.

thanks,

[Yoshiro_Fujimori]

Hi @Wafarian ,

I am glad to know you get to the solution.

>the aggregation as I didn't quite get it.

You mean the Summarize tool?

I used Summarize tool to put the rows all together into one row,

See Alteryx Help: https://help.alteryx.com/20223/designer/summary-processes#string

with each original row separated by new line (represented by "\n"),

so that XML Parse tool can deal with the data as one chunk of XML data.

I hope I answered to your question.