KNOWLEDGE BASE

Unable to union non-Excel, Google Sheets or text based data sources


Published: 28 Mar 2016
Last Modified Date: 03 Apr 2017

Question

Is it possible to union data sources that are not Excel, Google Sheets or text based data sources?

Environment

  • Tableau Desktop
  • 10.1 and previous versions

Answer

Currently, it is only possible to union Excel, Google Sheets and text data source

There are some possible workarounds for establishing a union for data sources that are not Excel, Google Sheets or text files:

1. Create an extract of the first table and append the second table to it. Please note that refreshing the connection will remove the appended table
2. Use custom SQL to perform a union between the desired tables
3. Mirror the data sources onto different Excel sheets
Did this article resolve the issue?