12 Replies Latest reply: Feb 6, 2014 2:21 AM by Manoj Kulkarni RSS

    Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

    Shivendoo Kumar

      Hi All,

      Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script. Please correct the Script if any syntax error.

       

      I am getting ERROR:"Table not found CONCATENATE LOAD * RESIDENT DIM_ADMIN_DATA"

       

      DIM_USER_DATA:

      LOAD

      'USER' END AS ACCESS,

      [EMP NAME] AS USERID,

      [EMP NAME] AS PASSWORD,

      EMP_KEY AS _EMP_KEY

      FROM DIM_EMP_DATA.QVD (qvd);

       

       

      DIM_ADMIN_DATA:

      LOAD * INLINE

      [

          ACCESS, USERID, PASSWORD, _EMP_KEY

          ADMIN,  ADMIN,  ADMIN,    *

      ];

       

      Section Access;  /* Start section access script */

       

      LOAD *

      RESIDENT DIM_USER_DATA;

      CONCATENATE

      LOAD *

      RESIDENT DIM_ADMIN_DATA;

       

      Section Application; /* End section access script */