Help with building Hierarchy

Question

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

CHILDIMMEDIATEPARENTULTIMATEPARENT2383376502506744107934402506744101243778079344012437780244631310793440244631310290154930793440290154930793440793440793440793440793440

Desired Output:

ChildID23833765023833765023833765025067441023833765012437780238337650244631310238337650290154930238337650793440250674410250674410250674410124377802506744102446313102506744102901549302506744107934401243778012437780124377802446313101243778029015493012437780793440

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

e.g.

261002860174845700305414070174845700265420170305414070305414070305414070305414070

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)

Sample.xlsx

SrinivasanV · Answer

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

peterr_h · Answer

@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!

peterr_h · Answer

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!

image.png