Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panipat1990
Creator II
Creator II

Help me on Creating Hierarchy in Data !!!

Hi Team,

I have to make a hierarchy b/w Parent and Child Values/ID.

I have two columns in my Data. One is Parent ID and 2nd is Child ID. See in attached screenshot.

Based on dummy data which i attached here , needed to create 4 Hierarchy level as 4 columns.

Kindly suggest/help me how can i create hierarchy columns.

Thanks

Gourav

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

you can use this script

Hierarchy(Child_ID, Parent_ID, Title, ParentName, Title, PathName, '\', Depth)

LOAD Child_ID,

     Parent_ID,

     text(Child_ID) as Title

FROM

(ooxml, embedded labels, table is Sheet1);

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

you can use this script

Hierarchy(Child_ID, Parent_ID, Title, ParentName, Title, PathName, '\', Depth)

LOAD Child_ID,

     Parent_ID,

     text(Child_ID) as Title

FROM

(ooxml, embedded labels, table is Sheet1);