Incremental Load Error

[#1]

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;

[johnw]

Perhaps use TransactionDate >= $(MaxDate)?

[#3]

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

I just don't get it.

[#4 · Accepted solution]

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

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