Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental loading

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

Labels (1)
0 Replies