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. ParentChild 1Child 2JOHNRossAmyJACKThomasRossRockRockNull 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. Test.xml

Need help in parsing the XML

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.

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.

Screenshot 2024-04-13 040242.png

Community

Solved with XML:

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

It should help.

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

Hope this helps @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:

Thanks for the Support,

Regards,

Ashwin_99.