N-level hierarchy

[#1]

i have one problm pls help me...  this is  N-level hierarchy below fields. in script level i want N-level hierarchy script

PSPHI

UP

POSNR

RIGHT

[#2]

Can you please explain the requirement clearly with sample data.

[HirisH_V7]

Hi,

May be like this,

Table:

Hierarchy (PSPHI,UP,POSNR,RIGHT QuantityPath, '/', Depth)

LOAD PSPHI,

  PSPHI as UP,

  POSNR,

  Text(RIGHT) as RIGHT

FROM BOM.xlsx (ooxml, embedded labels, table is Sheet1);

HTH,

-Hirish

[MarcoWedel]

please close some of your open threads by selecting correct answers (or thread assumed answered).

thanks

regards

Marco