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 in Tableau by Sindhu
25 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 by Cherukuri
• 17,630 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
70 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 in Tableau by anonymous
787 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,810 points
409 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
756 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,100 points
55 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 in Database by Sampriti
• 860 points
31 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 in Database by Sampriti
• 860 points
35 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
1,318 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 in Tableau by Cherukuri
• 17,630 points
42 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 in Tableau by Cherukuri
• 17,630 points
142 views