Hurry! 20% Off Ends SoonRegister Now

Introduction to Joins In Tableau

Join is a query that combines the data from 2 or more tables, sheets, files in a single datasource based on the join condition

Desired to gain proficiency on data visualization tool? Explore the blog post on Tableau Training to become a pro in Tableau.

Rules to perform Join:

To perform Join we are having two rules
1) Both the tables should have a common column
2) Based on the common data type in the both tablesJoin Types:
Depending on the join condition. Joins are divided into two types 
1) Equi Joins
2) Non-Equi Joins
Equi Joins: In the Join condition if you use the equality operator (“=”) then such a kind of Join is called as “ Equi Join”
Non-Equi Joins: In the Join condition apart from the equality if we use any operator like <,>,<>,<=,>= etc.
Suck kind of join is known as “Non-equi Join”
Equi Join Types:
Equi Join is divided into 3 types
1. Inner Join
2. Outer Join
3. Self Join
Again outer join is divided into 3 different types
1. Left Outer
2. Right Outer
3. Full Outer
Inner Join: 
Inner Join combines the data from two tables and it display only the matching records (or) common records.

Join Condition: Table1.ID=Table2.ID

 MindMajix YouTube Channel

Table 1:

NameID
Ramesh1
Ravi2
Praveen3
Kiran4

Table 2:

IDDesigntion
1Professor
2Professor
3Professor
4Principal

Output:

NameDesignation
RameshProfessor
RaviProfessor
PraveenProfessor


Outer Join
Left Outer Join: 
Is is display the complete data from the left table and matching records from the the Right Table.

Table1.ID=Table2.ID(+)

Following Above Table 1 & Table 2

Output:

NameDesignation
RaviProfessor
RameshProfessor
PraveenProfessor
KiranNull

Right Outer Join: 
It is display complete data from right table and matching records from left table.

Table1.ID(+)=Table2.ID

Following Above Table 1 & Table 2

Output:

NameDesignation
RameshProfessor
RaviProfessor
PraveenProfess
NullPrincipal

Full Outer Join: 
It displays the complete data from both the tables

Full Outer Join

Following Above Table 1 & Table 2

Output:

NameDesignation
RameshProfessor
RaviProfessor
PraveenProfessor
KiranNull
NullPrincipla

Self Join: 
Performing a join to the same table itself is known as “Self Join”

Explore Tableau Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
Tableau TrainingDec 24 to Jan 08View Details
Tableau TrainingDec 28 to Jan 12View Details
Tableau TrainingDec 31 to Jan 15View Details
Tableau TrainingJan 04 to Jan 19View Details
Last updated: 28 Sep 2024
About Author

As a Senior Writer for Mindmajix, Saikumar has a great understanding of today’s data-driven environment, which includes key aspects such as Business Intelligence and data management. He manages the task of creating great content in the areas of Programming, Microsoft Power BI, Tableau, Oracle BI, Cognos, and Alteryx. Connect with him on LinkedIn and Twitter.

read less
  1. Share:
Tableau Articles