Change Field Values

Description: Replace the value in a field with another value. The new value may be a static value or one derived using a formula.
Available Filters: Event Filters:
- Event Type
- Event Field

Field Filters:
- Field Name
- Field Value
Settings: Enter the formula or (new) value for the field(s)
Transformation Considerations: None.

Sample Transformation

Scenario: In all the Events for which the value of the field, EmployeeID lies between 3 and 70, update the value of the Salaryfield to its existing value + 5000.

Filters:
Event Field = All Events (across all Event Types)
Field name = EmployeeID whose value is in the range (3,70)
Fields = All fields with name = Salary

Settings:
Enter formula or value = $self + 5000

Change Field Values settings

Result: In the sample Event below, the Employee ID is 4 and therefore, the value of the Salary field is updated from 65000 to 70000 when you test the Transformation:

Change Field Values settings


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-29-2022 NA Enhanced the content for clarity.
Nov-10-2022 NA Created as a new document.
Last updated on 29 Nov 2022

Tell us what went wrong