Convert table columns into hierarchical structure

[qliklearnervir]

I have 1 table like the below structure :

Org:

ID

Level1

Level2

Level3

Level4

Level5

Level6

Now i want to create a hierarchy to show data like Level1--> Level2-->Level3...........-->Level6 

and want to connect with other tables with ID field.

finally, I want to create a perfect pivot table with these hierarchical columns.

please suggest.

[Brett_Bleess]

Have a look at the following Design Blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

If that does not quite get you there, here is the base URL for this area you can use to further search the other 700+ posts there, hopefully you can find something further to get you the rest of the way.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[Saravanan_Desingh]

You need Parent and Node column. Based on your data,  I have created as below.

Org:
Hierarchy(ID, [Parent ID],Node,,ID)
LOAD *, ID As Node INLINE [
    ID, Parent ID
    Level1, 
    Level2, Level1
    Level3, Level2
    Level4, Level3
    Level5, Level4
    Level6, Level5
    Level7, Level3
];

[Saravanan_Desingh]

Please check my document for various options with example...

https://community.qlik.com/t5/QlikView-Documents/Hierarchy-LOAD-under-various-Arguments/ta-p/1486215