RTE operation types included within the Integration Commons for CMDB app

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

Combines the values from input fields into a single string, joining them on the optional joining_string field.

Convert to Boolean

Converts the incoming value to a Boolean.

Convert to Date

Attempts to convert the incoming value to a GlideDateTime value by applying the date_format to the incoming value.

Convert to Numeric

Converts the incoming value to a number.

Copy

Copies the value of the source field to all the target fields.

Extract First Numeric

Sets the target field as the first numeric value found in the source field.

Glide Lookup Operation

Performs a lookup in the database on the target table specified in the target_table field.

Multiple Input Script

Runs a script with multiple inputs setting the target_sys_rte_eb_field field as the output for that script.

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:

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

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.

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

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.

Replace

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.

Round Numeric

Rounds off the input numeric value to the nearest whole number.  Non-numbers are truncated.

Script Operation

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. 

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

Sets the target_sys_rte_eb_field field value to the string provided in the set_value field.

Set Min/Max

Sets the target field to either the maximum or minimum of the values from all input fields.

Split

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.

Trim

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.

Uppercase

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.

Uppercase Trim

Combines both the Uppercase and the Trim transforms.