topic Re: Incremental loading problem in QlikView

Incremental loading problem

Tue, 09 Apr 2013 09:53:14 GMT

Hello everybody,

I've a little problem with iocremental load, i load a data base's table like this:

fim_PIANO_DI_PRODUZIONE:

SQL SELECT *
FROM fim.dbo."PIANO_DI_PRODUZIONE"
order by ID_COMMESSA,DATA_ULT_RIC;

STORE fim_PIANO_DI_PRODUZIONE;

It's work very good, but this is a big table so i wan't to do an incremental loading so i do:

Let ThisExecTime = ReloadTime();

PIANO_DI_PRODUZIONE:
SQL SELECT *
FROM fim.dbo."PIANO_DI_PRODUZIONE"
WHERE DATA_ULT_RIC >= '$(ThisExecTime)';

But i have a problem to match the two dates:

DATA_ULT_RIC is a numeris date like 38504,405804804

and ReloadTime like '09/04/2013 05:45:12'

Have you got any ideas or solutions?

Thanks a lot

Quentin

Re: Incremental loading problem

Gysbert_Wassenaar — Wed, 10 Apr 2013 14:19:43 GMT

Just to make sure ThisExecTime gets a numeric value:

Let ThisExecTime = num(ReloadTime());

And then remove the quotes that surrounded $(ThisExecTime):

WHERE DATA_ULT_RIC >= $(ThisExecTime);

Re: Incremental loading problem

Fri, 12 Apr 2013 07:44:08 GMT

Hello Gysbert,

I don't know why but the problem is that the clause where don't work in the script.

I have testing an other solution that i find:

Let vLastExecTime = TIMESTAMP(ReloadTime(), 'YYYY-MM-DD hh:mm:ss.fff');

Let Query = 'SELECT * FROM fim.dbo."ORDINE_TAB" WHERE data_creazione > ' & CHR(39) & ' $(vLastExecTime) ' & CHR(39) & '';

FIM_ORDINE_TAB:

LOAD *;

SQL $(Query);

And it's work!

Thank you for your help.

Quentin