concatenate table not found

[mandilicious]

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 Script	2 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.qvd	Data1:
(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;

[sunny_talwar]

Are you running these in two different applications for some reason?

[stigchel · Accepted solution]

Because you drop the table Agent in Script1??

DROP Table AGENT;

[Gysbert_Wassenaar]

Remove this line:

DROP Table AGENT;

What that line does is drop the table AGENT. So by the time you want to concatenate data to that table it doesn't exist anymore.

[mandilicious]

Hi Sunny T

is one application.

Thanks

[mandilicious]

Thanks I removed DROP Table AGENT but still complained about below even if I didn't drop it in my first script.

Data1:
(qvd);	LOAD CommonDate,
	BUCKET_START,
	SERVICE_NUMBER,
	Key1
DATA:	Resident Queue;

[mandilicious]

Thanks it works.