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: 
Not applicable

suppose in incremental load insert and update the records...how to identify the only insert and updated records...what is the condition

suppose in incremental load insert and update the records...how to identify the only insert and updated records...what is the condition

2 Replies
Gysbert_Wassenaar

Usually the new and updated records can be identified by a modification date (or maybe a record version number) field. If that's not available then you may be able to identify the new records by checking if the record identifier already exists. If it doesn't then it's a new record. Changed records can be identified by computing a hash of all the fields of the record and compare it to the hashes of all other records. But you really want to have a modification date (or record version number field as second choice). Insist on one if it doesn't exist yet.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gybert Wassennaar,

if suppose i want to only view updated records...how it is possible