XML Parsing Issue

[clarrock]

Hi Alteryx Community

Need help in parsing an XML File...Stuck with this one. Is it possible in Alteryx?

Attached the desired output

[atcodedog05]

_

[AngelosPachis]

Hi @clarrock ,

I've mocked up a workflow that answers your question. Let me know if that works for you.

Regards,

Angelos

[clarrock]

@AngelosPachis thank you but my input tool xml file results are as attached. How do i proceed from here?

[AngelosPachis]

Hi @clarrock ,

Do you mean that my input has some null rows and that causes an issue ?

[clarrock]

@AngelosPachis I see that each line in on a separate row in your text input file but.. . I'm getting all rows in one cell when inputting the xml file. How do I get it like yours? 

[AngelosPachis · Accepted solution]

Oh I see now. I have tweaked the workflow to use the excel file as an input @clarrock. So it will address the fact that you get all rows in one cell, hopefully that solves any issues

Regards,

Angelos