If I understood your requirements correctly, Union Your Data works for you.
1. Put your data file, test xlsx.xlsx and Sample - Superstore.xls in the same folder.
2. Connect either of them and setup the union, such as,
3. In data source filter, keeps only Excel sheets "Orders" (Sample - Superstore.xls) and "Sheet1"(test xlsx.xlsx).
The result looks like,
thank you for your prompt reply.
I have two data source which is connecting to database and stored in tableau server( I am connecting to those two) and Excel file stored in tableau server ,Which does not give me option to union my data.
For multiple data sources, there are two alternatives.
- A workaround for Union mentioned in Union with multiple datasources
- Tableau Prep
However, neither of them works for Tableau Server data source.
One option could be, union your database connection and Excel file directly, assumed that your database connection is supported by cross-database join or Tableau Prep datasource.