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

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

Macro.yxmc