topic Re: Incremental Load Error in QlikView

Incremental Load Error

Anonymous — Fri, 15 May 2015 13:15:28 GMT

I have the following Incremental Load script running. It runs and does increment the QVD, but I get an error that pops up and by clicking OK, it proceeds and completes.

This is the INCREMENTAL SETUP script:

This is the error that I am receiving

Thanks in advance for your help!

Dan

Re: Incremental Load Error

Anonymous — Fri, 15 May 2015 13:17:00 GMT

These are the fields being loaded

Data Load Script:

$(datatable):

Directory;

LOAD DATE,

DIFFERENCE,

[Reconcilation Time],

Date_updated

FROM

[..\Data\Bank_Lockbox2.xlsx]

(ooxml, embedded labels, table is [Sheet1 (2)]);

$(INCREMENTAL_EXP)

;

Re: Incremental Load Error

Clever_Anjos — Fri, 15 May 2015 14:11:26 GMT

You are mixing names

Date <> DATE

Please use same name on lines "LOAD MAX" and "LET INCREMENTAL"

Re: Incremental Load Error

Anonymous — Fri, 15 May 2015 16:39:57 GMT

Clever,

I dont fully understand what you mean, but I tried several combinations and still getting errors- see below.

Dan

Re: Incremental Load Error

Anonymous — Fri, 15 May 2015 17:16:30 GMT

Clever,

I got it to work! Thanks for the help!