Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Table not found Error

Hi

 
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

6 Replies
sureshqv
Esteemed Contributor III

Re: Table not found Error

can us hare ur script?

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

Transaction

MVP
MVP

Re: Table not found Error

Can you paste the rest of the script?

awhitfield
Esteemed Contributor

Re: Table not found Error

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

Andy

Not applicable

Re: Table not found Error

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);

MVP
MVP

Re: Table not found Error

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

simply change your store command

store Master into Sample_QVD.QVD (QVD);

Community Browser