Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I loaded 3 tables from Database like
Table_1 :
concatenate
Table_2 :
Concatenate
Table_3 :
But the problem is sometimes Table_1 or Table_2 or Table_3 dropped in Database by someone as per requirement. But I need to load reaming 2 Tables or one Table or Zero . How can we overcome this kind of problems? How to restrict missed Tables in Qlikview load script?
Thanks,
Krishna.
Hi Krishna
You may like to use Error Handling to catch missing tables.
Have a look at
Regards
Adrian
Why don't you create a view or SP for that by checking if table exists. Its easy to concatenate @ DB end and call it in Qlik.
Thanks,
Prashanth Reddy D.
Buddy work for a permanent solution, ask the database guys to create a separate table or view only for you to use ; so that no one else drops it!