View All Docs
Product Overview
A down-facing caret indicating that this drawer is closed. Click to open it.
Account Overview
Integrations
A down-facing caret indicating that this drawer is closed. Click to open it.
Transforms
A down-facing caret indicating that this drawer is closed. Click to open it.
Security
A down-facing caret indicating that this drawer is closed. Click to open it.
CONTENTS
Transforms   ->

Edit columns

The Edit columns step allows you to keep or remove columns, rename them, and then reorder those columns – all from one step! This step will replace the following steps: Select columns, Rename columns, and Reorder columns.

Keep or Remove columns

When you first connect your data into the Edit columns step, the Keep/Remove section will auto-select to Keep all columns. From the dropdown you will have 3 options:

  • Keep all columns
  • Keep these columns
  • Remove these columns

If you choose to Keep all columns, you will see all of the columns in your data present.

Choosing to Keep these columns, will allow you to select the columns that you would like to keep. You can use the Add all or Clear all button if you need to bulk update or clear your selection:

The Remove these columns option will remove the columns that you are selecting from your data. There is an Add all and Clear all option that you can use to add all of the columns or clear your selection:

There is an option to Guarantee your kept columns. Guaranteed columns are kept even if they are later missing from the input data (e.g., an API that doesn’t include a column of data if it’s blank). Check the box to keep your columns even if they are later missing from the data you are pulling in:

Rename and Reorder columns

From the Rename/Reorder section of the step, you can update the names of your columns. To do this, click the name of the column in that section. You should then be able to type in or update the column’s name. If you need to reset the name of the columns, you can do so individually by clicking the reset icon next to the column or reset all the names by clicking the Reset names button.

You can update the column order in the Rename/Reorder by clicking the symbols next to the column number and dragging and dropping the column into  the order you’d like to use. You can reset the column order by selecting the Reset order option.

Contents