Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Good People
I am having an issue on below scripts.
1 script run successfully but 2 script failed with this below error message.
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; | |
Are you running these in two different applications for some reason?
Because you drop the table Agent in Script1??
DROP Table AGENT;
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.
Hi Sunny T
is one application.
Thanks
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; |
Thanks it works.