Change Field Values

Last updated on May 30, 2023
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:

  • Events = All Events having a field named EmployeeID and value in the range (3,70)

  • Fields = All fields with name = Salary

Settings:

  • Enter formula or (new) value = $self + 5000

Change Field Values settings

Result: In the sample Event below, the Employee ID is 4, which lies in the range (3, 70). 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.

Tell us what went wrong