Hierarchy belong to script error

[vikasmahajan]

Dear all

Following is my script I am getting script error  what could be problem in script , I want to try belongs to option.

Vikas

HierarchyTemp:

HIERARCHY(CHILD_ID, PARENT_ID, [HQ], [Parent Name], [HQ], [Path Name], '/')

LOAD Hqid AS [HQ Code],

     Hqname AS [HQ],GeoLevelName AS [Level Name],

     CHILD_ID, PARENT_ID,

     Sgid as [Sales Group Code],

     GeoCount ,

     Rmcount,

     [EmpName],

     [Email]

FROM

[..\Qvds\DIM_GeoHQMaster.qvd]

(qvd);

Ancestor_Table:

HierarchyBelongsTo (CHILD_ID,PARENT_ID, [HQ],Ancestor_ID,Ancestor_Name,DepthDiff)

LOAD

     Distinct

     [HQ Code],

  [HQ] ,

  [EmpName]

RESIDENT HierarchyTemp;

drop table HierarchyTemp;

[matthewjbryant]

HI Vikas. What's the error?

[matthewjbryant]

In the information I've been reading lately it seems you would generally only have one connected column between these two tables (i.e. Parent_ID and [HQ] need changing in Ancestor_Table.

I don't think that's the source of the error though.

[vikasmahajan]

resolved with by putting CHILD_ID in

Ancestor_Table:

HierarchyBelongsTo (CHILD_ID,PARENT_ID, [HQ],Ancestor_ID,Ancestor_Name,DepthDiff)

LOAD

     Distinct

    CHILD_ID,

     [HQ Code],

  [HQ] ,

  [EmpName]

RESIDENT HierarchyTemp;

drop table HierarchyTemp;

Solve my error.

Thanks

Vikas