Regarding Hierarchy

[#1]

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

[settu_periasamy]

Hi,

Did you check this?

Hierarchy and Hierarchy Belongs to

[#3]

Hi Settu,

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

ie the nodeid and parentid.

Thanks!