Need help in parsing the XML

[Ashwin_99]

Hi All,

need a quick assistance on a small question.

I have attached a hierarchy image and xml text, 

 can i get the output in following format using alteryx.

Parent	Child 1	Child 2
JOHN	Ross	Amy
JACK	Thomas	Ross
Rock	Rock	Null

the node shown in the image will be dynamic in nature so there will be multiple child of one parent and may be no child of a parent.

please do let me know in case you need more info.

Thanks in advance.

[caltang]

Consider this post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/XML-parse-comment-or-processin... 

It should help.

[caltang]

Since I don't have the full XML, I'll just do something simple here:

Hope this helps @Ashwin_99 

[Ashwin_99]

Hi Calvin,

Apologies for not giving the full XML.

Please refer attached updated xml, and updated hierarchy please see below image,

as i can see in your workflow you had read the xml by csv but can we do it by reading it only in xml form...? 

Expected Output:

Parent	Child 1	Child 2
JOHN	Ross	Amy
JOHN	Kane	Ash
JACK	Thomas	Ross
Rock	Rock	Null

Thanks for the Support,

Regards,

Ashwin_99.

[caltang]

Solved with XML:

[Ashwin_99]

Hi Calvin,

Thanks, for the reply but its not the same as i expected.

Regards,

Ashwin.

[caltang · Accepted solution]

Woops! My bad. Forgot to group them dynamically. This should do it: