2 Replies Latest reply: Jan 26, 2015 8:08 PM by gerry castellino RSS

    Issue with concatenate

    gerry castellino

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