topic Re: Only update data from a table in Qlik Sense in Connectivity & Data Prep

Only update data from a table in Qlik Sense

Anonymous — Mon, 23 May 2016 21:07:12 GMT

Hello community, in this case I encounter a problem in loading data.

I have many loaded tables with millions of data each, and all the tables there is one that I update daily, so to Load Data will "Editor data load" and I click on "Load Data" or either through script. When I run this begins to reload all data and tables that no longer have modifications (many) and obviously the table where is the actual upgrade, then I later around 7 minutes each time I put "Load Data" and peinso load many more tables in the future so I see a lot will worsen the duration of each update.

How can i fix this?

Thank you

Re: Only update data from a table in Qlik Sense

Gysbert_Wassenaar — Wed, 25 May 2016 09:44:08 GMT

I don't think you can fix this at the moment. Unless you want to create an application or script that directly calls the Qlik Engine API to execute a Partial Reload. The best next alternative is to create an app with the non-changing data model and reload that once. After that you won't need to reload that app anymore. Then in your real app you binary load the data model from that non-changing app and then load the table that has daily modifications. The binary load should be quite fast, but you'll still need to load that data every day.

Re: Only update data from a table in Qlik Sense

Anonymous — Mon, 30 May 2016 12:33:01 GMT

Gysbert, Thanks for your answer. How I can do to implement what you say? Upload an app to another app

Re: Only update data from a table in Qlik Sense

Gysbert_Wassenaar — Mon, 30 May 2016 16:32:19 GMT

See the online help for the binary load: Binary ‒ Qlik Sense

Re: Only update data from a table in Qlik Sense

Anonymous — Thu, 02 Jun 2016 11:33:53 GMT

Hello Gy! I could load the app binary in the script but takes the same time the charging process data if performed in the original app.

What I noticed is that what are all too late Syn $, are too because I have many tables with similar data that I use to concatenate all data. How I can do to reduce the time this process?

Re: Only update data from a table in Qlik Sense

Gysbert_Wassenaar — Thu, 02 Jun 2016 16:27:14 GMT

No idea. I'm unable to connect to your Qlik Sense app and read its script.

Re: Only update data from a table in Qlik Sense

Anonymous — Thu, 02 Jun 2016 18:13:16 GMT

I Know, to explain, per month charge two tables where there are fields that are shared, then I have loaded 8 months with a lot amount of data, I can not group every month in a single text table because it does not support it. Then I generated many syntax. An image when you step charge data ...

In the images reaches 04 minutes because I am adding to each table the Buffer (Incremental) function in the script to tables that have no more updates. This generates also a problem because if I want to add a table to a similar field but does not connect me

Re: Only update data from a table in Qlik Sense

Gysbert_Wassenaar — Fri, 03 Jun 2016 15:40:33 GMT

I still can't read the script of your app.

Perhaps this blog post helps: Concatenate vs Link Table