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: 
Not applicable

Regarding Hierarchy

Dear Friends,

I appreciate your time. I am trying to build a  hierarchy for the following script but not sure how to proceed further. Kindly have a look at the below script or attached application and please let me know.

Demo:

Load * Inline [

Country,State,City

Canada,Ontario,Toronto

Canada ,Alberta,Edmonton

US,Missouri,SaintLouis

India,TamilNadu,Coimbatore

India,Karnataka,Bangalore

];

Demo1:

Load

City,

State,

Country,

AutoNumber(City) as CityId,

AutoNumber(State) as StateId

Resident Demo;

Drop table Demo;

Hierarchy(CityId,StateId,City)

Load

CityId,

StateId,

City,

State,

Country

Resident Demo1;

I am not pretty sure how to create the corresponding nodeid,parentid and link accordingly. Kindly share your ideas!

Thanks so much!

Kiru

2 Replies
settu_periasamy
Master III
Master III

Hi,

Did you check this?

Hierarchy and Hierarchy Belongs to

Not applicable
Author

Hi Settu,

Thanks for your time. I am just wondering the way to create the id.

ie the nodeid and parentid.

Thanks!