
Hello,
I have a SQL table and Excel file that I want to use for a dashboard. There are columns from both the sources that I would like to use as union to report.
Is this possible to create a query to blend data from excel file and sql together.
Please advise.
Thank you!
5 answers
Yes You can...Using Cross data base Join
Integrate your data with cross-database joins in Tableau 10 | Tableau Software
But For Union ..Your data should be from Same data source
But You can Use Tableau PREP to do UNION