Help with building Hierarchy

[SrinivasanV]

I have been trying to break my head behind creating an upward hierarchy i.e. traversing from child till the ultimate parent. Some of the ultimate parents i.e. groups have as low as 2 entities in it while some have about 600 entities in it. I have tried to go through the various posts in the discussions/community page but i am not able to get any results :( any help will be highly appreciated.

In the below sample hierarchy for each of the given child i seek the following desired output

CHILD	IMMEDIATEPARENT	ULTIMATEPARENT
238337650	250674410	793440
250674410	12437780	793440
12437780	244631310	793440
244631310	290154930	793440
290154930	793440	793440
793440	793440	793440

Desired Output:

Child	ID
238337650	238337650
238337650	250674410
238337650	12437780
238337650	244631310
238337650	290154930
238337650	793440
250674410	250674410
250674410	12437780
250674410	244631310
250674410	290154930
250674410	793440
12437780	12437780
12437780	244631310
12437780	290154930
12437780	793440

The hierarchies have breaks and i would also want to identify them.

e.g.

261002860	174845700	305414070
174845700	265420170	305414070
305414070	305414070	305414070

here the reporting for "265420170" is missing

i tried to create something but i feel i am having to repeat same pattern in loops for different grouped hierarchy counts and i feel there might be a better way to do it hence reaching out in the community. Any help is highly appreciated. (unable to share the workflow due to the size of the input files)

[peterr_h]

Hi,

I'm not able to work on a solution yet due to current work restrictions, however, have you tried the 'Make Group' tool?

If you look at the one-tool example (right-click on the tool and select this option), it looks at least slightly related to what you appear to be doing.

Hope this helps, best of luck!

[peterr_h]

@SrinivasanV,

Disregard my previous response.

If you look at this discussion post that I put up recently:

Solved: Re: Data Sequencing based on Current & Previous ID... - Alteryx Community

It appears to be the same issue that I was having - I had Current Task ID and Previous Task ID, just like you have Child and Parent.

The solution provided by @CoG on that thread was perfect for me, and I believe should work for you in this case too.

Best of luck!

[SrinivasanV]

I tried to follow that but am getting error at multiple steps :(