Hello! Wondering how to do a union of two tables that are from different databases (one prod and one archive) but the same SQL server. All columns are the same in each table. Is it possible to do this in Tableau 10.1, or do I have to do it from the SQL server end? Thanks!
Custom SQL in tableau will do it or create a view on your SQL Server...which would actually be preferable as easier to maintain.