Join Two Tables 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

Double-clicking a table on the relationship canvas opens the join canvas Double-click or drag another table to the join canvas. If your next table is from another data source entirely, in the left pane, under Connections, click the Add button (in web authoring) to. The table that contains all possible values in the linking field should be the leftmost table in the join, when the join type is Left Outer Join. (If neither table contains all possible values, this option will not work.) Option 3 Use a Full Outer join. A Full Outer Join will include all records from both tables even when there is no matching values in the linking fields. Please note, data for which there were no matching values in the linking fields will not be related.

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.

How do you join two tables in tableauJoin

Join Condition: Table1.ID=Table2.ID

Table 1:

NameID
Ramesh1
Ravi2
Praveen3
Kiran4

Table 2:

Tableau Join Published Data Sources

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(+)

Join Two Tables In Tableau

Following Above Table 1 & Table 2

Join Two Tables In Tableau

Output:

NameDesignation
RaviProfessor
RameshProfessor
PraveenProfessor
KiranNull

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

Can We Join Multiple Tables In Tableau

Table1.ID(+)=Table2.ID

Following Above Table 1 & Table 2

Tableau Join Multiple Tables

Output:

NameDesignation
RameshProfessor
RaviProfessor
PraveenProfess
NullPrincipal

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

Following Above Table 1 & Table 2

Tableau Union

Output:

NameDesignation
RameshProfessor
RaviProfessor
PraveenProfessor
KiranNull
NullPrincipla

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

Join Two Tables In Tableau
Explore Tableau Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!