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 in Tableau by Anitha
23 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 by Cherukuri
• 31,840 points

Related Questions In Tableau

0 votes
0 answers

total percentage from two tables count

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

Sep 10 in Tableau by anonymous
• 120 points
33 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 ...READ MORE

answered May 16, 2018 in Tableau by Mathew1810
122 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 28, 2018 in Tableau by Atul
• 10,240 points
50 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,550 points
68 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
2,199 views
+1 vote
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
98 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 in Tableau by Cherukuri
• 31,840 points
35 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 in Tableau by Cherukuri
• 31,840 points

edited Mar 4 by Cherukuri 40 views