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:

• 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

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.