By: Oliver Linley
Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.
When Would You Use a Join Calculations?
Tableau is pretty good at joining tables together. As long as you have a common field in both tables you want to join, Tableau can do the rest.
But what if you don’t have a common field? Or, what if your common field is in a slightly different format in one of the two tables?
A join calculation can solve a lot of your problems!
What is a Join Calculation?
A join calculation is a special kind of calculated field that can help Tableau link rows between two tables that we want to join. By using a join calculation, we can show Tableau how to make both fields exactly the same by editing one so it’s the same as the other.
How to Use a Calculated Field
In this week’s tutorial, we’ll look at two examples to see how to join on a calculated field when your tables don’t exactly align. I’ve put together a Miro board to give some more information and you can access it here.