topic Incremental Load Issues in QlikView

Incremental Load Issues

Anonymous — Tue, 02 Jan 2018 17:40:09 GMT

Hi everyone

I'm using Qlik Sense since 3 months and i'm new using BI tools.

In this moment im trying to use the incremental Loads but for some reason doesn't work.

In theory the incremental load need to work by dates (Fecha column) for identify the last load but when i make the conditional

WHERE Fecha > $(vUltimaCarga);

Doesn't works the script load all the information from the .xlsx fiel

I post my script and the excel

Thanks!

Re: Incremental Load Issues

mdmukramali — Tue, 02 Jan 2018 17:50:33 GMT

Hi,

Unable to download Script file so please can you attach it again.

Thanks,

Mukram

Re: Incremental Load Issues

m_woolf — Tue, 02 Jan 2018 17:52:01 GMT

You didn't say what the value of vUltimaCarga is, so here is a guess:

WHERE Fecha > '$(vUltimaCarga)';

Re: Incremental Load Issues

pradosh_thakur — Tue, 02 Jan 2018 17:54:51 GMT

try this

WHERE Fecha > '$(vUltimaCarga)';

Re: Incremental Load Issues

Anonymous — Tue, 02 Jan 2018 18:11:15 GMT

I do the change but is the same problem, it concatenate the new data but with the condition of the id no from the date's row

Re: Incremental Load Issues

mdmukramali — Tue, 02 Jan 2018 18:12:50 GMT

Hi,

Can you check the below Script:

Temp:

LOAD

Max(Fecha) as LastModificationDate

FROM

(qvd);

LET LastModificationDate=Date(Peek('LastModificationDate',0,'Temp'));

DROP Table Temp;

Data:

LOAD id,

first_name,

last_name,

email,

gender,

ip_address,

Fecha

FROM

(ooxml, embedded labels, table is data)

Where Date(Fecha)>'$(LastModificationDate)';

Concatenate

LOAD id,

first_name,

last_name,

email,

gender,

ip_address,

Fecha

FROM

(ooxml, embedded labels, table is data)

Where NOT Exists(id);

STORE Data into D:\QVW Files\qvds\Data.Qvd(qvd);

Re: Incremental Load Issues

m_woolf — Tue, 02 Jan 2018 18:16:41 GMT

What is the contents of vUltimaCarga) and what kind of data is in Fecha?

Re: Incremental Load Issues

Anonymous — Tue, 02 Jan 2018 18:45:05 GMT

Fecha are dates and the variable vUltimaCarga is the number that the function peek send