Discussion Board for collaboration related to QlikView App Development.
In a .qvw I created a QV table inside a condition statement.
Opening binary the above one in another .qvw file, I need to check if the QV table has been created.
Is there a way to check if a QV table exists before calling a drop table statement ?
Thanks in advance.
There is a system field called $Table which stores all actually loaded tables, so checking this field (with peek(), for exmple) for that table value should work for you.
Hope that helps.
If the table has a key column, you can do something like.
LET IsFieldAvailable = peek('keyColumn');IF IsFieldAvailable THEN DROP TABLE myTable;END IF;
The following should work:
if noOfRows('tablename') > 0 then drop table tablename;end if
Other way is to set the errormode variable appropriately so in case of error, it skips it and not terminate. Something like:
Set ErrorMode = 0; //Set it to skip error
DROP Table xyz;
Set ErrorMode = 1; //Set it back to standard
Here you are another one, maybe more practical, using system function TableName()
If (len(TableName('YourTable')) > 0) Then Drop Table YourTable; End If
great solution but small correction:
If (len(TableNumber('YourTable')) > 0) Then Drop Table YourTable; End If
The solution set errormode = 0 worked for me!
Other solutions fail because the table can't be checked on rows etc while it is simply not existing!