Hierarchy and Qualify * issue

Thu, 22 May 2014 01:35:30 GMT

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 *;

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

Re: Hierarchy and Qualify * issue

SergeyMak — Thu, 22 May 2014 01:51:12 GMT

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;