topic Re: concatenate table not found in QlikView

concatenate table not found

mandilicious — Thu, 29 Sep 2016 08:33:37 GMT

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;

sunny_talwar — Thu, 29 Sep 2016 15:54:16 GMT

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

stigchel — Thu, 29 Sep 2016 15:55:05 GMT

Because you drop the table Agent in Script1??

DROP Table AGENT;

Gysbert_Wassenaar — Thu, 29 Sep 2016 15:59:24 GMT

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 — Thu, 29 Sep 2016 16:06:47 GMT

Hi Sunny T

is one application.

Thanks

mandilicious — Fri, 30 Sep 2016 05:16:27 GMT

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

mandilicious — Wed, 05 Oct 2016 08:54:50 GMT

Thanks it works.