13 Replies Latest reply on Nov 30, 2017 11:28 AM by Shay Hayo

    Union of multiple data sources

      I would like to union (and not join) two data sources in Tableau that have similar columns (including primary key) and different rows, same as UNION operation in SQL.

      I couldn't find anything in the Tableau documentations and formus on unionizing data sources that are not from the same database.

      I tried creating a third "main" data source that has only a list of all the primary key values and then join the other two data sources to the main one, and just in case I also removed all the automatically identified relationships between the two different data sources. Still, Tableau doesn't recognize that the fields of the two data sources are actually the same fields.

      Any suggestions?

      Thanks!