Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chloe
Contributor III
Contributor III

Termination of load script if one of the tables is empty

Hi,

Is there a way to terminate the loading script if one of the tables in the script is empty? 

I don't want to exit script with the data that has been loaded so far in the script, I want the app to be with the old data before the run.

Any ideas? 

 

Thanks

Labels (1)
1 Reply
marcus_sommer

Just query the filesize() or the noofrows() and add an invalide statement to break the script execution, maybe like:

if filesize('fullpath') = 0 or noofrows('MyTable') = 0 then
   ... an error ...
end if