Skip to content
Learn › Clean and shape data: open the docs menu

Add, copy and remove columns with pipeline tasks

The Column Management category in Describe your transformation adds, copies, combines, splits, converts and removes columns. Each is a pipeline task, so it changes the View's structure and re-runs on every refresh. To rename a column, use the grid instead: double-click the header or choose Rename Column in its 3-dot menu (a Display Change, not a task).

Column Management category open showing all 6 functions
TaskUse it toCovered
Add ColumnAdd empty columns with a name and typeBelow
Copy ColumnsDuplicate columns, optionally as another typeBelow
Combine Columns & TextJoin columns and fixed text into one columnCombine or split columns
Split Into Multiple ColumnsBreak a text column into several by a delimiterCombine or split columns
Remove ColumnTake columns out of this ViewBelow
Convert Column TypeChange a column's typeConvert text to dates and numbers

Add a new empty column

Add Column adds one or more empty columns. You fill them with later tasks such as Label & Insert Values or Math Function.

Add Column panel open, showing three rows each with a column title
  1. Open Add Column (or choose Add New Column to the right in a column's 3-dot menu).
  2. In Define new column title, type a name.
  3. In Choose new column type, pick a type. Number opens Number, ID, Percentage and Currency; Text opens Text and ID; Date is a single option. See Column types, IDs, currency and percentages.
  4. To add more columns in the same task, click Add more. Each row has its own name and type. Click the trash icon to drop a row.
  5. Click Apply.

A title is required ("Input required") and can be up to 300 characters. It must not match another new column or an existing column ("A column with same name already exists. Try another value").

Copy a column

Copy Columns duplicates one or more columns. Use it to keep an original before you transform it, or to get a version in another type or format. A column's 3-dot menu has the same thing as Duplicate column values.

Copy Columns panel with brand, customer_age and sales_rep selected and new names such as Copy of brand
  1. In Select columns to duplicate, click + next to each column to copy. A search box appears when the list is long.
  2. Each column appears under Copied columns as source → destination. The default name is "Copy of brand" (for a column named brand). Edit it in the name field.
  3. Optional: hover a row and click its edit icon to set the output options (below).
  4. Click Apply.

Click the X on a row to drop it from the list. Hovering a row also shows a filter icon, which limits the copy to rows that match a condition.

Output optionChoices
Place inNew Column, or Existing Column to overwrite one
Type for a Text columnT (Text) only
Type for a Number columnT (Text) or # (Number), with format controls (%, $, decimal places)
Type for a Date columnT (Text) or the date icon, with a Date Format dropdown for how the copy shows the date

Remove columns and get them back

Remove Column takes one or more columns out of this View.

Remove Column panel open, showing a searchable column checklist
  1. In Select column(s) to remove, tick one or more columns. They show type icons (T for text, # for number, clock for date). Use the search box to find columns.
  2. Ticked columns appear as chips under Columns to be removed. Click a chip's X to untick it, or Clear to untick all.
  3. Click Apply.

You can also remove columns from a column's 3-dot menu (Remove Column) or by selecting several headers and choosing Remove in the multi-column menu. See Work in the data grid.

Removal is a pipeline task that affects this View only, and later tasks can't use the removed columns. To bring a column back, suspend or delete the Remove Column task in the Pipeline panel. To clear a column from the grid but keep it for tasks, use Hide Column instead.

Limits

LimitValue
Column title length in Add ColumnUp to 300 characters

Troubleshooting column tasks

Message or symptomCauseFix
"Input required"A new column has no titleType a title
"A column with same name already exists. Try another value"The name matches a column in the View or another new columnPick a unique name
A removed column is needed againRemove Column is a pipeline taskSuspend or delete that task
Was this page helpful?

Something wrong? support@mammoth.io