Hierarchy and Qualify * issue

[#1]

HI,

I am creating a hierarchy using the following statement...

Tree:

     Hierarchy (ListID, ParentID, Name)

          Load ListID, ParentID, Name Resident Customer;

It works

but as soon as I use either of the following statements then it gives error

Qualify *;

Tree:

     Hierarchy (ListID, ParentID, Name)

          Load ListID, ParentID, Name Resident Customer;

UnQualify *;

Or

Tree:

     Hierarchy (CustID, CustParentId, CName)

          Load ListID as CustID, ParentID as CustParentId, Name as CName Resident Customer;

Are these operations not allowed with Hierarchy function?

Regards,

Saurabh

[SergeyMak]

if can qualify it later

just place after your first statement

Rename table Tree to Tree_tmp;

QUALIFY *;

UNQUALIFY [your_key_field];

NoConcatenate

Tree:

LOAD *

Resident Tree_tmp;

DROP Table Tree_tmp;

Or rename fields

Rename field ListID to CustID;

Rename field ParentID  to CustParentId;

Rename field Name to CName;