Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
1. you can use incremental load
2. concatenate the old and new table so that you can use where condition with not exists.