Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

Hi Gybert Wassennaar,

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