transformationRule - APEXlang Reference

`transformationRule`

Parent: legacyDataLoadDefinition

Applies whenskipValidation = false

Direct Properties:

Property	Type	Required	Default Value	Details
`name`	`string`	Yes		data type=`string`; maxLen=255

Property Groups:

execution

Property	Type	Required	Default Value	Details
`sequence`	`number`	Yes		data type=`number`; maxLen=22 Specify the sequence for the transformation rule. The sequence determines the order of evaluation.

execution {
  sequence: 42
}

transformation

Property	Type	Required	Default Value	Details
`columnNames`	`array of strings`	Yes		data type=`string`; maxLen=32767
`type`	`enum`	Yes		data type=`string`; lov=`STATIC` Valid values: `upperCase` `lowerCase` `replace` `trim` `leftTrim` `rightTrim` `singleWhitespace` `plsqlExpression` `plsqlFunctionBody` `sqlQuerySingleValue` `sqlQueryMultipleValues`
`trim`	`enum`	Yes	`both`	data type=`string`; lov=`STATIC` Valid values: `trailing` `leading` `both` Applies when`type = trim`
`find`	`string`	Yes		data type=`string`; maxLen=4000 Applies when`type = replace` Specify the string that should be found in the column value.
`replaceWith`	`string`	No		data type=`string`; maxLen=4000 Applies when`type = replace` Specify the string that should replace the string found in the column value.
`plsqlExpression`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = plsqlExpression`
`sqlQuery`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type in (sqlQuerySingleValue)type in (sqlQueryMultipleValues)`
`plsqlFunctionBody`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = plsqlFunctionBody`
`trimChars`	`string`	No		data type=`string`; maxLen=4000 Applies when`type in (leftTrim)type in (rightTrim)type in (trim)`

transformation {
  columnNames: [
    value
    value
  ]
  type: upperCase
  trim: trailing
  find: value
  replaceWith: value
  plsqlExpression: ```plsql
    value
  ```
  sqlQuery: ```sql
    value
  ```
  plsqlFunctionBody: ```plsql
    value
  ```
  trimChars: value
}

error

Property	Type	Required	Default Value	Details
`errorMessage`	`multiline string`	No		data type=`multiline string`; maxLen=4000 Enter the text to be displayed if the transformation rule fails.

error {
  errorMessage: ```
    value
  ```
}

advanced

Property	Type	Required	Default Value	Details
`staticId`	`string`	Yes		data type=`string`; maxLen=255 Static ID for this search configuration. The static ID is used when using the search configuration in a programmatic context, with the APEX_SEARCH package.

advanced {
  staticId: value
}

APEXlang Example

transformationRule sample (
    name: value
    execution {
        sequence: 42
    }
    transformation {
        columnNames: [
          value
          value
        ]
        type: upperCase
        trim: trailing
        find: value
        replaceWith: value
        plsqlExpression: ```plsql
          value
        ```
        sqlQuery: ```sql
          value
        ```
        plsqlFunctionBody: ```plsql
          value
        ```
        trimChars: value
    }
    error {
        errorMessage: ```
          value
        ```
    }
    advanced {
        staticId: value
    }
)