How do you call a last run date stored in memory/qvd in a SQL script to SQL server

Anonymous — Sat, 30 Sep 2017 17:16:13 GMT

I'm trying to use a SQL query directly to our SQL server, but only load data since the last run date (incremental load).The root data in the SQL server has both a unique ID and a moddate, so I'm good there....just looking for where the moddate > lastrun date per unique ID.I have created a variable for last run date, stored the previously run data to a qvd file, and have tried a number of other techniques. The issue I keep running into is I ultimately need to call the last run date from my SQL query to the SQL server. The last run date is not stored there so I can't call it. Have spent hours trying to figure out how to make this work so any help would be greatly appreciated!

Re: How do you call a last run date stored in memory/qvd in a SQL script to SQL server

Anonymous — Thu, 12 Oct 2017 17:15:25 GMT

Figured out the way to get this to work. The SQL where clause should grab records modified since the last Qlik Server refresh. Ex. If you publish the Qlik App to refresh every hour, then you set the where clause to grab records updated in the past hour and update the qvd that loads the data.

topic How do you call a last run date stored in memory/qvd in a SQL script to SQL server in QlikView

How do you call a last run date stored in memory/qvd in a SQL script to SQL server

Re: How do you call a last run date stored in memory/qvd in a SQL script to SQL server