Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mahesha955
Contributor
Contributor

Incremental Load without Primary Key and Date Field

Hello,

I have one small doubt. Can we do an incremental load without primary key and Date field?

2 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

HI Mahesh,

Yes, you could do for example the ReloadTime() to get the rows that were added from ReloadTime() till now.

Felipe.

balabhaskarqlik

You didn't mentioned, what type of incremental load you required.

Insert Only? Insert and Update? Insert, Update and Delete?

The simplest is add-only incremental load. This requires some way of identifying new records - it does not have to be a date-added or date-modified field. If you have a increasing key value, you can identify new records using the key as well.This may be a primary key in the database table, but any continually increasing field value will work.

If you cannot identify newly added records, then add-only incremental load is not possible.

For insert only Incremental Load, you need to have at least one of below

    1) Last updated date or any date field

    2) Sequential ID

Using above you can identify new records while extracting from the database.

By this, you can create an ID field:

autonumberhash128 (EmpCode, EmpName, Region) as KeyID