Skip to main content

Creating and Editing a Set Value Transformation

A set value transformation sets a specific value in all rows of the output field.

Prerequisites

  • You must have Manage Data Mappings permission.
  • A syntactic mapping should have already been created.

Creating a Set Value Transformation

To create a Set Value transformation, complete the following steps.

Step 1: Open the Transformations Panel

  1. In the Syntactic Mappings page, choose the mapping you want to edit.
  2. Click the Edit Pencil in the Transformation field for the entry you would like to edit transformations for. 
  3. The Transformations Panel will appear. Click the Add Transformation button.
  4. Click the dropdown menu to select the desired transformation type.
TransformationDropDownMenu.png

 

Select the Set Value transformation  

setvalueblanktransformation.png

Step 2: Fill in the Transformation Configuration

  1. Note the Source Input and Target Output.  It should reflect what you already chose in the syntactic mapping entry.
  2. Enter the transformation output value as the value that you would like to be set in the output field for all output rows. It should be a number or string.
  3. When complete, click the Save button.

Ordering Transformations

When code runs, configured transformations are executed one after another.  If you want to change the order of transformation execution for specific syntactic mapping entries, complete the following steps.

  1. In the Syntactic Mapping page, choose the mapping you want to modify.
  2. Select the Edit Pencil in the Transformation field for the entry you want to edit. The Transformations  Panel will appear.
    threetransformations.png
  3. Click the transformation's handle (six domino-looking dots), and drag the transformation in the order you want it to run. Do this for each transformation that you want to reorder.threetransformations_handleshighlighted.png
  4. When done, click Save at the bottom of the page.

Editing a Transformation

To edit a transformation, complete the following steps.

  1. In the Syntactic Mappings page, select the mapping that you want to edit transformations for.
  2. Find the mapping entry you want to edit, then click the pencil icon in the Transformation column. The Transformations Panel will appear.
  3. Edit the transformation as desired.
  4. When complete, click the Save button.

Next Steps

Related Articles

Was this article helpful?