Edit Data Transformations

Prev Next

Available Transformations Types

Transformation Type

Description

None

No transformation is applied.

To upper case

Converts the source value to upper case.

To lower case

Converts the source value to lowercase.

Math floor

Rounds the source value down to the nearest integer.

Timestamp

Converts the source value from a timestamp to a date and time string in the format “YYYY-MM-DD HH:mm” (UTC).

Remove character(s)

Removes all instances of the specified character(s) from the source value.

Custom

Executes a custom JavaScript function provided by you.

Procedure

  1. Go to Data Management > Mapp Connect and open the integration you want to edit.

  2. Open the Mapping tab and click Edit next to the mapping you need to change.

  3. Click Edit Field Mapping.

  4. Go to the item you want to edit. Click the three dots menu under Actions and click Edit.

  5. Adjust the mapping information as needed.

    1. Selecting Remove character(s) opens a field where you can specify the character or string you want removed.

    2. Selecting Custom opens a field where you can enter the JavaScript, and a button to test it.

  6. Click Save.