Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Re: Incremental Load with different scenarios!

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

MVP
MVP

Re: Incremental Load with different scenarios!

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.

MVP & Luminary
MVP & Luminary

Re: Incremental Load with different scenarios!

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


talk is cheap, supply exceeds demand