6 Replies Latest reply: Oct 5, 2016 4:54 AM by Manti Phillip RSS

    concatenate table not found

    Manti Phillip

      Hi Good People

      I am having an issue on below scripts.

      1 script run successfully but 2 script failed with this below error message.

       

      Table not found

      Queue:

      Concatenate(AGENT)

      LOAD Date(Date#(DATE,'YYYYMMDD')) as CommonDate,

           BUCKET_START,

           SERVICE_NUMBER,

           STATISTIC,

           STATISTIC_VALUE,

           RecNo() as Key1

      FROM

      Q.qvd

      (qvd)

       

       

       

         

      1 Script2 SCRIPT
      AGENT:Queue:
      LOAD Date(Date#(DATE,'YYYYMMDD')) as CommonDate, Concatenate(AGENT)
           BUCKET_START, LOAD Date(Date#(DATE,'YYYYMMDD')) as CommonDate,
           SERVICE_NUMBER,      BUCKET_START,
           SERVICE_POINT_NAME, SERVICE_NUMBER,
           TEAM_NAME,      STATISTIC,
           AGENT_NAME,      STATISTIC_VALUE,
           EMPLOYEE_NUMBER,      RecNo() as Key1
           STATISTIC,FROM
           STATISTIC_VALUE,Q.qvd
           RecNo() as Key(qvd);
      FROM
      A.qvdData1:
      (qvd);LOAD CommonDate,
      BUCKET_START,
           SERVICE_NUMBER,
      Key1
      DATA:Resident Queue;
      LOAD CommonDate,
           BUCKET_START, ISLAND:
           SERVICE_NUMBER, Generic LOAD Key1,
           SERVICE_POINT_NAME, STATISTIC,
           TEAM_NAME,      STATISTIC_VALUE
           AGENT_NAME, Resident Queue;
           EMPLOYEE_NUMBER, DROP Table Queue;
      Key
      Resident AGENT;FOR i = NoOfTables()-1 to 0 STEP -1
        LET vTable=TableName($(i));
      ISLAND:  IF WildMatch('$(vTable)', 'ISLAND.*') THEN
      Generic  LOAD Key,    LEFT JOIN (Data1) LOAD * RESIDENT    [$(vTable)];
      STATISTIC,    DROP TABLE  [$(vTable)];
           STATISTIC_VALUE  ENDIF
      Resident AGENT;NEXT i
      DROP Table AGENT;
      STORE Data1 into Queue.qvd(qvd);
      FOR i = NoOfTables()-1 to 0 STEP -1 DROP Table Data1;
        LET vTable=TableName($(i));
        IF WildMatch('$(vTable)', 'ISLAND.*') THEN EXIT Script;
      LEFT JOIN (DATA) LOAD * RESIDENT    [$(vTable)];
          DROP TABLE  [$(vTable)];
        ENDIF
      NEXT i
      STORE DATA into Agent.qvd(qvd);
      DROP Table DATA;