Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can us hare ur script?
or chk wit ur correct table names "it may be upper/lower case?
Transaction
Can you paste the rest of the script?
Please supply your entire script OR better still and example .qvw
Andy
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);
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;
simply change your store command
store Master into Sample_QVD.QVD (QVD);