how in function hierarchy in NodeName columns fields load only PathName ?

[#1]

Hello all

I just have problem

How in function hierarchy in NodeName columns fields load only PathName ?

Example :

column1 - All;column2 - All/; column3 - All//; column4 - All///; column5 - All////

column1 - All;column2 - All/Group1; column3 - All/Group1/; column4 - All/Group1//; column5 - All/Group1///

column1 - All;column2 - All/Group1; column3 - All/Group1/Subgroup1; column4 - All/Group1/Subgroup1/; column5 - All/Group1/Subgroup1//

column1 - All;column2 - All/Group1; column3 - All/Group1/Subgroup2; column4 - All/Group1/Subgroup2/Item1; column5 - All/Group1/Subgroup1/Item1/

column1 - All;column2 - All/Group1; column3 - All/Group1/Subgroup2; column4 - All/Group1/Subgroup2/Item1; column5 - All/Group1/Subgroup1/Item2/

Thanks for answers

[SunilChauhan]

why not you use

field1&'/'&field2&'/'field3......   as hierarchy  

then take in listbox

general-check show as treeview -> with seperator    / or any seperator you want

[#3]

Hi Sunil

Thanks for answer

I just load data

Group:

hierarchy(Child ,Parent,Name,,,'Path',,Depth)

LOAD Child
     ,Parent
     ,Name

resident  
Group_temp

And columns (Name1,Name2...) generate from 5 to 10 depending database

Many thanks

Vilgis