Join different data sources based on matching columns step
https://www.youtube.com/embed/PCYHijmR0jY?rel=0&start=661&end=706
# 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:
- Merge a CSV with a spreadsheet- Join data from separate ecommerce store
- Merge scraped data sets
# 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 step.