Return a value that you enter
Configure an action to return a data value that you specify.
For example, you might configure an action to return the word VALID when the input data matches a dictionary value.
Return a value from an input column
Configure an action to return a data value from an input in the rule specification. The action reads the data value on the corresponding row of the input that you select.
For example, a business might define a rule that requires all product records to use Quick Response (QR) codes in place of bar codes. You configure an action to replace an input column of bar code values with a corresponding column of QR code values.
Return a value from a dictionary
Configure an action to return a data value from a dictionary. The action compares the input data to the values in the dictionary that you specify. If the action finds the input data in the dictionary, the action returns the dictionary value that corresponds to the input data.
For example, you might configure an action to compare first name data to a dictionary that identifies the gender of the first name. The action might read the word "JOHN" from the input data and return the word "MALE" from the dictionary.
Return a value that you enter when an input data value matches a dictionary value
Configure an action to return a data value from a dictionary. The action compares the input data to the values in the dictionary that you specify. If the action finds the input data in the dictionary, the action returns the string that you entered. if the action does not find the input data in the dictionary, the action returns the input value.
For example, you might configure an action to compare employee code data to a dictionary that contains the valid employee codes in an organization. You define a function that returns the word "VALID" when an employee code matches a value in the dictionary. If the function does not find an employee code in the dictionary, the action returns the employee code from the input column.
Return the current date and time
Configure an action to return the current date and time. The rule statement returns the date and time values in a date/time data type.
Remove data values from the input data
Configure an action to remove a data value that you specify.
For example, the input data might include a product name that the business no longer uses. Configure the action to return a version of the input data that omits the product name.
Remove dictionary values from the data
Configure an action to remove dictionary values from an input.
The action compares the input data to the values in a dictionary that you specify. If the action finds an input data value in the dictionary, the action returns a version of the input without the data value.
For example, you might configure an action to compare an input string to a dictionary of salutation terms. The action might read the input string "MR JOHN SMITH" and return the string "JOHN SMITH" as the output.
Remove character spaces from the input data
Configure an action to delete character spaces from the input data. Remove character spaces when the input data includes redundant character spaces.
For example, you might configure an action to remove character spaces from the following telephone number:
Use a function expression to determine the output value
Configure an action to apply a function expression to the input data.
For example, you might configure the action to return the character length of the input data.
Use a custom expression to determine the output value
Configure an action to apply an expression that you define to the input data.
For example, you might configure the action to concatenate two input data values.
Merge values from multiple inputs
Configure an action to merge data from two or more inputs.
For example, you might configure an action to merge a column of first name data and a column of second name data. The action returns a single field that contains the first name and second name.
Change the character case of the input data
Configure an action to convert the character case of an input that you select.
For example, a rule statement might read a data set that stores data values in sentence case. Configure an action to return the data in uppercase.
Return an output form a rule specification
Configure an action to run a rule specification on one or more inputs that you specify. Select at least one input on the rule specification, or enter a value as a rule specification input. You can select any input available to the current rule specification as an input. You also select the field that the action reads as the output of the rule specification.
Return an output from a mapplet
Configure an action to run a mapplet on one or more inputs that you select. Select at least one input on the mapplet, or enter a value as a mapplet input. You can select any input available to the current rule specification as an input. You also select the field that the action reads as the mapplet output.
A rule specification can read mapplets that contain passive transformations.
Generate a status value
Configure an action to generate a predefined status value when the input data satisfies the condition on the rule statement.
You can configure an action to return the status values
Valid
and
Invalid
. If you select
Invalid
as the status value, you can add data to the record to explain the status and to identify the priority of the issue that the value represents.