Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Settu,
Thanks for your time. I am just wondering the way to create the id.
ie the nodeid and parentid.
Thanks!