topic Re: Only load scipt if field update = today in QlikView

Only load scipt if field update = today

Wed, 26 Nov 2014 13:56:17 GMT

How can i write the script so that it only continue to load if the field UpDate in the database is the same as Date(Toay())?

I have tested this but don´t get it to work.

Tmp:

Load

Dat,

Info;

SQL Select *

From DB...

Tmp2:

Load

Max(Date(Dat)) as MaxDat

Resident Tmp where Info = 'OK';

Drop table Tmp;

If(Date(MaxDat) = Date(Today()) then.

Load....

Else

Exit script;

EndIf

Re: Only load scipt if field update = today

Gysbert_Wassenaar — Wed, 26 Nov 2014 14:29:34 GMT

Tmp:

SQL Select max(Dat) as MaxDat

From DB...

Where Info = 'OK';

Let vMax = num(peek('MaxDat'));

IF $(vMax) = num(today()) THEN

// do stuff

ELSE

exit script;

ENDIF;

Re: Only load scipt if field update = today

its_anandrjs — Wed, 26 Nov 2014 14:32:41 GMT

Hi,

Add a variable to capture the latest update date and load this ways

Load

Dat,

Info;

SQL Select *

From DB...

Tmp2:

Load

Max(Date(Dat)) as MaxDat

Resident Tmp where Info = 'OK';

Drop table Tmp;

LET vMax = peek('MaxDat',0,'Tmp2');

If vMax = Date(Today()) then

LOAD....

Else

Exit script;

EndIf

Regards

Anand