Hierarchy with Path delimiter

[jduluc12]

Hi,

I have field in the table.

it has data like

A

A:B

A:B:C

A:B:C:D

A:B:C:D:E

A:B:C:D:E:F

I want to create a hierarchical table for this field.

How can i do that?

[prma7799]

Check this

Unbalanced, n-level hierarchies

Hierarchy Parameters ‒ QlikView

[Anonymous]

You can use something like that:

FULL_FILES:

LOAD

     FullPath,

     SubField(FullPath, ':', -1 ) as NodeName,

     SubField(FullPath, ':', -2 ) as ParentNode

Resident ***** ;

After that you can use the hierarchy function do do whatever you want.

(Assuming the naming are unique and could be used as ID)