topic Re: IF table do not exist then Exit Script in QlikView

IF table do not exist then Exit Script

jeckstein — Thu, 26 Jul 2018 15:54:54 GMT

I currently have the following code. Which says if a table does not exist then exit script.

if isnull(TableNumber('Temptable'))

then

Exit Script

End IF

I need to change this to look at two tables Temptable and Temptable1.

Basically I want to exit the script if Temptable and Temptable1 do not exist.

This maybe simple but I am stuck.

Thanks in advance!!!!

Re: IF table do not exist then Exit Script

YoussefBelloum — Thu, 26 Jul 2018 15:57:18 GMT

Hi,

never tried such thing, but if above script is already working, you can try this:

if isnull(TableNumber('Temptable')) and isnull(TableNumber('Temptable1'))

then

Exit Script

End IF

Re: IF table do not exist then Exit Script

Wlad_Masi — Thu, 26 Jul 2018 16:16:35 GMT

Hi James,

You can use the following script:
In this example table Temptable7 and Temptable8 are being loaded but Temptable2 not.
If you change the name of table Temptable7 and Temptable8 to Temptable and Temptable1, the entire script will be executed.

Temptable7:

load * inline[

test,name

test,n1

test2,n2

];

Temptable8:

load * inline[

c,b

1,2

3,4

];

if isnull(TableNumber('Temptable')) and (isnull(TableNumber('Temptable1'))) then; Exit Script; end if;

Temptable2:

load * inline[

t,n

t1,name1

t2,name2

];

Re: IF table do not exist then Exit Script

Anonymous — Thu, 26 Jul 2018 16:30:21 GMT

Hello James,

If isnull(TableNumber('Temptable')) then

if isnull(TableNumber('Temptable1')) then

Exit Script

End IF

hope it will works for you.