how do i script this simpy hierarchy

[amien]

Material  Name	Material Code	Component Code
Level 1  Material	91019PC0	000000000009101900
Level 2  Material	000000000009101900	000000000002001900
Level 2  Material	000000000009101900	000000000009101911
Level 3  Material	000000000002001900	000000000002101900
Level 3  Material	000000000002001900	MU0001
Level 3  Material	000000000009101911	91667JL0
Level 3  Material	000000000009101911	000000000002001800
Level 3  Material	000000000009101911	000000000009106700
Level 3  Material	000000000009101911	000000000050049000

i don't have the component name

Hierarchy (COMPONENT_CODE,MATERIAL_CODE,??)

[#2]

Hi Amien,

try my suggestion:

Hierarchy (Component_Code, Material_Code, Component_Name)

LOAD

    *,

    Component_Code AS Component_Name

From . . .

Regards

Roland