topic Re: Hierarchy with Path delimiter in QlikView

Hierarchy with Path delimiter

jduluc12 — Thu, 29 Jun 2017 12:36:40 GMT

Hi,

I have field in the table.

it has data like

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 — Thu, 29 Jun 2017 12:38:09 GMT

Check this

Anonymous — Fri, 11 May 2018 14:02:57 GMT

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)