Get 'highest ancestor' from Child/Parent input

[B_SOLEILHAVOUP]

Hi all,

I have an input file with 2 columns : Child and Parent where we store equipment links (associations). So 'Child' and 'Parent' columns manage equipment names.

We don't know number of hierarchy levels

I would like to get an output file which contains 2 columns : EquipmentName and  Highest Ancestor. For each equipment name, i want to associate the highest parent according associations (without knowing nb of hierachies)

I'm beginner of Alteryx Designer and I don't know how to do.

Need to use Macro ?

Thank you for your advice

[alexnajm]

It is hard to recommend a solution without seeing data, but this weekly challenge may have some inspiration: Challenge #12: Creating an HR Hierarchy - Alteryx Community

[B_SOLEILHAVOUP]

I will have a look on this challenge

For information, please find attached my input file

[alexnajm · Accepted solution]

Looking at this data, the challenge will provide a great start! You'll just need to adjust the macro to accommodate your fields (done below) and increase the iteration number limit. I've done both as a start for you

[B_SOLEILHAVOUP]

Thank you for assistance 

Where I can increase the iteration number limit.? (I don't find)

[alexnajm]

View --> Interface Designer --> Properties --> Maximum Number of Iterations

[alexnajm]

Getting Started with Iterative Macros & Iterative Macro

[B_SOLEILHAVOUP · Accepted solution]

Thank you

[alexnajm]

Can you mark one of my replies as a solution? Thank you!