ensure to load daily updated records

[#1]

Dear QlikView community

how can I ensure that every day the daily updated records are loaded into my QlikView.

Qlikview loads every day with the daily updated records. Unfortunately, it happens quite frequently that the interface software that provides us with old records.

Exits a mechanism in Qlikviewscript that monitors the loaded values and send ( by incident in case of missing updated records) an email ?

Thank you !

Best Regards,

[#2]

Hi ,

If you have the date column while extracting check the condition as date(today()-1) so that it only updates based on the date ..

Regards,

Chakravarthy.

[Anonymous]

You can use the ReloadTime() function, this returns the date and time of the last reload.

Something like:

Date(ReloadTime()) <> Date(today())

[#4]

Hi

ok, but how can i set a variable during the load process of my csv if a condition is true ?

Like this ? Thank you for any help

****************************************************************************************************************

Effective:
LOAD Datum,
if(Datum = '07.01.2011', myVar = 'true', Datum) as DatumCheck,
Impressions

FROM
test.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

****************************************************************************************************************

[#5]

no idea ? Please help

[prieper · Accepted solution]

You may store the timestamp of the previous file and compare it with the actual. If the actual is the same, make an alert.

IF dLastFile = FILETIME('MyFile') THEN
LET bNewFile = 'Y';
ELSE
LOAD .... FROM MyFile;
LET dLastFile = FILETIME('MyFile');
LET bNewFile = 'N';
END IF

Here you may link the alert to the variable bNewFile.

HTH
Peter