Hierarchy with one field

[juan_patrick]

Hi, I have a table that contains a field with this information:

h_wbs (field)

15

15.1

15.1.1

15.2

15.3

16

16.1

16.1.1

16.1.1.1

17

17.1

18

18.1

18.2

18.2.1

18.2.1.1

I want to use hierarchy to show eacho "node" inside his parent, egg: the parent of 16.1.1.1 is 16.1.1 and the parent of this is 16.1, etc

I use the function but cant resolve to show as I want!

¡Thank you very much!

[Gysbert_Wassenaar]

Something like this:

Data:
Hierarchy(Node,ParentNode,NodeName,ParentName,NodeName,Path,'/',Depth)
LOAD
  text(Node) as Node,
  text(Node) as NodeName,
  text(left(Node,index(Node,'.',-1)-1)) as ParentNode
INLINE [
    Node
    15
    15.1
    15.1.1
    15.2
    15.3
    16
    16.1
    16.1.1
    16.1.1.1
    17
    17.1
    18
    18.1
    18.2
    18.2.1
    18.2.1.1
];

[juan_patrick]

Not exactly, I want to do a tree view with expand nodes

[Gysbert_Wassenaar · Accepted solution]

Add the Path field in a listbox and enable the Show as Treeview option.

[juan_patrick]

¡Thank you very much!