Hi All,
Working on business scenario where the expectation is to Refresh QlikSense UI with updated/New records. Basically to update existing QlikSense Data Model with new/updated records for multiple table.
For Ex: Qlik Data Model QVF (Also has UI) has 3 tables loaded on day 1. on Day 2 new records are added and some of the existing records are udpated in Database. We have setup an incremental process to extract updated/new records from Database using timestamp.
Question: Since on Day 1 all 3 tables were loaded with 100 rows each and on day 2 additional rows (10 new and 10 existing rows were updated) how can to setup a process that instead of running all 110 rows from both days only UPSERT 20 rows to existing data model without running the complete data form QVD.
Currently if 100 rows take 5 mins on full load then on day it should be less than a min for adding/updating additional 20 rows in QlikSense Data Model.
request to please share a way to perform above activity.
