topic Re: Store table command to work when table doesn't exist in QlikView

Store table command to work when table doesn't exist

Tue, 23 Jun 2015 10:12:27 GMT

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

Re: Store table command to work when table doesn't exist

avinashelite — Tue, 23 Jun 2015 10:19:53 GMT

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

Re: Store table command to work when table doesn't exist

MayilVahanan — Tue, 23 Jun 2015 10:22:46 GMT

Try like this

If NoOfRows('TableName') > 0 then

STORE T into T.qvd(qvd);

ENDIF;