Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jobsonkjoseph
Creator III
Creator III

Task with QVD failing

Hi, Any inputs for the below test case; Scenario: When the backend run happen(in production) and due to some reason(run fails), there is no data in the database (tables) and the values are empty. Requirement: Will the existing QVD remain unchanged(with previous data) with already loaded (tables) data or it updates automatically with the above null value tables.
2 Replies
Vegar
MVP
MVP

As long the query against your database is working (your script is not failing) then your 

store Table into Table.qvd (qvd)

will run storing whatever data that is loaded into the Table, it will store a empty qvd with only the column names if you fetched zero rows from the database.

Vegar
MVP
MVP

To avoid overwriting with an empty and you could do a check for rows before storing.

UNLESS NoOfRows('Table')=0 STORE Table INTO Table.qvd (qvd);