Load tables from database by conditional

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

Thanks,

Krishna.

[karthikoffi27se]

Hi Krishna,

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

Many Thanks

Karthik

[effinty2112]

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