Incremental Load without Primary Key and Date Field

mahesha955 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

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

Re: Incremental Load without Primary Key and Date Field

felipedl — Fri, 29 Jun 2018 16:20:41 GMT

HI Mahesh,

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

Felipe.

Re: Incremental Load without Primary Key and Date Field

BalaBhaskar_Qlik — Sat, 30 Jun 2018 17:38:25 GMT

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

topic Re: Incremental Load without Primary Key and Date Field in QlikView

Incremental Load without Primary Key and Date Field

Re: Incremental Load without Primary Key and Date Field

Re: Incremental Load without Primary Key and Date Field