FieldTransform can use a variety of functions to perform field-based transformations on the data source. A FieldTransform can have several functions, which can be implemented one after the other within the transform.
Each function in a FieldTransform has a context menu, accessed by clicking the three dots to the right of the function, with the following options:
- Edit: opens the function for editing.
- Duplicate: creates a copy of the function within the same Field Transform. The copy uses the same configuration as the original, with an incremented suffix added to the name (for example, "New Number Format (2)").
- Copy to: copies the function to another Field Transform. Choose the destination from all Field Transforms within Integrator; if the function already exists there, you can choose to override it.
To delete a function, select it and click on the X in the Function toolbar. 
Each function in a FieldTransform has a context menu, accessed by clicking the three dots to the right of the function, with the following options:
- Duplicate: creates a copy of the function within the same Field Transform. The copy uses the same configuration as the original, with an incremented suffix added to the name (for example, "New Number Format (2)").
- Delete: removes the function from the Field Transform.
See also Trimming and Space Values in Integrator.
| Aggregation | Calculates an aggregated value for several numerical source fields. |
| ColumnAggregation |
Performs sum, min, max, or count operations on numeric values from one or two columns and applies them to another column. |
| Concatenation | Merges several input fields into a new field |
| DateDuration | Calculates the number of hours, days, or other time unit between two different input dates or calculates a new date by adding a given number of hours, days, or other time unit to a given date. |
| DateFormat | Converts a date or time input into another date or time format. |
| Groovy | Executes a script in the Groovy programming language. |
| JavaScript | Executes a script in the JavaScript script language. |
| LastNonEmpty | Replaces the empty column values with the last column value of preceding rows that are not empty. |
| Lookup | Creates a dynamical mapping of values. |
| LookupInterval | Maps the values that are contained in dynamical intervals of a source. |
| Map | Transforms the input field via a fixed mapping list. |
| NumberFormat | Attempts to convert the input into a numerical figure. |
| OlapData | Gives you simple access to a single OLAP cube cell value during a transformation process. |
| Previous | Returns a column value from one of the preceding rows. |
| Python | Executes a script in the Python programming language. |
| Random | Returns a random integer or double value per row. |
| Replace | Replaces the text of an input field in accordance with a regular expression. |
| RowNumber | Creates a new column and counts the number of lines in the source starting from a defined start value. |
| Split | Splits the input text into separate parts around a given separator. It returns one of the parts specified by parameter occurrence. |
| SubString | Extracts a particular part of the input field. |
| Switch | Defines a complex condition to determine the function value. |
| UpperLower | Checks or changes an input field. |
Updated October 15, 2026