Available transform functions

Introduction

Available transform functions are summarised in the following categories:

• Date & time

• String

• Number

• Other

Date & time

Transform	Description
Custom dynamic date	Apply the date that a process flow runs, with or without adjustments.
Custom static date	Apply a static date.
Format	Convert a date to a predefined or custom format.
Round date	Round a date up/down to the start/end of the day.
Time now	Returns the current date and time in your required format.
Timezone	Convert dates to a selected timezone.

String

Transform	Description
Cast to float	Change the source field data type from string to float.
Cast to number	Change the source field data type from string to number.
Concatenate	Join selected fields with a selected character.
Country code	Apply country codes of a selected type (Alpha 1, Alpha 2, Numeric).
Country name	Return the country name for a country code.
Custom string	Apply static text or reference variables.
First word	Get the first word from a string.
Hash	Convert a string to a SHA1 Hash.
JSON encode	Encode data into JSON format.
Last word	Get the last word from a string.
Limit	Truncates a string to a given length.
Lowercase	Convert to lowercase.
Pad	Pad an existing string of characters to a given length, using a given character.
Prefix	Add a string to the beginning of a field.
Replace	Replace any given character(s) with another character.
Substring	Return a given number of characters from a given start.
Suffix	Add a string to the end of a field.
Trim whitespace	Remove any characters around a string.
Uppercase	Convert to uppercase.
URL decode	Convert an encoded URL into a readable format.
URL encode	Convert a string to a URL encoded string.

Number

Transform	Description
Cast to string	Change the source field data type from number to string.
Ceiling	Round up to the nearest whole number.
Custom number	Apply a static number.
Floor	Round down to the nearest whole number.
Make negative	Convert number to a negative.
Make positive	Convert number to a positive.
Math	Perform a mathematical operation for selected fields.
Round number	Change the number of decimal places.

Other

Transform	Description
Cast boolean to string	Change the source field data type from boolean to string.
Cache lookup	Reference a value from cached data.
Convert weight	Convert a specified weight unit to a given alternative.
Custom boolean	Apply a true or false value.
Fallback	Set a default value to be used if the given input is empty. Blank values are supported.
Map	Convert values using a cross-reference lookup.
Null value	Convert a source value to null.
Script	Apply a field-level custom script. Note that a script will time out if it runs for more than 120 seconds.