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: 
Not applicable

Store table command to work when table doesn't exist

Hi

I have a table that only generates when there is data (comes from Excel spreadsheet), currently the load fails on the Store line because the table doesn't exist (no data in Excel), is there a command I can use to say if table doesn't exist, don't store it, otherwise do store it?

Thanks

2 Replies
avinashelite

try like this:

table1:

laod *

from tables...

if NoOfRows('table1') > 0 then

store table1 into table1.qvd(qvd);

endif

this will check whether the data is their are not

MayilVahanan

hi

Try like this

If NoOfRows('TableName') > 0 then

STORE T into T.qvd(qvd);

ENDIF;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.