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?

  1. Select the columns you want to edit, right click and select Bulk edit columns
Bulk edit columns in Column grid view

Bulk edit columns in Column grid view

  1. This will open up a window where you can select the attributes you would like to edit.
Bulk edit Attributes

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", "") }}

Change all column names to UPPER.

{{ column.name | upper }}
  1. Click on Preview to view the changes and click on Update to apply those changes to the columns.
Bulk edit - Jinja support with column var

Preview and Update columns