Incremental Load Error

Mon, 07 Nov 2011 21:30:54 GMT

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;

Incremental Load Error

johnw — Mon, 07 Nov 2011 21:35:11 GMT

Perhaps use TransactionDate >= $(MaxDate)?

Incremental Load Error

Mon, 07 Nov 2011 22:00:23 GMT

Nope, that didn't do it. I originally had just ">" in the expression.

I just don't get it.

Incremental Load Error

Mon, 07 Nov 2011 22:25:50 GMT

So, its my store statement. I commented it out and the script succeeded.

So I added the "s" to tables and it worked. Weird....

topic Incremental Load Error in QlikView

Incremental Load Error

Incremental Load Error

Incremental Load Error

Incremental Load Error