Performing LEFT OUTER minus INNER JOIN in Tableau

0 votes
I have a need that requires me to LEFT OUTER JOIN minus INNER JOIN two data sources in Tableau.

What is the best way to do this in Tableau at the data source? Tableau only supports the following joins: inner, left, right, and full outer.
Mar 29, 2022 in Tableau by Vaani
• 7,070 points
911 views

1 answer to this question.

0 votes

If you're using Tableau Desktop, you may create a datasource filter that uses the second data source's join key.

1. From source1 to source2, create a left join.
2. Create a new datasource filter for source2.join key by going to the "Condition" tab, selecting "By formula," and using "ISNULL([source2.join key])" as the formula.

Elevate your data visualization skills with our Tableau Course and unleash the power of insightful analytics.

answered Apr 5, 2022 by Neha
• 9,020 points

Related Questions In Tableau

0 votes
1 answer

Performing LEFT OUTER minus INNER JOIN in Tableau

Hi Sindhu, To get the list of orders ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
3,299 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,380 views
+1 vote
2 answers

How to join tables based on “Calculated Fields” in Tableau?

You absolutely can join to a calculated ...READ MORE

answered May 30, 2019 in Tableau by anonymous
24,466 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,832 views
0 votes
0 answers

Does joins in Tableau effect performance?

I have tables A, B, C, and ...READ MORE

Apr 14, 2022 in Tableau by Neha
• 9,020 points
553 views
0 votes
1 answer

Join multiple strings in R

Joining strings in R is quite an ...READ MORE

answered Jul 19, 2018 in Data Analytics by DataKing99
• 8,250 points
1,567 views
0 votes
1 answer

What is a Join in terms of database?

JOINS are used to combine rows from ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
• 8,250 points
995 views
0 votes
1 answer

.join() method is used for what purpose in Python?

join() method is used to concatenate or ...READ MORE

answered May 14, 2019 in Python by Taj
• 1,080 points
1,083 views
0 votes
1 answer

How to upload data to Tableau Server in Python

Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4, 2022 in Tableau by Neha
• 9,020 points
2,193 views
0 votes
1 answer

Is there a Loop function in Tableau Prep? (Problem written below)

Hey, Prep lacks a built-in looping function, ...READ MORE

answered Mar 28, 2022 in Tableau by Neha
• 9,020 points
1,215 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