Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.