KNOWLEDGE BASE

Union non-Excel, Google Sheets or Text Based Data Sources


Published: 28 Mar 2016
Last Modified Date: 06 Sep 2017

Question

How 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?