Append or Merge data step

# What to use the Append or Merge Data step for

Use this step to merge data by appending one to the other. You can append either horizontally, which merges rows, or vertically, which adds all the columns in the second set to the end of the first. We often use this step to append the URL of the webpage we are 'scraping' to the scraped data.

You can use this step to:

  • Combine Google Sheet data with scraped data
  • Merge scarped data to a CSV
  • Join two sets of scraped data

If you are looking to join different data sources based on matching columns try this step.

# How to configure the Append or Merge Data step

If you need to combine more than two columns of data use multiple Append data steps. You can also select Append steps inside of Append steps.

# Data A

Select the Data to be appended to (For example, data from a Google Sheet.) When selecting data, click on the token to see a preview. Click 'Save and close' to select all or click 'Clear All' to choose columns individually.

# Data B

Select the Data to be appended (For example, data from the Get data step.) When selecting data, click on the token to see a preview. Click 'Save and close' to select all or click 'Clear All' to choose columns individually.

# Append mode

Choose to append the data horizontally or vertically. Axiom.ai's data is formatted in a 2d array, so we commonly use the horizontal method which adds a column to the end of the array.

# Output

A preview of the appended data, so you can decide how you want to add it.

Configuration settings

    Step type

    Manipulate data