Question: what is a union in tableau?
Answer: A union is where you would add additional rows by effectively putting two data tables on top of one another. Tableau's help guide has a nice way of visualising this. The best way to find out how Tableau was doing this by default was to test it using our good friend and ally, Excel.