Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lakhansajwan
Contributor III
Contributor III

Incremental Load without date feild

Can any one tell me how to perform incremental load when there is no date feild  but key feild is present?????????

Plz explain with example in case

1) Update

2) Insert

3) Delete..

8 Replies
tresesco
MVP
MVP

Unless until you have some timestamp to check for latest updated data, you can't implement incremental load with key field only. Possibly you can handle the Insert Only and Delete Only cases with Key field, but that might not be really incremental.

Not applicable

If u dont hv Date field..

Example:

Load

a,b,c

From Source..

Store Example into Example.qvd;

In second time load it will clear old qvd & generate new qvd..

without date it will refresh qvd..no incremental.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Is your key field an ascending value? Does your table have only inserts, not updates?

-Rob

Not applicable

Hello,

here are a simple example without a date field.

Not perfect but shows in principal how it could work.

Good luck!

Rainer

lakhansajwan
Contributor III
Contributor III
Author

i want to update as well insert and delete in one table

lakhansajwan
Contributor III
Contributor III
Author

can i do it with trigger ???????????

if yes plz expalin with example.

lakhansajwan
Contributor III
Contributor III
Author

suppose id are not seqential i.e

1 3 5 8 9 12 

and then you insert id 2 , how it will work??????????/

Not applicable

That does not matter as long as you have a unique identifier. ID. the id's should be ascending. The principle is similar to when you have a timestamp: identify your delta and load them.