Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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
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.
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