Column Bulk editor
Coalesce supports bulk editing of columns in Column grid view. Similar to the bulk edit in the mapping grid, the Column bulk editor allows you to edit columns from any non-source node.
How to bulk edit?
- Select the columns you want to edit, right click and select Bulk edit columns

Bulk edit columns in Column grid view
- This will open up a window where you can select the attributes you would like to edit.

Bulk edit Attributes
Editing Column Names
Column bulk editor also supports jinja for the Column name attribute.
{
column: {
name
id
dataType
description
nullable
defaultValue
}, // the column being edited
columns: [], // all columns, including the current one
storageLocations: [] // currently available storage locations
config: {} // any user defined config attributes defined in node spec
sources: [] // all sources for current node
node: {} // all current node metadata
this: {} // {{ ref_no_link for current node }}
parameters: "" // runtime parameters
}
For example: Add in a prefix
myPrefix_{{ column.name }}
Removing foo from a column name
{{ column.name | replace("foo", "") }}
- Click on Preview to view the changes and click on Update to apply those changes to the columns.

Preview and Update columns
Updated 16 days ago