Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Incremental Load using SQL and timestamp filed in it

hi all,

having some issues with SQL writing to set up incremental load using SQL and a timestamp field in it.

 

Best,

Alec

1 Reply
JordyWegman
Partner
Partner

Hi Alec,

You can try:

SQL SELECT (NoKey) *
FROM $(vSourceTable) // This is your source, here in a variable
where $(vIncField) I EQ '$(vIncValue)' // In this one $(vIncField) is the timestamp and $(vIncValue) is the date.
;

Best thing is to create a floored date in your SQL, like 43797, because this makes comparing easier.

Jordy

Climber 

Work smarter, not harder