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 in Tableau by Vaani
• 5,040 points
19 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.
answered Apr 5 by Neha
• 6,260 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,010 points
1,955 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 17, 2018 in Tableau by Mathew1810
759 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
17,097 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,230 points
7,937 views
0 votes
0 answers

Does joins in Tableau effect performance?

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

Apr 14 in Tableau by Neha
• 6,260 points
13 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,240 points
884 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,240 points
344 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
478 views
0 votes
1 answer

How to upload data to Tableau Server in Python

https://www.tableautim.com/playlist-video/tableau-tds-and-tdsx-files/csv-to-tdsx Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4 in Tableau by Neha
• 6,260 points
53 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 in Tableau by Neha
• 6,260 points
60 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP