Contents x
    Derive
    • 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Derive

    • Updated on 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    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

    SettingDescription\Parameters
    Column NameThe name of the new column to be created.
    JavaScript or RegexToggle between these choices for the new derived field.
    ScriptCraft your script in JavaScript here to define the new field.
    RegExRegular expression to use if RegEx is selected.
    RegEx Search In ColumnColumn to search if RegEx is selected.

    Video Guide

    Was this article helpful?
    What's Next