Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to implement incremental load. Can someone tell me why this code is not working? A straight load works just fine. I'm not sure what I'm missing.
Temp_Transactions:
LOAD Max(TransactionDate) as Max_Day
FROM
[..\QVD\Transactions.qvd](qvd);
let MaxDate = peek('Max_Day',-1,Temp_Transactions);
drop table Temp_Transactions;
Transactions:
LOAD StoreID,
TellerID,
CustomerID,
TransactionID,
ID,
TransactionDate,
TransactionType,
TransactionUnits,
TransactionAmount,
TransactionFees,
TransactionSalesTax,
TransactionDesc,
MakerBankRouter,
CheckTypeCode,
CorpID,
MiscCode,
UBCode,
CouponCode
FROM
[..\QVD\Transactions.qvd](qvd);
Concatenate
LOAD StoreID,
TellerID,
CustomerID,
TransactionID,
ID,
TransactionDate,
TransactionType,
TransactionUnits,
TransactionAmount,
TransactionFees,
TransactionSalesTax,
TransactionDesc,
MakerBankRouter,
CheckTypeCode,
CorpID,
MiscCode,
UBCode,
CouponCode;
SQL SELECT *
FROM QlikViewDB.dbo."dbo_Transactions"
where TransactionDate = $(MaxDate);
Store Transactions into ..\QVD\Transactions.qvd;
Drop Table Transactions;
So, its my store statement. I commented it out and the script succeeded.
So I added the "s" to tables and it worked. Weird....
Perhaps use TransactionDate >= $(MaxDate)?
Nope, that didn't do it. I originally had just ">" in the expression.
I just don't get it.
So, its my store statement. I commented it out and the script succeeded.
So I added the "s" to tables and it worked. Weird....