Join different data sources based on matching columns step

# What to use the Join different data sources based on matching columns step for

Use this to Join data gathered from different sources together. A shared column is used to combine the two. For example, use this to join product info from different e-commerce sites or to merge a Google Sheet with a CSV.

You can use this step to:

# How to configure the Join different data sources based on matching columns step

# Base data

Enter the base data to join with another.

# Base data column

Column of data to use as the basis of the join. For example, if you want to join based on company name, enter the column number or letter which contains the company name here.

# Join data

Enter the data you want to join with the base data.

# Column

Specify a particular column of the base data to always match against. Leave this blank to match with any column.

# Fuzzyness of the match

Specify a particular column of the base data to always match against. Leave this blank to match with any column.

# Output

A preview results returned by this Join step.

Configuration settings

    Step type

    Manipulate data