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).
| Task | Use it to | Covered |
|---|---|---|
| Add Column | Add empty columns with a name and type | Below |
| Copy Columns | Duplicate columns, optionally as another type | Below |
| Combine Columns & Text | Join columns and fixed text into one column | Combine or split columns |
| Split Into Multiple Columns | Break a text column into several by a delimiter | Combine or split columns |
| Remove Column | Take columns out of this View | Below |
| Convert Column Type | Change a column's type | Convert 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.
- Open Add Column (or choose Add New Column to the right in a column's 3-dot menu).
- In Define new column title, type a name.
- 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.
- 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.
- 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.
- In Select columns to duplicate, click + next to each column to copy. A search box appears when the list is long.
- 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.
- Optional: hover a row and click its edit icon to set the output options (below).
- 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 option | Choices |
|---|---|
| Place in | New Column, or Existing Column to overwrite one |
| Type for a Text column | T (Text) only |
| Type for a Number column | T (Text) or # (Number), with format controls (%, $, decimal places) |
| Type for a Date column | T (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.
- 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.
- Ticked columns appear as chips under Columns to be removed. Click a chip's X to untick it, or Clear to untick all.
- 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
| Limit | Value |
|---|---|
| Column title length in Add Column | Up to 300 characters |
Troubleshooting column tasks
| Message or symptom | Cause | Fix |
|---|---|---|
| "Input required" | A new column has no title | Type a title |
| "A column with same name already exists. Try another value" | The name matches a column in the View or another new column | Pick a unique name |
| A removed column is needed again | Remove Column is a pipeline task | Suspend or delete that task |
Related
- Combine or split columns: merge columns or break one apart.
- Convert text to dates and numbers: the sixth Column Management task.
- Rename, format and sort columns: rename and hide columns without a task.
- Label rows, edit cells and fill blanks: fill a new column with values.
Something wrong? support@mammoth.io