Transform node

A transform node takes data from an upstream node, applies your chosen actions, such as summing values, converting characters, or extracting data, and passes the result to downstream nodes.

• Select which field you want to transform: Specifies the field from the data source to be transformed. You can select only one referenced field. The field you’re referencing must contain an object (key–value map) or a list of objects, not simple values like text or numbers. Insert dynamic values from upstream nodes by selecting the plus icon (+) and choosing the field.

• Define the transform action: Defines the action to take for the transformation and save the output to a new field. Below are the supported transformation operations. Note that different transform actions are configured differently.

  • Concatenation: Combines multiple values or fields into a new field.
  • Join: Joins a selected field to the referenced field to form a new field.
  • First item: Retrieves the first item from an array.
  • Last item: Retrieves the last item from an array.
  • Extract: Retrieves a specific part of a field's value using a regular expression written in syntax accepted by RE2. You can further select Regex flags such as case sensitivity, multi-line matching, and whether to return after the first match.
  • Upper case: Converts all characters in a text field to uppercase.
  • Lower case: Converts all characters in a text field to lowercase.
  • Average: Averages all values from every instance of the referenced field to form a new field. The referenced field must be of integer or float data type.
  • Sum: Adds the values from every instance of the referenced field to form a new field. The referenced field must be of integer or float data type.
  • To integer: Converts a field's value to a whole number and stores it in a new field.
  • To float: Converts a field's value to a decimal value and stores it in a new field.
  • Append to map: Adds one or more key-value pairs to the object in the referenced field. The referenced field must be an object (map) whose values are all strings.
  • Remove from map: Removes one or more keys from an object in the referenced field.

• Test: Allows you to test the node.