Cross database joins have been available in Tableau for a while now – and I love the ability to join data at a row-level across various databases and files! And union functionality is available, but for now, only if you are dealing with tables in the same database (or files or Excel tabs). But what if you want to union tables that are in different databases? There is a way…
Jonathan Drummey has an excellent post covering how to use a cross database join to effectively union together almost any data sources you want. My goal is not to replicate his post here, but to provide a similar example and then springboard to a discussion of the “other” max() and min() functions in Tableau that you may never have used!
Cross Database Union & the other MAX/MIN functions By Joshua Milligan
Want to Get Latest Updates and Tips on Tableau Bites Blogs
Sign Up For Newsletter