---
sourceDocument: Australia ServiceNow AI Platform Capabilities
sourceDocumentLink: https://www.servicenow.com/docs/r/servicenow-platform

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia ServiceNow AI Platform Capabilities

ft:clusterId :

    - platcap

bundleId :

    - platcap

workflow :

    - Platform


---

# Operation types

# RTE operation types included within the Integration Commons for CMDB app {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 9 minutes to read

The Robust Transform Engine (RTE) operation types are common operation methods for use in ETL without having to write your own complex data transformations.
The following operation types are available in the Integration Commons for CMDB app.

## Concatenation {#cmdb-rte-operation-types__section_rxl_tnv_qwb}

Combines the values from input fields into a single string, joining them on the optional joining_string field.  
{#cmdb-rte-operation-types__table_bqc_ynv_qwb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Concatenation Operation \[sys_rte_eb_concat_operation\] |
| Input field | source_sys_rte_eb_fields Input is a set of fields and constants. |
| Output field | target_sys_rte_eb_field Output is the combined value of the provided fields as a single string. |
| Additional fields | joining_string (optional) |
[ ]

{#cmdb-rte-operation-types__table_bqc_ynv_qwb}  
{#cmdb-rte-operation-types__table_hrk_ttc_11c__entry__3}

| Input | joining_string | Result |
|-|-|-|
| "input_1", "input_2", "input_3" | ", " | "input_1, input_2, input_3" |
[Table 1. Example]

{#cmdb-rte-operation-types__table_hrk_ttc_11c}

## Convert to Boolean {#cmdb-rte-operation-types__section_usk_hk1_nkb}

Converts the incoming value to a Boolean.  
{#cmdb-rte-operation-types__table_jfy_3k1_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Convert to Boolean Operation \[sys_rte_eb_to_boolean_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_field Output is `true` when input is `true` or `1`, otherwise output is `false`. (case insensitive) |
[ ]

{#cmdb-rte-operation-types__table_jfy_3k1_nkb}  
{#cmdb-rte-operation-types__table_hsh_mt1_bmb__entry__2}

| Input | Result |
|-|-|
| input_1 | false |
| true | true |
| 1 | true |
| 0 | false |
| 11 | false |
[Table 2. Example]

{#cmdb-rte-operation-types__table_hsh_mt1_bmb}

## Convert to Date {#cmdb-rte-operation-types__section_dkx_zl1_nkb}

Attempts to convert the incoming value to a GlideDateTime value by applying the date_format to the incoming value.  
{#cmdb-rte-operation-types__table_ekx_zl1_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Convert to Date Operation \[sys_rte_eb_to_date_operation\] |
| Input field | source_sys_rte_eb_field Input is a data timestamp value with date format. |
| Output field | target_sys_rte_eb_field Output is the date timestamp in the specified date format. Attempts to directly convert using GlideDateTime if the date_format is incorrect. Returns an empty value if unable to parse at all. |
[ ]

{#cmdb-rte-operation-types__table_ekx_zl1_nkb}  
{#cmdb-rte-operation-types__table_gcp_tt1_bmb__entry__2}

| Input | Result |
|-|-|
| "2018/09/20 11:21:00 AM EST" with date_format "yyyy/MM/dd hh:mm:ss a z" | "2018-09-20 16:21:00" |
| "2018/09/20 01:21:00 PM EST" with date_format "yyyy/MM/dd hh:mm:ss a z" | "2018-09-20 18:21:00" |
| "09/20/18" with date_format "yyyy/MM/dd hh:mm:ss a z" | ""0018-09-20 00:00:0" |
[Table 3. Example]

{#cmdb-rte-operation-types__table_gcp_tt1_bmb}

## Convert to Numeric {#cmdb-rte-operation-types__section_xrv_lxm_4yb}

Converts the incoming value to a number.  
{#cmdb-rte-operation-types__table_yrv_lxm_4yb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Convert to Numeric Operation \[sys_rte_eb_to_numeric_operation\] |
| Input field | source_sys_rte_eb_field Input is a value. |
| Output field | target_sys_rte_eb_field Output is a numeric value. If the input value is non-numeric the output is empty. |
[ ]

{#cmdb-rte-operation-types__table_yrv_lxm_4yb}  
{#cmdb-rte-operation-types__table_hzv_jvc_11c__entry__2}

| Input | Result |
|-|-|
| input_1 | null |
| 1.23 | 1.23 |
| 1.00 | 1 |
| two | null |
[Table 4. Example]

{#cmdb-rte-operation-types__table_hzv_jvc_11c}

## Copy {#cmdb-rte-operation-types__section_pzx_km1_nkb}

Copies the value of the source field to all the target fields.  
{#cmdb-rte-operation-types__table_qzx_km1_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Copy Operation \[sys_rte_eb_copy_operation\] |
| Input field | source_sys_rte_eb_field Input is a value. |
| Output field | target_sys_rte_eb_fields Output is the copied source field value. |
| Additional field | overwrite_existing_value (optional, Boolean): If `true`, then the values of the target fields are replaced. Otherwise, any non-empty value isn't overwritten. |
[ ]

{#cmdb-rte-operation-types__table_qzx_km1_nkb}

## Extract First Numeric {#cmdb-rte-operation-types__section_anb_bn1_nkb}

Sets the target field as the first numeric value found in the source field.  
{#cmdb-rte-operation-types__table_bnb_bn1_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Extract Numeric Operation \[sys_rte_eb_extract_numeric_operation\] |
| Input field | source_sys_rte_eb_field Input is a value. |
| Output field | target_sys_rte_eb_field Output is the numeric value found in the input. |
| Additional fields | * decimal_places (optional, number) : Forces the output to have a specified number of decimal places. * remainder_target_field (optional, reference to field): Set to the trimmed remainder of the source field, after removing the first numeric value. {#cmdb-rte-operation-types__ul_oww_41x_c1c} |
[ ]

{#cmdb-rte-operation-types__table_bnb_bn1_nkb}  
{#cmdb-rte-operation-types__table_ts4_c51_bmb__entry__2}

| Input | Result |
|-|-|
| 100 mb | 100 |
| 100.123 mb | 100.123 |
| 100.123 mb with decimal_places=2 | 100.12 |
| 100 mb with decimal_places=2 | 100.00 |
| 100 mb with remainder_target_field | mb |
[Table 5. Example]

{#cmdb-rte-operation-types__table_ts4_c51_bmb}

## Glide Lookup Operation {#cmdb-rte-operation-types__section_n5n_fl1_nkb}

Performs a lookup in the database on the target table specified in the target_table field.  
{#cmdb-rte-operation-types__table_o5n_fl1_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Glide Lookup Operation \[sys_rte_eb_glide_lookup_operation\] |
| Input field | source_sys_rte_eb_fields The database table for lookup. |
| Output field | target_sys_rte_eb_fields The resulting data based on the lookup operation. |
| Additional fields | * target_table * glide_matching_fields (string): Comma-separated list of column names in the target table. For each input field in source_sys_rte_eb_fields, there must be an equal number of values in glide_matching_fields. * glide_target_fields (string): Comma-separated list of column names in the target table. For each target field in target_sys_rte_eb_fields, there must be an equal number of values in glide_target_fields. {#cmdb-rte-operation-types__ul_itq_zzw_c1c} |
[ ]

{#cmdb-rte-operation-types__table_o5n_fl1_nkb}  
{#cmdb-rte-operation-types__table_vwc_g51_bmb__entry__2}

| Input | Result |
|-|-|
| * Input Field 1: 100 South Charles Street, Baltimore * Input Field 2: MD * Target Table: Location (cmn_location) * Glide Matching Fields: street,state * Glide Target Fields: sys_id {#cmdb-rte-operation-types__ul_qpg_21x_c1c} | Output Field 1: 25ab9c4d0a0a0bb300f7dabdc0ca7c1c |
[Table 6. Example]

{#cmdb-rte-operation-types__table_vwc_g51_bmb}

## Multiple Input Script  {#cmdb-rte-operation-types__section_q5j_wv1_d1c}

Runs a script with multiple inputs setting the target_sys_rte_eb_field field as the output for that script.
{#cmdb-rte-operation-types__table_hty_g2d_jmb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Multiple Input Script Operation \[sys_rte_eb_multi_in_script_operation\] |
| Input field | source_sys_rte_eb_fields Input is a script. |
| Output field | target_sys_rte_eb_field Output is the result of the input script. |
| Additional Fields | * script (script) * use_unique_input_sets(Boolean): When `true`, only unique input values are included in the data batch for IRE processing. Otherwise, all input object's field values are included. {#cmdb-rte-operation-types__ul_h1v_5xw_c1c} |
[ ]

{#cmdb-rte-operation-types__table_hty_g2d_jmb}

Example for using use_unique_input_sets, with a script function that takes `record_type` and `operating_system` as input and returns `record_with_os`:
{#cmdb-rte-operation-types__table_ls1_bcg_kmb__entry__3}

| Record | record_type | operating_system |
|-|-|-|
| 1 | computer | Windows XP |
| 2 | computer | Linux |
| 3 | computer | Windows XP |
[Table 7. Examples]

{#cmdb-rte-operation-types__table_ls1_bcg_kmb}

If use_unique_inputs_sets is set to `true`, then the script processes only two values (`computer` + `Windows XP` and `computer` + `Linux`). If
`use_unique_inputs_sets` is set to `false`, then each of the three values is individually processed (`computer` + `Windows XP`, `computer` +
`Linux`, and `computer` + `Windows XP`).  
Sample script:

    (function(batch, output) { 
                    for (var i = 0; i < batch.length; i++) { 
                            // batch[i] is the unique set of inputs/individual record 
                            // batch[i].<field> gives access to the field value 
                            var in0 = gs.nil(batch[i].record_type) ? '' : batch[i].record_type;
                            var in1 = gs.nil(batch[i].operating_system) ? '' : batch[i].operating_system;
                            // output[i] is the output for the specific combination of inputs/individual record 
                            output[i] = in0 + "_" + in1; 
                        } 
                    } 
                })(batch, output);

## Multiple Input/Output Script {#cmdb-rte-operation-types__section_sdl_gq1_d1c}

Runs a script with multiple inputs setting the target fields specified in the target_sys_rte_eb_fields field as the multiple outputs for that script.
{#cmdb-rte-operation-types__table_tdl_gq1_d1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Multiple Input/Output Script Operation \[sys_rte_eb_multiple_input_output_script_operation\] |
| Input field | source_sys_rte_eb_fields Input is a script. |
| Output field | target_sys_rte_eb_fields Output is the result of the input script. |
| Additional Fields | script (script) |
[ ]

{#cmdb-rte-operation-types__table_tdl_gq1_d1c}  
Sample script:

    (function(batch, output) { 
                    for (var i = 0; i < batch.length; i++) { 
                            var userId = (batch[i].user_id);
                            var userIdParts = userId.split(".");
                            output[i].first_name = userIdParts[0]; 
                            output[i].last_name = userIdParts[1];
                        } 
                    } 
                })(batch, output);

## Regex Replace  {#cmdb-rte-operation-types__section_oyv_h41_nkb}

Replaces each substring of the input string that matches the regular expression pattern specified in the match_regex field with the string specified in the replacement_regex field.  
{#cmdb-rte-operation-types__table_pyv_h41_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Regular Expression Replace Operation \[sys_rte_eb_regex_replace_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_field Output is the replaced string. |
| Additional fields | * match_regex (string, regular expression) * replacement_regex (string)  {#cmdb-rte-operation-types__ul_kl2_cww_c1c} |
[ ]

{#cmdb-rte-operation-types__table_pyv_h41_nkb}  
{#cmdb-rte-operation-types__table_dtg_m4v_c1c__entry__2}

| Input | Result |
|-|-|
| "String\&With(Special)$Characters" with match_regex="\[\^0-9a-zA-Z\]+" and replacement_regex=" " | "String With Special Characters" |
[Table 8. Example]

{#cmdb-rte-operation-types__table_dtg_m4v_c1c}

## Replace  {#cmdb-rte-operation-types__section_zkq_54v_c1c}

Replaces each substring of the input string that matches the string specified in the match_string field with the string specified in the replacement_string field.  
{#cmdb-rte-operation-types__table_alq_54v_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Replace Operation \[sys_rte_eb_replace_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_field Output is the replaced string. |
| Additional fields | * match_string (string) * replacement_string (string) {#cmdb-rte-operation-types__ul_krx_pvw_c1c} |
[ ]

{#cmdb-rte-operation-types__table_alq_54v_c1c}  
{#cmdb-rte-operation-types__table_blq_54v_c1c__entry__2}

| Input | Result |
|-|-|
| "Original String" with match_string = "Original" and replacement_string= "Replacement" | "Replacement String" |
[Table 9. Example]

{#cmdb-rte-operation-types__table_blq_54v_c1c}

## Round Numeric {#cmdb-rte-operation-types__section_em5_fpv_c1c}

Rounds off the input numeric value to the nearest whole number.  Non-numbers are truncated.  
{#cmdb-rte-operation-types__table_fm5_fpv_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Round Numeric Operation \[sys_rte_eb_round_numeric_operation\] |
| Input field | source_sys_rte_eb_field Input is a numeric value. |
| Output field | target_sys_rte_eb_field Output is a whole number. |
| Additional fields | * match_string (string) * replacement_string (string) {#cmdb-rte-operation-types__ul_e1f_3vw_c1c} |
[ ]

{#cmdb-rte-operation-types__table_fm5_fpv_c1c}  
{#cmdb-rte-operation-types__table_gm5_fpv_c1c__entry__2}

| Input | Result |
|-|-|
| "1.5" | "2" |
| "1.4" | "1" |
| "i'm a string" | ""  |
[Table 10. Example]

{#cmdb-rte-operation-types__table_gm5_fpv_c1c}

## Script Operation {#cmdb-rte-operation-types__section_edp_lpv_c1c}

Runs a script with an input and sets the target_sys_rte_eb_field field as the output for that script.  
Note:  
The Script operation type has been largely superseded by the Multi Input Script Operation and is included for backwards compatibility with the existing configurations.   
{#cmdb-rte-operation-types__table_fdp_lpv_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Script Operation \[sys_rte_eb_script_operation\] |
| Input field | source_sys_rte_eb_field Input is a script. |
| Output field | target_sys_rte_eb_field Output is the result of the input script. |
| Additional fields | * script(script) * use_unique_input_sets (Boolean): When `true`, only unique input values are included in the data batch for IRE processing. Otherwise, all input object's field values are included. For an example and for more details, see the Multiple Input Script transform. {#cmdb-rte-operation-types__ul_p1f_h5w_c1c} |
[ ]

{#cmdb-rte-operation-types__table_fdp_lpv_c1c}  
The source field is included in the 'batch' variable as the JavaScript field 'input'.

    (function(batch, output) { 
                    for (var i = 0; i < batch.length; i++) { 
                            // batch[i] is the unique set of inputs/individual record 
                            // batch[i].input gives access to the field value 
                            var in0 = gs.nil(batch[i].input) ? '' : batch[i].input; 
                            // output[i] is the output for the specific combination of inputs/individual record 
                            output[i] = in0 + " modified by script"; 
                        } 
                    } 
                })(batch, output); 

Example:

    /* Example Script
     (function(batch, output) {
         for (var i = 0; i < batch.length; i++) {
             //step1: access the input variables
             var a = batch[i].input; //Value of the source field.
     
             //step2: Your script/code goes here.
             var b = a + 1;
             //step3: set the output for each elements
             output[i] = b;
         }
     })(batch, output);
    */ 

## Set  {#cmdb-rte-operation-types__section_ocx_ypv_c1c}

Sets the target_sys_rte_eb_field field value to the string provided in the set_value field.  
{#cmdb-rte-operation-types__table_pcx_ypv_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Set Operation \[sys_rte_eb_set_operation\] |
| Output field | target_sys_rte_eb_field Output is the value associated with the set_value field. |
| Additional fields | * set_value (string) * overwrite_existing_value (optional, Boolean) : When true, the current value of the target field is overwritten. Otherwise, a non-empty value isn't replaced. {#cmdb-rte-operation-types__ul_hjd_wtw_c1c} |
[ ]

{#cmdb-rte-operation-types__table_pcx_ypv_c1c}

## Set Min/Max {#cmdb-rte-operation-types__section_ozz_241_nkb}

Sets the target field to either the maximum or minimum of the values from all input fields.  
{#cmdb-rte-operation-types__table_pzz_241_nkb__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Min/Max Operation \[sys_rte_eb_min_max_operation\] |
| Input field | source_sys_rte_eb_fields Input is a set of values. |
| Output field | target_sys_rte_eb_field Output is the maximum or minimum value based on the min_max value. |
| Additional fields | * data_type (choice list with values as STRING, NUMERIC, and DATE) * min_max (choice list with values as MIN and MAX)  {#cmdb-rte-operation-types__ul_vmf_bzw_c1c} |
[ ]

{#cmdb-rte-operation-types__table_pzz_241_nkb}  
{#cmdb-rte-operation-types__table_u24_t41_nkb__entry__2}

| Input | Output |
|-|-|
| "2", "-1", "0" | 2 |
| "a", "b" | c |
| "2", "-1", "0" | -1 |
| "a", "b" | a |
[Table 11. Examples]

{#cmdb-rte-operation-types__table_u24_t41_nkb}

## Split  {#cmdb-rte-operation-types__section_llh_2qv_c1c}

Splits the string included in the source_sys_rte_eb_field input value at the separator specified in the splitting_string field and assigns the resulting array of strings to the
target_sys_rte_eb_field field, in order.  
{#cmdb-rte-operation-types__table_mlh_2qv_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Split Operation \[sys_rte_eb_split_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_fields Output is list of substrings. |
| Additional fields | splitting_string (string)  |
[ ]

{#cmdb-rte-operation-types__table_mlh_2qv_c1c}  
{#cmdb-rte-operation-types__table_byl_kqv_c1c__entry__2}

| Input | Result |
|-|-|
| "value1\|\|value2\|\|value3", splitting_string:"\|\|" with target_sys_rte_eb_fields {target1,target2,target3} | target1 : value1, target2 : value2, target3 : value3   |
| "value1\|\|value2\|\|value3", splitting_string:"\|\|" with target_sys_rte_eb_fields {target1} | target1 : value1  |
| "value1", splitting_string:"\|\|" with target_sys_rte_eb_fields {target1,target2,target3} | target1 : value1, target2 : \<null\>, target3 : \<null\> |
[Table 12. Example]

{#cmdb-rte-operation-types__table_byl_kqv_c1c}

## Trim  {#cmdb-rte-operation-types__section_bsp_4qv_c1c}

Removes any whitespaces at the beginning and at the end of the string included in the source_sys_rte_eb_field input value and assigns the result to the target_sys_rte_eb_field field.  This
transform is equivalent to the Java String trim() Method.  
{#cmdb-rte-operation-types__table_csp_4qv_c1c__entry__1}

| Details ||
|-|-|
| Table | RTE Entity Trim Operation \[sys_rte_eb_trim_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_field Output is the input string value but without any leading and trailing spaces. |
[ ]

{#cmdb-rte-operation-types__table_csp_4qv_c1c}  
{#cmdb-rte-operation-types__table_dsp_4qv_c1c__entry__2}

| Input | Result |
|-|-|
| " value 1 " | "value 1" |
[Table 13. Example]

{#cmdb-rte-operation-types__table_dsp_4qv_c1c}

## Uppercase {#cmdb-rte-operation-types__section_dwd_tqv_c1c}

Changes all characters of the source_sys_rte_eb_field input value to upper case and assigns the result to the target_sys_rte_eb_field field.  
{#cmdb-rte-operation-types__table_ewd_tqv_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Upper Case Operation \[sys_rte_eb_upper_case_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_field Output is the upper case string value. |
[ ]

{#cmdb-rte-operation-types__table_ewd_tqv_c1c}  
{#cmdb-rte-operation-types__table_fwd_tqv_c1c__entry__2}

| Input | Result |
|-|-|
| "value1" | "VALUE1" |
[Table 14. Example]

{#cmdb-rte-operation-types__table_fwd_tqv_c1c}

## Uppercase Trim  {#cmdb-rte-operation-types__section_ukq_xqv_c1c}

Combines both the Uppercase and the Trim transforms.  
{#cmdb-rte-operation-types__table_vkq_xqv_c1c__entry__1}

| Details ||
|:-:|-|
| Table | RTE Entity Upper Case Trim Operation \[sys_rte_eb_upper_case_trim_operation\] |
| Input field | source_sys_rte_eb_field Input is a string value. |
| Output field | target_sys_rte_eb_field Output is the upper case string value without any whitespaces at the beginning and end. |
[ ]

{#cmdb-rte-operation-types__table_vkq_xqv_c1c}  
{#cmdb-rte-operation-types__table_wkq_xqv_c1c__entry__2}

| Input | Result |
|-|-|
| "      value1    " | "VALUE1" |
[Table 15. Example]

{#cmdb-rte-operation-types__table_wkq_xqv_c1c}