| Transform | Description |
|---|---|
| Join | Join elements of an array as a string, based on a defined delimiter. |
| 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. |
| Transform | Description |
|---|---|
| Cast to boolean | Convert a number value to a boolean (true/false) value based on PHP logic. |
| 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. |
| Transform | Description |
|---|---|
| Cast to boolean | Define override values for conversion to true/false. |
| 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 to string | Convert a null value to an empty string. |
| Null to zero | Convert a null value to zero (0). |
| 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. |
| Transform | Description / Notes |
|---|---|
| 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. |
| Contains one of many | Specify a comma separated list of field values to be matched for inclusion. |
| Convert string to boolean | Convert a string value to a boolean (true/false) value based on PHP logic. |
| Country code | Apply country codes of a selected type (Alpha 1, Alpha 2, Numeric). Note that this transform will cause the map step to fail if an empty value is received. |
| Country name | Return the country name for a country code. Note that this transform will cause the map step to fail if an empty value is received. |
| Custom string | Apply static text or reference variables. |
| Does not contain one of many | Specify a comma separated list of field values to be matched for exclusion. |
| First word | Get the first word from a string. |
| Hash | Convert a string to a SHA1 Hash. |
| JSON encode | Encode data into JSON format. Note that although this is listed as a string type transform, any data type is supported. |
| 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 characters to the beginning of a field. |
| Replace | Replace any given character(s) with another character. |
| Split | Split elements of a string into an array. |
| Substring | Return part of a string value. |
| 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. |