Select rules are used to read or calculate values based on data sources which can then be mapped into workflow-level variables. Since a variable can only contain a single value, note that only the first row of the underlying query will be returned to the output parameters when the rule is executed.
-
From Map and Calculate, do any of the following to create output parameters:
Option Steps Identify a source column in the output table - Click in Select a field and select a source column.
- Click
to populate Output Parameter, Type, Length, and Precision based on the source column. - [Optional] Click
to add more source columns to the table.To use a source column more than one time in an output table, map the second use of the source column as a formula and give it a unique alias.
Identify or create a formula to populate the output table - Select
> Formula. - Enter a Formula Name.
- Select a Type.
- In the Formula Builder, click the FIELDS, FUNCTIONS, or VARIABLES tabs and select options to create a formula.
- Click SAVE AND CLOSE.
- Click to populate Output Parameter, Type, Length, and Precision based on the formula information.
-
[Optional] Include a variable in a column:
Option Action Create a variable - Select
> Formula.
- In the Formula Builder, click VARIABLES.
- By Rule Variables, click
. - Complete variable information.
- Click CREATE VARIABLE.
Edit a variable - Select
> Formula.
- In the Formula Builder, click VARIABLES.
- Hover over a Rule Variable, then select
> Edit. - Update the variable information.
- Click SAVE VARIABLE.
Delete a variable - Select
> Formula.
- In the Formula Builder, click VARIABLES.
- Hover over a Rule Variable, then select
> Delete.
- Click Yes.
- Select
- Click CONTINUE.