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
901 views

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
• 32,490 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 16, 2018 in Tableau by Mathew1810
346 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 29, 2019 in Tableau by anonymous
6,182 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
4,850 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 29, 2018 in Tableau by QueenBee
• 1,820 points
2,010 views
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,210 points
270 views
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,100 points
221 views
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,100 points
315 views
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

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

answered 1 day ago in Power BI by Gitika
• 37,370 points
8 views
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

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

answered Feb 27, 2019 in Tableau by Cherukuri
• 32,490 points
545 views
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
• 32,490 points
3,991 views