Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

How to do incremental load with out primary key?

Hi All

How to do incremental load with out primary key Field...Any Idea?

Please Help Me

My script:

let vQvdcreateTime=qvdcreatetime('path of qvd');

Load Empid,App_Request,Date_Request,End_Request from employee where  Date_Request >=vQvdcreateTime;//loading new data

concatenate

Load Empid,App_Request,Date_Request,End_Request from employee from employe.qvd(qvd) where not exists(?????);//old data

which field i need to use in where exists ??// Above table Empid not a primary key



Thanks

Gireesh

1 Reply
m_woolf
Master II
Master II

If you have a Date or Timestamp field, you can use that for your incremental load.

When you do a load, store the max(Date) or max(timestamp) in a variable. Then on the next load, load all since variable value.