Customer Hierarchy issue script

[alex59800]

Hi all,

Here is a challenge for scripts experts concerning Hierarchy issue. To be as clear as possible, i attach an excel with my question. Thanks a lot guys for your answer.

Alex

[alex59800]

please ? anyone could help me ?

Thanks a lot

[#3]

Use the above script and

HIER:

LOAD [HIERARCHY (Father)] as ParentID,

     [HIERARCHY (Son)] as NodeID,

     [HIERARCHY (Father)] as NodeName

FROM

Hier.xlsx

(ooxml, embedded labels, table is Sheet1);

HIERFINAL:

Hierarchy(NodeID, ParentID, NodeName)

Load

*

Resident HIER;

Concatenate('HIERFINAL')

LOAD

DISTINCT

NodeName1,

NodeName1 as NodeID

Resident HIERFINAL;

drop table HIER;

Create a table box with NodeName1, NodeName2, NodeName3, NodeID to see the output