Hi All,
I have the requirement in which i have to union all data for two different data source(Oracle and MS SQL- Different physical server). Both the table in DB is similar. So anybody can help me on this. Below is the example which will help you to understand my requirement properly.
Example:
1) DB 1- Employee data for Male
EmpIDEmp_NameSalaryGender1XXX1000Male2YYY2000Male3ZZZ1000Male
2) DB 2- Employee data for Female
EmpIDEmp_NameSalaryGender4AAA1000Female5BBB2000Female6CCC1000Female
I have to union the 2 table to get the data for Male and Female in single view
EmpIDEmp_NameSalaryGender1XXX1000Male2YYY2000Male3ZZZ1000Male4AAA1000Female5BBB2000Female6CCC1000Female
Regards,
Sparsh
Hi Sparsh,
I would definitely recommend Maestro for this as it makes it really easy!
However, you can do a work-around in Tableau. It gets to be a bit tedious if you have a lot of fields, but if you absolutely need to get it done, it's possible: Cross Database Union & the other MAX/MIN functions in Tableau | VizPainter
Best Regards,
Joshua
