Incremental loading

Tue, 09 Apr 2013 09:43:41 GMT

Hello everybody,

I've a little problem, I load a table from a data base 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

No problem it's work but it's a big table so i want to load only the lines where the creation date are higher than the last execution!

So I do :

Let ThisExecTime = ReloadTime();

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

But it doesn't work, no lines loading. I think it's a problem of data beetween ReloadTime and DATA_ULT_RIC.

DATA_ULT_RIC is in numeric like '38085,802407407' and the reloadtime '09/04/2013 05:45:12'.

How can I match this two date?

Thanks a lot for your Ideas/Answers!

Quentin

topic Incremental loading in QlikView

Incremental loading