Combining data tables

Connecting Data in Tableau

Lis Sulmont

Head of Curriculum Expansion, DataCamp

Combining data

Unions

Union example

Joins

Joins example

Joins example

Inner Join

Returns matched rows only

Left Join

Returns matched rows and left table's rows

Right Join

Returns matched rows and right table's rows

Full Join

Returns matched rows and both tables' rows

Superstore dataset

• Orders 2016
• Orders 2017
• Orders 2018
• Orders 2019
• Orders 2020
• Returns
• Sales Reps

Let's practice!

Connecting Data in Tableau