Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
bhavikumehta
New Contributor III

Update in Incremental load using Primary Key

I have a DB table with a Primary key, without a Date field.

Requirement is to use Incremental load - I am able to pull newly Inserted, Deleted records using Primary key, however, unable to pull Updated records using Primary key.

Please let me know solution for pulling Updated records in Incremental load using Primary Key. Thank you.

1 Reply
dilipranjith
Valued Contributor III

Re: Update in Incremental load using Primary Key

You will need to use a hash key got each row.
I.e.
Hash256(column 1, column 2,...)
This creates a unique signature for each row
Load data where hash keys doesn't exist.

But how much benefit it gives as far as load time is questionable as you will need to query the entire db anyway.

Hope it helps