Trying to do a simple concatenate between Table1 and my hierarchy table:
Getting attached error
Table1:
LOAD * INLINE [
Location1
Location2
Location3
Location4
Location5
Location6
Location7
Location8
Location9
Location10
Location11
Location12
Location13
Location14
Location15
];
concatenate (Table1)
[TMP_FRY14A]:
Hierarchy(ChildID, ParentID, Location, ParentLocation, , Path, \, NodeDepth)
load
NODE_ID as ChildID,
PARENT_ID as ParentID,
NAME as Location,
IS_LEAF,
PRIORITY,
IS_DEFAULT,
HIERARCHY_CATEGORY,
HIERARCHY_NAME
FROM [$(Parameters_Path_Qvd_Data)\FRY14A.qvd](qvd);
