Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in BI by (17.6k points)
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.

1 Answer

0 votes
by (47.2k points)
edited by

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.

Want to be an expert in Tableau? Check out the Tableau Training to get the right assistance.

Related questions

0 votes
1 answer
asked Jan 7, 2021 in SQL by Appu (6.1k points)
0 votes
1 answer
0 votes
2 answers

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...