topic Load tables from database by conditional in QlikView

Load tables from database by conditional

Anonymous — Sun, 30 Jul 2017 06:18:50 GMT

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. How can we overcome this kind of problems?

Thanks,

Krishna.

Re: Load tables from database by conditional

karthikoffi27se — Sun, 30 Jul 2017 08:15:47 GMT

Hi Krishna,

You can load the tables in QVD and then you can use QUALIFY statement to rename the field names.

Many Thanks

Karthik

Re: Load tables from database by conditional

effinty2112 — Sun, 30 Jul 2017 10:12:00 GMT

Hi Krishna,

You could consider adding a new field when loading from each table, call it Source. Set this equal to 'Table 1', 'Table 2', 'Table 3' or whatever values make sense in your data.

Then instead of dropping Table 3 have you user select only Source = {'Table 1', 'Table 2'}. If you really need to drop the records taken from Table 3 from the model then, assuming your resident table is called Data.

Noconcatenate

NewData:

Load

* resident Data

Where Source <> 'Table 3';

Drop table Data;

Rename table NewData to Data;

Good luck

Andrew