Performing LEFT OUTER minus INNER JOIN in Tableau

0 votes
How to perform left outer join - inner join of orders. I want orders that are are not returned from the whole set of orders from the superstore. I used global superstore 2016 data set. Can anyone help me.
Mar 12, 2019 in Tableau by Sindhu

1 answer to this question.

0 votes

Hi Sindhu,

To get the list of orders that are not returned from the data set:

1. First perform inner Join on Orders + Returns to get the orders that are returned. (data set 1)

2. Perform Left Outer Join to get the details of all orders placed included returned. (data set 2)

3. Then form a calculated group with order id from table 2 whose is null and those of not null.

4. Then add the created field in the color shelf to observe difference or in the row pill. (The first order is from table 1 and 2nd order is from table 2.)

5. Now you can exclude the orders with common group ( i.e orders returned).

6. Now add other measures and dimensions to add visualizations.

Hope this helps you.

answered Mar 12, 2019 by Cherukuri
• 33,010 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 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
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
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
0 votes
1 answer

Difference between Inner Join & Outer Join

The difference is as follows: INNER JOIN: Returns all those ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
0 votes
1 answer

Can you please explain the difference between inner join and outer join in database?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
0 votes
1 answer

Can you explain what is the difference between UNION and Join?

Hi Sahana,  I got your doubt, Checkout these ...READ MORE

answered May 30, 2019 in Database by sampriti
• 1,120 points
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,950 points
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

Hey, it is a simple and easy ...READ MORE

answered Feb 28, 2019 in Tableau by Cherukuri
• 33,010 points
0 votes
1 answer

How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,010 points