How to Union Tables in Tableau Prep

🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8

When you union tables in Tableau, you append two tables of data vertically. That means if you have two tables that are 1,000 rows each, the result of the union will be a single table that is 2,000 rows. Shared columns will align automatically, and unique columns will not.

Unions provide the ability to relate multiple tables that contain different data types or structures without worrying about granularity. Many times, fact tables that primarily consist of measures cannot be joined together because the join would lead to undesired row duplication.

Unions are great for building complex data models. If you want to learn how to set them up and some of the nuances to consider when making them in Tableau Prep, check out this video!

Connect with us:
•Upcoming Tableau Classes: https://onenumber.biz/onenumber-table...
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  

Resources:
•Example Data: https://data.world/ericparker/mount-r...
•How to Structure Data for Tableau: https://onenumber.biz/blog-1/2022/5/2...
•Joins in Tableau Prep: https://onenumber.biz/blog-1/2024/6/1...
•Joins, Unions and Blends: https://onenumber.biz/blog-1/2018/1/1...
•Union Tables in Tableau Desktop: https://onenumber.biz/blog-1/2022/4/1...

Chapters:
0:00 What are unions?
2:10 Data Background
3:10 Configuring Union
12:10 Wildcard Unions