---
sourceDocument: Yokohama Data and Automation
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/integrate-applications

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Data and Automation

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Define Robust Transform Engine operations

# Define Robust Transform Engine operations {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

Define the operations the Robust Transform Engine (RTE) should perform.

## Before you begin

Role required: import_transformer

## About this task

You should always perform operations on only one entry. Select all source and target fields from the same entity.

## Procedure

1. Navigate to AllSystem Import SetsAdministrationETL Definitions.
2. Select an ETL definition.
3. On the ETL Entities tab, select an ETL entity.
4. On the RTE Entity Operations tab, click New.
5. Select the kind of operation you want to create.
6. Complete the form.  
   {#define-rte-operations__table_tr2_h4v_3jb__entry__2}

   | Field | Description |
   |-|-|
   | Name | Name of the operation. |
   | Source Field | Input ETL field for the operation if the operation takes a single input. |
   | Target Field | Output ETL field for the operation if the operation takes a single output. |
   | Source Fields | Input ETL fields for the operation if the operation takes multiple inputs. |
   | Target Fields | Output ETL fields for the operation if the operation takes multiple outputs. |
   | Operation Group | Optional name to group related operations. |
   | Overwrite Existing Value | If true, overwrites an existing non-empty value in the target fields. |
   | Optional Joining String | Optional string to join values on. |
   | Decimal Places | Optional number of decimal places to force output value to. |
   | Remainder Target Field | Optional second target field to write the trimmed remainder of the source string after the first numeric value is removed. |
   | Glide Matching Fields | Comma-delimited list of column names to use for lookup in the target table. |
   | Target Table | Table to perform a lookup on. |
   | Glide Target Fields | Comma-delimited list of columns to return from the target table. |
   | Match Regular Expression | Matching regular expression for replace operations. |
   | Replacement Regular Expression | Replacement string. |
   | Use Unique Input Sets | If true, the operation processes only the unique set of inputs to the operation. Otherwise, the operation processes every record individually. |
   | Literal Set Value | String value to set to target. |
   | Splitting String | String to split the input value on. |
   | Date Format | Date/time format expressed in simple Java format. |
   | Order | Order in which the operation runs on the entity. |
   | Script | Script that runs as part of the operation. |
   | Is Conditional | Specifies whether to apply the operation if the specified conditions are met. |
   | Conditional Fields | Fields to use in the condition. |
   | Conditional Script | Condition specified as a string. For an example of a conditional script, see [Temporary entity model](https://www.servicenow.com/docs/zCj4mD4ZYqrlpPsxDMZkNQ "Use temporary ETL entities to avoid repetitive operations in target entities."). |
   | Application | Application scope for this record. |
   | Operation Type | Operation type for this operation. |
   | Entity | Entity this operation applies to. |
   | Definition | Selected ETL entity definition that this entity and operation belong to. |
   [ ]

   {#define-rte-operations__table_tr2_h4v_3jb}
7. Click Submit.

*[\>]: and then