topic Re: ONLY FOR EXPERTS in QlikView

ONLY FOR EXPERTS

sujeetsingh — Wed, 23 Oct 2013 09:09:03 GMT

Hello,

I am struggling with an issue as :

Let

I am reloading the data as no of tables present in a database ;

Now tin further script i am joining one with another .

Now a situation might come as one of the table is not present but on all i have written it with join script how to avoid it.

Let me explain it with the demo .

It may be that five tables may be present in a database max .

Now i have to script as IF TABLE present then reload all as

Table1:

select * from Table1;

Table2:

Select * from Table2.;

....

.......

........

Now in next scripting i am joining all

Join(Table1)

Load * resident Table2;

Drop Table Table2l;

Now is table 2 is not present at database then table2 is not present in my script,But i have called it resident in my join statement.

Now i need to put some condition such that it should check if the table is present in my script and loaded ib qlikview.

HOw to do ??

All your ideas invited.

Re: ONLY FOR EXPERTS

preminqlik — Wed, 23 Oct 2013 09:15:37 GMT

hey hi do like this

Table1:

noconcatenate

select * from Table1;

Table2:

noconcatenate

Select * from Table2.;

Join(Table1)

Load * resident Table2;

Drop Table Table2;

regards

Premhas

Re: ONLY FOR EXPERTS

israrkhan — Wed, 23 Oct 2013 09:32:43 GMT

Your tables get concatenated automatically,

use NoConcate keyword, then load, and join, at the end drop table..

Re: ONLY FOR EXPERTS

sujeetsingh — Wed, 23 Oct 2013 10:03:22 GMT

It is not as easy as you guys are thinking first of all just i want that before joining we should check whether the table is there or not

Re: ONLY FOR EXPERTS

Gysbert_Wassenaar — Wed, 23 Oct 2013 10:12:15 GMT

Set the error mode to 0 so the script keeps running:

set ErrorMode=0;

It doesn't then matter if table2 exists or not. If you need to check you can do a test: If NoOfRows('Table2') > 0 then...

Re: ONLY FOR EXPERTS

Wed, 23 Oct 2013 10:13:46 GMT

why don't you handle it at sql level itself?

http://stackoverflow.com/questions/8829102/mysql-check-if-table-exists-without-using-select-from

go ahead only if the table exists.

Re: ONLY FOR EXPERTS

sujeetsingh — Wed, 23 Oct 2013 10:59:25 GMT

it is helpful but still i am working on other script steps.

thanks.

Re: ONLY FOR EXPERTS

marcus_malinow — Wed, 23 Oct 2013 11:06:56 GMT

How about a check such as:

IF NoOfRows('Table2') > 0 THEN

Marcus