topic Re: Incremental load (update 7 past month) in QlikView

Incremental load (update 7 past month)

Anonymous — Tue, 08 Jan 2013 10:15:04 GMT

Hello

I want to do an incremental load. From the basis qvd I want to take everything earlier then 7 month (7*30 days) and then find out the highest ID.

is this script correct?

LOAD

lMacStaRef,
Beginn

FROM
..\..\02_Data\Result1.qvd
(qvd) where (Interval(Now() - Beginn) >= 210);

Let UpdateID = Max (lMacStaRef);

Thx in advance

Re: Incremental load (update 7 past month)

adamwilson — Tue, 08 Jan 2013 10:35:07 GMT

try:

where (Interval(Now() - Beginn, 'd' ) >= 210);

Re: Incremental load (update 7 past month)

Anonymous — Tue, 08 Jan 2013 10:39:10 GMT

thx,

how can I test whether QlikView selected the (right) ID??

I wanted to show the variable with

Load

MsgBox($(UpdateID) as x

Resident Tab;

But sth was wrong. Any idea??

Cheers //chesterluck

Re: Incremental load (update 7 past month)

adamwilson — Tue, 08 Jan 2013 11:04:39 GMT

this should put the max lMacStaRef in the UpdateID variable:

Tab:

LOAD

lMacStaRef,

Beginn

FROM

..\..\02_Data\Result1.qvd

(qvd)

where (Interval(Now() - Beginn, 'd' ) >= 210);

Temp:

LOAD

Max(lMacStaRef) as x

RESIDENT Tab;

LET UpdateID = peek('x',-1,'Temp');

Drop Table Temp;

Re: Incremental load (update 7 past month)

Anonymous — Tue, 08 Jan 2013 13:59:39 GMT

Thanks

To show use MsgBox ('$(UpdateID)')

FullSolution:

Tab:

LOAD

lMacStaRef,

Beginn

FROM

..\..\02_Data\Result1.qvd

(qvd)

where (Interval(Now() - Beginn, 'd' ) >= 210);

Temp:

LOAD

Max

(lMacStaRef) as x

RESIDENT Tab;

LET UpdateID = peek('x',-1,'Temp');

Next:

Load

MsgBox ( '$(UpdateID)') as t

Resident Temp;

Drop Temp;