Description
The Derive node introduces the capability to create new columns based on a formula or an existing column in your dataset. The derive node performs its calculations using either the standard JavaScript language or a regular expressions (regex) as way to script your new field.
Configuration Options
Basic Configuration Options
| Setting | Description\Parameters |
|---|---|
Column Name |
The name of the new column to be created. |
JavaScript or Regex |
Toggle between these choices for the new derived field. |
Script |
Craft your script in JavaScript here to define the new field. |
RegEx |
Regular expression to use if RegEx is selected. |
RegEx Search In Column |
Column to search if RegEx is selected. |