hierarchies in load script

[Anonymous]

Hi

I want to create a hierarchy in my script. I have his table:

salesman city region sales

And I want to create this hierarchy: region -> city -> salesman

I want to use it in a listbox or doing selections

I don' want a ciclic group I need a hierarchy in the scrit.

How can I do it?

Can you give an example of script?

Thanks in advanve

[avinashelite]

Hi

please find the example script below:

Hierarchy(NodeID, ParentID, NodeName) LOAD

NodeID,

ParentID,

NodeName,

Attribute

FROM table

you need to have a relational table with nodeid and its parent id to achieve the Hierarchy

[avinashelite]

check this document :