topic Check if a table is already loaded in QlikView

Check if a table is already loaded

Tue, 08 May 2012 06:34:00 GMT

Hi,

I would like to check if a table exist before dropping this table. I used this function

if noOfRows('mytable')>0 then

drop table mytable;

endif

However, later i found that if a table has been created but contains no data. noOfRows function also return a number which is less or equals to zero. The scenario is as below:

mytable:

load *

from mytable;

inner join

load * from

anothertable;

The above scenario creates mytable and makes it empty by a inner join.

This causes my table not being dropped. Could anyone tell me if there is another way of checking the existence of a table?

Check if a table is already loaded

Tue, 08 May 2012 06:54:18 GMT

Hi in case anybody facing the same problem. I've already found a solution. I check the output of noOfRows('table') under debug. If a table does not exist, it returns null, else it returns the number of rows in a table. So in order to check whether a table exists of not. We should use

if noOfRows('table') <>null then

...

endif

Re: Check if a table is already loaded

Fri, 03 Jul 2015 14:35:53 GMT

Thanks! Very thoughtful of you to give everyone your solution.

Re: Check if a table is already loaded

Arek92 — Fri, 17 May 2024 13:46:05 GMT

After 12 years still it does the trick. Thank you unknown OP