Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jw22
Contributor II
Contributor II

Load only new data new into Qlik

Hello Qlik Community,

is there a way to load only the new data/ rows since the last reload into Qlik and let the old data/rows remain the same from the last reload?

Thank you!

 

 

Labels (3)
3 Replies
Chanty4u
MVP
MVP

Yes, you can use Incremental Load technique in Qlik Sense to load only new data/rows since the last reload and let the old data/rows remain the same from the last reload.

 

Just search incremental load in qliksense you will get some idea 

krishna_2644
Specialist III
Specialist III

Both works:

1. Do Incremental loads

2. concatenate new table to the old table (to retain old records.) define what months or years (to and from) you need in where clause to make sure the table doesnt get too heavy.

Prem0212
Creator
Creator

1. you can use incremental load

2. concatenate the old and new table so that you can use where condition with not exists.