Hierarchy Load

[kamalqlik]

Hi Friend,

I want to implement Hierarchy for the Fingrp table.

ParCode is the parent Code.

Grpcode will be the child node.

I want the hierarchy upto level 3 for this.

Regards

Kamal

[hic · Accepted solution]

Just use

Hierarchy (GRPCODE, PARCODE, GRPNAME, ParentName, GRPNAME, Path, '/', Depth)

LOAD * from FINGRP.qvd (qvd);

It will load all 5 levels, but by selecting 1,2,3 in the Depth field, you will see just the first three levels.

HIC