Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a database which can be updated at any point, however I don't want to place a constant load on the server by completely reloading the tables into Qlik Sense all the time, so I'm looking for a way to check if the database has been updated, and if so reload all the tables. However - if the database hasn't changed, the load script should just keep the data that was loaded previously. I've found a way to check for a change in the data, and to load everything if a change has taken place...
BUT
If no change has taken place, and my script exits - my model is empty. Obviously I've missed something - what should I try to ensure that my model isn't empty. The code I'm using goes something like this:
{Set initial standard variables}
LIB CONNECT TO [database]
[Temp_table]:
SQL {single value to indicate change};
Let vChange = FieldValue('sql_changed', 1);
IF vChange = 1 THEN
SQL UPDATE {reset data to indicate nothing has changed};
ELSE
Exit Script; <-- This is obviously wrong
ENDIF
{code continues for full load}
Any help here would be appreciated.