Derive
- 06 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Derive
- Updated on 06 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 new 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 a number of node relevant snippets. |
Parameters | Typing # within the script editor will prompt the user for a list of available parameters. |
Actions
| Action | Description |
|---|---|
Preview | After configuring the node, the source data can be previewed by clicking the Preview button. |
Was this article helpful?