topic Re: Table not found Error in QlikView

Table not found Error

Mon, 26 Jan 2026 18:19:17 GMT

If ScriptErrorCount = 0 then

STORE Transaction INTO Sample_QVD.QVD (qvd);

//Let LastExecTime = ThisExecTime;

End If

I could not able to save the qvd file,I am getting Table not found error. I am having table in the folder.Kindly help

Re: Table not found Error

Chanty4u — Fri, 01 Apr 2016 09:19:12 GMT

can us hare ur script?

or chk wit ur correct table names "it may be upper/lower case?

Transaction

Re: Table not found Error

sunny_talwar — Fri, 01 Apr 2016 09:20:09 GMT

Can you paste the rest of the script?

Re: Table not found Error

awhitfield — Fri, 01 Apr 2016 09:37:38 GMT

Please supply your entire script OR better still and example .qvw

Andy

Re: Table not found Error

Mon, 04 Apr 2016 05:11:44 GMT

Master:

LOAD Seqno,
Name,
Year,
Amount
FROM
[Incremental Load data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Max:

load max(Seqno) as maxID

resident Master;

Let vMax = peek('maxID',0,'Max');

Drop table Max;

Transaction:

join(Master)

LOAD Seqno,
Name,
Year,
Amount
FROM
[Current Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
where Seqno >'$(vMax)';

store Transaction into Sample_QVD.QVD (QVD);

Re: Table not found Error

sunny_talwar — Mon, 04 Apr 2016 09:56:16 GMT

There is no transaction table created here. You are left joining your transaction table into the master table. Are you intending to store the Master table? or if you truly want to store the transaction data, then you can try like this:

Master:
LOAD Seqno,
Name,
Year,
Amount
FROM
[Incremental Load data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Max:
LOAD max(Seqno) as maxID
Resident Master;

LET vMax = peek('maxID',0,'Max');

DROP Table Max;

Transaction:
NoConcatenate
LOAD Seqno,
Name,
Year,
Amount
FROM
[Current Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
where Seqno >'$(vMax)';

STORE Transaction into Sample_QVD.QVD (QVD);

Join(Master)

LOAD *

Resident Transaction;

DROP Table Transaction;

Re: Table not found Error

Kushal_Chawda — Mon, 04 Apr 2016 10:00:11 GMT

simply change your store command

store Master into Sample_QVD.QVD (QVD);