Merge two datasets with horizontal join

New
March 26, 2021

In many cases, your data will be stored in different places. You might have your customer data in a Postgres database, and your sales data in Salesforce. We support many integrations that let you pull data from all these sources. However, you also need to be able to merge these tables. From now on, it is very easy to do that with the newest “Horizontal join” block.

With the newest data block, you can merge your tables using four types of horizontal joins:

  1. Inner join: return records that only have matching values in both tables
  2. Left join: return all records front he left table, and matching values in both tables
  3. Right join: return all records from the right table, and matching values in both tables
  4. Full outer join: return all records when there is a match in either left or right table

select *

Merge two datasets with horizontal join

New

In many cases, your data will be stored in different places. You might have your customer data in a Postgres database, and your sales data in Salesforce. We support many integrations that let you pull data from all these sources. However, you also need to be able to merge these tables. From now on, it is very easy to do that with the newest “Horizontal join” block.

With the newest data block, you can merge your tables using four types of horizontal joins:

  1. Inner join: return records that only have matching values in both tables
  2. Left join: return all records front he left table, and matching values in both tables
  3. Right join: return all records from the right table, and matching values in both tables
  4. Full outer join: return all records when there is a match in either left or right table

Create data notebooks with Intersect Labs

This is your gateway to the magical land of Intersect Labs, where we help you streamline your data processes.
Get free access