0

How do I union 2 different data sources? not join- I want to union data !

1 tablename - from base1

2 tablename - from base2

base1 and base2 from same server (postgrsql)

ERROR: cross-database references are not implemented: "base2.public.requete_ca" LINE 1: select * from base2.public.requete_ca

Chifee B'abdesslem
  • 3
  • 2
  • 1
    Are the two tables in different databases or just different schemas? It looks like they might be in different databases, which means you'll need to use dblink or the postgres_fdw (preferred). – Jeremy May 22 '19 at 18:15

1 Answers1

0

You can't do this natively in Tableau Desktop using the visual drag-and-drop data source screen. You can do this in Tableau Prep if you have a license.

The only way to do this in Tableau Desktop is to use Custom Sql. You can use an approach like this.

tagyoureit
  • 1,276
  • 1
  • 10
  • 17