Blend two different fields from 2 tables into one field

0 votes
How to make two different fields from 2 tables after blending into one field. Both tables have same field names but have some different values in the fields.
Apr 3, 2019 in Tableau by Anitha
854 views

1 answer to this question.

0 votes

Hi,

Follow below steps:

1. Connect to both data sources separately.

2. Then select a dimension/measure from one source and then go to the 2nd source and click on like button next to fields to link them and use data blending.

3. Create a calculated field to join them by using IF and the linked field like this, 

IF ATTR([TABLE1].[link field])=ATTR([Table2].[link field]) THEN 2nd field
ELSE "0"
END

4. Now you can have a field from both the sources into the created field.

Hope this helps you.

answered Apr 3, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

+1 vote
0 answers

total percentage from two tables count

Hi, I am in need to calculate the ...READ MORE

Sep 10, 2019 in Tableau by anonymous
• 180 points
729 views
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 the ...READ MORE

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

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 29, 2018 in Tableau by Atul
• 10,240 points
1,022 views
0 votes
1 answer

Not able to publish workbook in Tableau Server after upgrading it from Tableau 9.1 to 9.2

Following is a little hack that will ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,560 points
1,183 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,952 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,622 views
+2 votes
1 answer
0 votes
1 answer

Show data from 2 different sheets in one sheet.

Hi Anitha, Follow the below steps: 1. Create both ...READ MORE

answered Apr 25, 2019 in Tableau by Cherukuri
• 33,030 points
702 views
0 votes
1 answer

Stacked side by side bars with two different dimensions splitting the columns.

Hi, to split the columns using 2 dimensions/measures/combination in ...READ MORE

answered Mar 4, 2019 in Tableau by Cherukuri
• 33,030 points

edited Mar 4, 2019 by Cherukuri 972 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