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

Incremental Load with different scenarios!

Hi All,

Can someone please explain with example on how to do Incremental Load for following scenario. Hope it will be helpful for others as well.

1. PrimaryKey is there in the table but no Time field.

2. No PrimaryKey in the table but there is a Time field.

3. No PrimaryKey and Time field in the table

Thanks,

Attitude

3 Replies
MK_QSL
MVP
MVP

Can anyone have examples of these type of situations?
I also have file having time field but no primary key....

tresesco
MVP
MVP

AFAIK, to implement incremental load Primary Key and Timestamp are necessary. In absense of any of them, incremental load can't be implemented in complete(Insert, Update, Delete). However, if it's an 'Append Only' case, can be implemented using a simpler logic.

Gysbert_Wassenaar

See this blog post: Qlikview Notes: Incremental Load using Qlikview Components


talk is cheap, supply exceeds demand