Select rules or Select data sources are used to read or calculate values based on data sources which can then be mapped into workflow-level variables or customer list-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 or data source is executed.
- From Map and Calculate, do any of the following to create output parameters:
Option Action Identify a source column in the output table - Click in Select a field and select a source column.
- Select
to populate Output Parameter, Type, Length, and Precision based on the source column. - [Optional] Select
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, select the Fields, Functions, or Variables tabs and select options to create a formula.
- Select Save and Close.
- Select 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, select Variable.
- By Rule Variables or Data Source Variables, select
. - Complete variable information.
- Select Create Variable.
Edit a variable - Select > Formula.
- In the Formula Builder, select Variables.
- Hover over a Rule Variable or Data Source Variable, then select
> Edit - Update the variable information.
- Select Save Variable.
Delete a variable - Select > Formula.
- In the Formula Builder, select Variables.
- Hover over a Rule Variable or Data Source Variable, then select > Delete.
- Select Yes.
- Select
- Select Continue.