Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
robin_heijt
Creator
Creator

Incremental Load Help

Hi,

 

I have been reading up on using an incremental load for my Qlik Sense app. But I am still unclear on how it exactly works in my scenario.

If someone could explain, it would be great.

I have about 20 different excel files loaded into Qlik Sense.

about 12 of those are only seldom updated (Yearly or even longer)

8 of those are updated on a weekly basis by overwriting the old file with a new file. (Contain mostly the same data but with added, deleted or adapted information)

My current load time is a bit longer than 1 hour.

From my understanding I should be able to make this shorter by using an incremental load, but how would that work for me since I overwrite my 8 excel files with new files every time?

 

Thanks.

1 Reply
Channa
Specialist III
Specialist III

ok try to have Primary key for incremental load

 

i am attaching some samples try 

Channa