How to join tables based on Calculated Fields in Tableau

+1 vote

In order to join one of my tables to other tables, I had to use Calculated Fields to make the field format same as others. However, when I want to join the tables, the new field name created by Calculated Fields does not appear. I know that I can export modified data, and import it again to solve the problem, but I'm interested to know if there is a simpler way to do so in Tableau?

Aug 23, 2018 in Tableau by AwesomeSauce
• 860 points
23,572 views

2 answers to this question.

0 votes
Best answer

You absolutely can join to a calculated field, but they make you take a few extra steps:

After you drag your source over, and the dialogue box pops up, under Data Source, you will see all of your field choices but none of your calculated fields. At the bottom of these choices is Edit Join Calculation; click on it.

A Join Calculation box pops up. Type in the name of your calculated field. Put the name in [ ]'s, or after typing a few letters, the name should pop in as an auto-fill option. Once done, click ok.

Then click on the second column and choose the corresponding field you want to use for the join. At that point, it should perform the join.

For an in-depth explanation check out Tableau Training Course details.

answered May 30, 2019 by anonymous

selected May 30, 2019 by Cherukuri
Thanks, it works quite well.
does this only work in later versions of Tableau? I'm using 10.4.1 and the data source doesn't recognise either the calculated fields nor a bespoke parameter to create the join calculation.

This feature was added to Tableau 10.2 version onwards.

You can see images like below.

Click on Add new join clause,

a

Enter [ to see created calculated fields or create a new join calculation.

You can read below doc for more information regarding join calculative fields.

https://onlinehelp.tableau.com/current/pro/desktop/en-us/joining_tables.htm#joinoncalcs

Hope it helps!

Hey! I hope you are doing good! If @Cherukuri's answer has helped you please do upvote the answer.

We are glad to know that you want to help us build the community. All you have to do to build the community is:

  • Sign Up 
  • Be an active member of the community
  • Ask questions that you are looking answers for
  • Answer the questions that you know the answer for
  • Get points and rewards for contributing.
0 votes

Calculated fields are not written back to your data source. But perhaps you could Blend, not join, on it. So currently you can not join in the data model using calculated field in Tableau. If your data is not too large, you can make the join in Tableau by using data blending. Alternatively, create a view or views with the calculated field in the source SQL database.

answered Aug 23, 2018 by Naruto
• 710 points

Related Questions In Tableau

0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in ...READ MORE

answered May 17, 2018 in Tableau by Mathew1810
1,165 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,371 views
0 votes
1 answer

How to print projects and workbook names based on site id in tableau server client?

Here's how I do it once I've ...READ MORE

answered Mar 9, 2022 in Tableau by Neha
• 9,060 points
1,416 views
+1 vote
1 answer

How to perform top N fields with nested sort in tableau

You can use the following steps: Sort 'State' ...READ MORE

answered Aug 4, 2018 in Tableau by ffdfd
• 5,550 points
3,862 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
14,710 views
0 votes
1 answer

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,030 points
4,658 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 8, 2018 in Tableau by Nitish
• 630 points
704 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 15, 2018 in Tableau by AwesomeSauce
• 860 points
1,368 views
0 votes
1 answer

Action filter (on set) is appearing in my worksheet.

Those are the action filters that we ...READ MORE

answered Aug 17, 2018 in Tableau by AwesomeSauce
• 860 points
2,148 views
0 votes
1 answer

Tableau Data Blend Performance + Level of Detail

If you are able to upgrade to ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 860 points
698 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP