Table not found Error

[#1]

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

[Chanty4u]

can us hare ur script?

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

Transaction

[sunny_talwar]

Can you paste the rest of the script?

[awhitfield]

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

Andy

[#5]

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

[sunny_talwar]

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;

[Kushal_Chawda]

simply change your store command

store Master into Sample_QVD.QVD (QVD);