Is it possible to have a global where on multiple source loading

[#1]

I want to create a table that concatenates data from many data sources based on a date , the question is : Do i have to put the where condition on each data source Load , or can i put one condition at the end of the all the loads that can be applied to all of them ?

[ashfaq_haseeb · Accepted solution]

Hi,

You have to write where condition at each Data source load, I would suggest you to define the value in a variable and use where conditions with variable.

Hope it helps

Regards

ASHFAQ

[its_anandrjs]

When concatenate the field name should be same specially for Date field and yes how data looks according to that you have to use Where condition if you have sample data so provide that.

[maxgro]

see ashfaq answer

or (not efficient but if you have few data)

- concatenate all your tables without where in table1

- do a resident load of table1 with one where condition (result is table2)

- drop table1