How to restrict missed Tables in Qlikview load script?

[Anonymous]

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.

[atoz1158]

Hi Krishna

You may like to use Error Handling to catch missing tables.

Have a look at

Error Handling in Qlikview

Regards

Adrian

[d_prashanthredd]

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.

[vinieme12]

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!