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 All > System Import Sets > Administration > ETL 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.
    FieldDescription
    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.
    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.
  7. Click Submit.