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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Store

Hi

I pulling data from oracle table and storing to a QVD. I get error on Storing to QVD table if the number of rows retrieved from oracle is 0. How to handle this error exception

Thanks

1 Solution

Accepted Solutions
marcus_sommer

You could use something like this:

if noofrows('YourTableLoadFromOracle') >= 1 then

     store YourTableLoadFromOracle into YourTableLoadFromOracle.qvd (qvd);

end if

- Marcus

View solution in original post

1 Reply
marcus_sommer

You could use something like this:

if noofrows('YourTableLoadFromOracle') >= 1 then

     store YourTableLoadFromOracle into YourTableLoadFromOracle.qvd (qvd);

end if

- Marcus