Discussion Board for collaboration related to QlikView App Development.
I am struggling with an issue as :
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
select * from Table1;
Select * from Table2.;
Now in next scripting i am joining all
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.
Set the error mode to 0 so the script keeps running:
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...
why don't you handle it at sql level itself?
go ahead only if the table exists.