Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi
Try like this
If NoOfRows('TableName') > 0 then
STORE T into T.qvd(qvd);
ENDIF;