Hello Techies, we are back with another blog on the Tableau series. In this blog, we will explore different types of Join in Tableau, which is helpful in selecting data efficiently. Before we start I will recommend you go through our introductory blog “Tableau: Products and Services” to get an overview of Tableau, moving forward to our today topic of Types of joins in Tableau. There are four types of Join available in Tableau Inner Join, Left Join, Right Join, and Full Outer Join.
We will try to simplify this by taking an example of the Order table (Left Table) where we have the order details and the Customer table (Right Table) where we have the customer details:
Inner Join: When we combine two tables with Inner Join, it includes only the values that match in both tables and drops the values that are not matched on both tables. As we can see below that only the record of Customer IDs 2, 3, and 5 were included as these records were also present in the Customer table, and the remaining records were excluded from the table.
Left Join: A Left Join always returns all the values from the Left table and matching values from the Right table while combining two tables. As we can see all the records from the Left table are available with the matching records from the Right table. As a result, we have null values from the Right table (Customer table) for the Customer ID 1, 4, 6.
Right Join: A Right Join always returns all the values from the Right table and all the matching values from the Left table while combining two tables. In the below image, we can see that all the records from the Right table are available with the matching records from the Left table. As a result, we have a null value for the Customer ID 8, 9, and 19 in the Left table (Order Table).
Full Outer Join: A full Outer Join returns all the values from both tables even if they do not have a match in the other table. As seen in the below image all the records from both tables are available and nonmatching records are present with the null value.
I hope that this blog helps you to have an understanding of the different Joins available in Tableau and how these Joins work and when to use a union for your data. In the upcoming blog, we will create an end-to-end project and we will explain every detail about that, so stay tuned.
Amlgo Labs is an advanced data analytics and decision sciences company based out in Gurgaon and Bangalore, India. We help our clients in different areas of data solutions including the design/development of end-to-end solutions (Cloud, Big Data, UI/UX, Data Engineering, Advanced Analytics, and Data Sciences) with a focus on improving businesses and providing insights to make intelligent data-driven decisions across verticals. We have another vertical of business that we call – Financial Regulatory Reporting for (
MAS,
APRA,
HKMA,
EBA,
FED,
RBI, etc) all major regulators in the world and our team is specialized in commonly used regulatory tools across the globe (
AxiomSL Controller View,
OneSumX Development,
Moody’s Risk,
IBM Open Pages, etc). We build innovative concepts and then solutions to give an extra edge to the business outcomes and help to visualize and execute effective decision strategies.
We are among the top 10 Data Analytics Start-ups in India, in 2019 and 2020.
Please feel free to comment or share your views and thoughts. You can always reach out to us by sending an email to
[email protected].
