Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

gerrycastellino
Contributor III

Issue with concatenate

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

Tags (1)
2 Replies
Employee
Employee

Re: Issue with concatenate

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

gerrycastellino
Contributor III

Re: Issue with concatenate

Nope - that didn't do it.

Community Browser