Hello,
I have a table in PostGreSQL database and another table in MySQL database. I was looking to create a UNION between both these tables in Tableau Desktop. Has anyone tried anything like this in past?
Thanks in advance for your help :)
Hi @Shivraj Bhaygude ,
Unfortunately (but maybe also understandably) you can't union tables from different datasources.
I use several techniques to make this work in certain projects: either a small Python script which combines the data and writes it back to a database (a daily automated procedure), or Tableau Prep for a custom flow (combining PostgreSQL and Google Sheets) manually.
Kind regards,
Johan de Groot
If this post resolves the question, would you be so kind to "Select as Best"?.
This will help other users find the same answer/resolution and help community keep track of answered questions.
