Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Get 'highest ancestor' from Child/Parent input

B_SOLEILHAVOUP
7 - Meteor

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

8 REPLIES 8
alexnajm
17 - Castor
17 - Castor

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
7 - Meteor

I will have a look on this challenge

For information, please find attached my input file

alexnajm
17 - Castor
17 - Castor

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
7 - Meteor

Thank you for assistance 

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

alexnajm
17 - Castor
17 - Castor

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

B_SOLEILHAVOUP
7 - Meteor

Thank you

alexnajm
17 - Castor
17 - Castor

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

Labels
Top Solution Authors