Skip to main content

Tableau: Joins

Hello Techies, we are back with another blog on 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 to 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 Order table (Left Table) where we have the order details and 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 matches in both tables and drops the values that are not matched on both the tables. As we can see below that only the record of Customer ID 2, 3, 5 were included as these records were also present in the Customer table and remaining records were excluded from the table.

Tableau Inner Join

Left Join: A Left Join always returns all the value 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.

Tableau Left Join

Right Join: A Right Join always returns all the value from the Right table and all the matching value 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 null value for the Customer ID 8, 9, 19 in the Left table (Order Table).

Tableau Right Join

Full Outer Join: A full Outer Join returns all the values from both the tables even if they do not have a match in the other table. As seen in the below image all the records from both the tables are available and non matching records are present with the null value.

Tableau Full Outer Join

I hope that this blog helps you to have an understanding about different Joins available in Tableau and how these Joins work and when to use 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.

About Amlgo Labs : 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 includes 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 top 10 Data Analytics Start-ups in India, 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 at info@amlgolabs.com or filling a contact form at the end of the page.
Labels:

Comments

Post a Comment

More Popular Posts

JavaScript: The Important Basics

In this weird world of technology people often get confused how does a website work? What all things should I be aware of? So we are here to help you. Most of the content on web is developed with the help of JavaScript. JavaScript is really becoming popular these days with the coming of ECMAScript2015 and ECMAScript 2016, for this reason, some beginners learning React and Angular and are also trying to tackle more modern JavaScript syntax at the same time. If you're new to both, it can be confusing as to "what is JavaScript and what are its important features". This document should serve as a primer to help you get up-to-speed on JavaScript syntax that we feel matters the most for learning React as well as Angular.
1 comment
Read more

Amlgo Blog - Experience The Experiments

Amlgo Labs Blog  is a step towards our vision to share knowledge and experiences, Amlgoites accept every challenge very enthusiastically. We do experiments, we fail but we learn and build complex solutions to help our clients solve their problems in Data, Analytics, Prediction, Forecasting, Reporting, Designing and Development area. During this process we enjoy immense learning everyday and we have decided to share our thoughts, learnings, experiments and experiences so that we don't work in silos and contribute the best of our knowledge towards community and learn more by views and reviews. This website is maintained and brough to you by  Amlgo Labs Professionals .   Our Strong Basics -  1)   KISS (Keep It Simple and Straightforward) :  We believe most of the problems can be solved by keeping things simple and straight. This is the learning we had in past, sometimes we try to solve technical problems using high end algorithms and complex codes but this results into complications.
Post a Comment
Read more

Power BI Blog - What is Power BI and Why we use Power BI.

This Power BI blog is an introduction to the Power BI. In this Power BI tutorial, you will learn Power BI basics - what is Power BI, Power BI Desktop and Power BI Service. Power BI tool is a combination of Business Intelligence and Visualization. Before we dig deep let’s understand what is Business Intelligence. Business Intelligence is a broad spectrum which consists of using different business strategies and techniques to gather data, refine it and process it for the purpose of data analysis which gives us some meaningful information which helps in data driven decision making. When we present this information in the form of some charts, graphs it takes the form of Visualization.
4 comments
Read more

Polybase Blog - Introduction

Overview: This Polybase blog series is all about the use of Polybase Technology in today’s era to be able to take advantage of the Data(Relational and Non-Relational) by using T-SQL only. Data whether Big or not is the lifeline to many different sectors to cope up with Production, Maintenance, Predictions, Taking Precautionary Measures, Customer Satisfaction, Customer Retention, Sales, Revenue Generation and many more.
1 comment
Read more

Polybase Installation for Scale-Out process

This part is the continuation of the previous blog about the introduction of  Polybase Scale-Out Group . As we have discussed in our earlier blog PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, PolyBase can be used to access external data in SQL Server, Oracle, Teradata, and MongoDB.
2 comments
Read more

Stages of New Regulatory Reporting Implementation

In the last blog, we discussed what is  Financial Regulatory Reporting  and its importance in the banking industry. Regulatory Reporting comprises the submission of business numbers as required by regulators to evaluate and track the financial and operational status of financial institutions and their compliance with required regulatory provisions.
3 comments
Read more