How to create Hierarchy ?

[hemanthaanichet]

Hi All,

I would like to create a hierarchy for the below scenario 

Top level is Country Head like below

Country Head

       ->State Head

                  ->City Head

                            ->Area Head

Country Head	State Head	City Head	Area Head
Mario	Mario	Mario	Mario
Mario	Sara	Sara	Sara
Mario	Sara	Peiris	Peiris
Mario	Sara	Peiris	Dumi
Mario	Sara	Peiris	Rashm
Mario	Sara	Peiris	Randa
Mario	Saura	Saura	Saura
Mario	Saura	Chaim	Chaim
Mario	Saura	Chaim	Nira
Mario	Saura	Chaim	Ovitiga
Mario	Saura	Chaim	Sani

Regards

Hemanth

[el_aprendiz111]

Hi,

1 Option:

=[Country Head] & '/' & [State Head] & '/' &  [City Head] & '/' &  [Area Head]

[hemanthaanichet]

I need this in edit script... Using hierarchy function kind off....

[sharpjoki]

Hi.

Change the table in the script to this:

TreeElements:

LOAD * INLINE[

Element     Parent

Mario          -

Sara           Mario

Peiris          Sara 

Dumi          Peiris

Rashm        Peiris    

Randa         Peiris

Saura          Mario

Chaim        Saura

Nira           Chaim

Otiviga       Chaim

Sani          Chaim

Then apply the function Hierachy:

Hierarchy(Element, Parent, , , 'TreeElement')

LOAD

     Element,

     Parent

Resident TreeElements;

Then display the TreeElement field as listbox, selecting the "Show as Tree view", as in example above.

[woshua5550]

What is your original data looks like ?

[techvarun]

Hierarchy function easy and Efficient with example---

[techvarun]

Check the attached

[hemanthaanichet]

The data has to be look like below:

->Mario

    ->Sara

         ->Peiris

                 ->Dumi

                 ->Rashm

                 ->Randa

   ->Saura

          ->Chaim

                 ->Nira

                 ->Ovitiga

                  ->Sani

[woshua5550]

can you attach a Excel file which contains your sample data ? just want to make sure the data format you have

[hemanthaanichet]

Dave sample file for you