Parent Child Relationship hirarchy

[priyarane]

Hi Community,

I have data like below.

Node_ID	Parent_ID
Ax00	B000
Ax01	Ax00
Ax02	Ax00
Ax03	Ax00
Ax04	Ax03
Ax05	Ax03
Bx06	Ax02
Bx07	Ax02

and I am looking like below

Parent	Child1	Child2	Child3
B000	Ax00
Ax00	Ax01	Ax02	Ax03
Ax01
Ax02	Bx06	Bx07
Ax03	Ax04	Ax05

Can some one help me to get loop/hirarchy for the above example.

-Priya

[swuehl]

You can look into the HIERARCHY and HIERARCHYBELONGSTO LOAD prefixes to transform your table:

Hierarchies

This will not exactely reproduce your output table, but will return tables that can be used well in QV analysis.

[raju_insights]

Hi Priya,

Hope this helps.

PFA