Derive
- 13 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Derive
- Updated on 13 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Description
The Derive node is used to create new fields (columns) based on an existing field or formula in your dataset. The derive node performs its calculations using either the standard JavaScript language or regular expressions (regex) 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 based on your requirements for the newly derived field. |
Script | Craft your script, with JavaScript or regex, to define the new field. |
Advanced Configuration Options
| Setting | Description |
|---|---|
Script Snippets | Typing @ within the script editor will prompt the user for several node-relevant snippets. |
Parameters | Typing # within the script editor will prompt the user for a list of available parameters. |
Actions
| Action | Description |
|---|---|
Preview | Once the node is configured, the source data can be previewed at any time. |
Was this article helpful?