Prefix-Suffix transformation

A transformation type Prefix-Suffix will transform data from the incoming file by adding characters to the beginning (prefix) and/or to the end (suffix) of a string.

To configure a prefix-suffix transformation:

  1. Locate the data model attribute you want transformed and click its Transform link. The Transform dialog is displayed, and it shows the source fields (source) and schema attributes (target).
  2. An image of the Transform link

  3. Use the Transformation type list to select Prefix-Suffix.
  4. An image of the Transfomration type drop-down list

  5. Enter values in the Prefix and Suffix fields. You have the option of using both fields or only one of them.
  6. An image of the order of fields section

  7. Optionally, test the transformation by entering a value in the Sample input field. The transformed value will display in the Output field.
  8. An image of the delimiter field

  9. Click Apply.

Learn more

Creating ingest jobs

Concatenation transformation

Date transformation

Lookup/static transformation

URL transformation

Hash transformation

Replace transformation

Substring transformation

Trim transformation

Padding transformation

RegEx Advanced transformation

transform, transformation, prefix, prefix-suffix transformation, suffix, ingest job