https://community.qlik.com/t5/App-Development/UPSERT-new-Data-into-existing-QlikSense-Data-Model-and-UI/m-p/2027973#M84705 <P>Hi All,</P> <P>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.</P> <P>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.</P> <P>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.</P> <P>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.</P> <P>request to please share a way to perform above activity.</P> Thu, 19 Jan 2023 19:00:22 GMT shah_jigesh16 2023-01-19T19:00:22Z https://community.qlik.com/t5/App-Development/UPSERT-new-Data-into-existing-QlikSense-Data-Model-and-UI/m-p/2027973#M84705 <P>Hi All,</P> <P>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.</P> <P>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.</P> <P>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.</P> <P>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.</P> <P>request to please share a way to perform above activity.</P> Thu, 19 Jan 2023 19:00:22 GMT https://community.qlik.com/t5/App-Development/UPSERT-new-Data-into-existing-QlikSense-Data-Model-and-UI/m-p/2027973#M84705 shah_jigesh16 2023-01-19T19:00:22Z https://community.qlik.com/t5/App-Development/UPSERT-new-Data-into-existing-QlikSense-Data-Model-and-UI/m-p/2028556#M84746 <P>Hi!</P> <P>You can use "partial reload" function to to add / merge only those records you don't have in your already loaded data model. Please check more info :&nbsp;<A href="https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/PartialReload.htm" target="_blank">https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/PartialReload.htm</A>&nbsp;</P> <P>&nbsp;</P> Sun, 22 Jan 2023 10:13:45 GMT https://community.qlik.com/t5/App-Development/UPSERT-new-Data-into-existing-QlikSense-Data-Model-and-UI/m-p/2028556#M84746 zar 2023-01-22T10:13:45Z