Transform data

A transform node is used to change data from one node before it goes into the next node.

• Data source: The action node that provides input to the transform node. You can select only an action node positioned before the current node in the CloudFlow.

• Referenced field: Specifies the field from the data source to be transformed. You can select only one referenced field.

• 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 the integer or float data type.