Hierarchy data with Iterative Macro

[BRRLL99]

Hi

I have data with 1.6 million rows, sample data I'm looking to break hierarchy data into multiple levels

Parent	Child
A	B
B	C
C	E
D	F
E	G

Expected Output:

Name
A	B	C	E	G
B	C	E	G
C	E	G
D	F
E	G

[Yoshiro_Fujimori]

@BRRLL99 ,

If you have to deal with 1.6 million rows of data regularly, using Relational Database may not be the best option,

considering the required computer resources, flexibility of data manipulation and the processing time etc..

You may want to consider using Graph Database (such as Neo4j).

[BRRLL99]

Could you please build workflow for the above dataset

[PhilipMannering · Accepted solution]

Hey @BRRLL99 , I think this does what you need.. See attached

[Yoshiro_Fujimori · Accepted solution]

@PhilipMannering ,

Thank you for the smart solution.

The use of Engine Iteration Number is so cool!

@BRRLL99 ,

I suppose this may be already off the topic, so just FYI.

It may also be interesting to see it as a Linked Data structure.

Here is an output of your data from Network Analysis tool.