Connect with us!
• Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
• Connect with Oliver Linley on LinkedIn: / oliverlinley
• Access the Miro Board here: https://miro.com/app/board/uXjVOjuDYY...
When Would You Use a Join Calculation?
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 Join on 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.
Chapters:
0:00 Intro
0:43 How does a join work?
3:20 When do you need a join calc?
4:20 How does a join calc work?
8:18 What if your fields don't match?