Prepare Your Data for Tableau: A Practical Guide to the Tableau Data Prep Tool

© Tim Costello, Lori Blackshear 2020

T. Costello, L. BlackshearPrepare Your Data for Tableauhttps://doi.org/10.1007/978-1-4842-5497-4_5

5. Joins

Tim Costello¹  and Lori Blackshear²

(1)

Euless, TX, USA

(2)

Fort Worth, TX, USA

 

I’ve been a database guy for going on 20 years now. For at least the last 15 years I’ve been explaining joins. It’s a tricky topic. When writing queries in SQL, joins can get out of hand quickly. One of the things that impresses me the most about the Tableau products are how effective they are in giving the end user the ability to do complex things while hiding the complexity from that user. The visual join designer is the best example of this genius. In this chapter we will dive deep into LEFT, RIGHT, INNER, and OUTER joins. We ...