Issue with concatenate

gerrycastellino — Tue, 27 Jan 2015 00:57:01 GMT

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

Re: Issue with concatenate

Clever_Anjos — Tue, 27 Jan 2015 01:04:16 GMT

you´re passing an empty name, try populating all parameters

gerrycastellino — Tue, 27 Jan 2015 01:08:36 GMT

Nope - that didn't do it.