Create/Edit Output Parameters for Select Rule | Vantage Analyst - 1.1 - Creating or Editing Output Parameters for a Select Rule - Vantage Analyst

Vantage Analyst User Guide

prodname
Teradata Analytic Apps
Vantage Analyst
vrm_release
1.1
category
User Guide
featnum
B035-3805-099K

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.

  1. From Map and Calculate, do any of the following to create output parameters:
    Option Steps
    Identify a source column in the output table
    1. Click in Select a field and select a source column.
    2. Click "" to populate Output Parameter, Type, Length, and Precision based on the source column.
    3. [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
    1. Select "" > Formula.
    2. Enter a Formula Name.
    3. Select a Type.
    4. In the Formula Builder, click the FIELDS, FUNCTIONS, or VARIABLES tabs and select options to create a formula.
    5. Click SAVE AND CLOSE.
    6. Click "" to populate Output Parameter, Type, Length, and Precision based on the formula information.
  2. [Optional] Include a variable in a column:
    Option Action
    Create a variable
    1. Select "" > Formula.
    2. In the Formula Builder, click VARIABLES.
    3. By Rule Variables, click "" .
    4. Complete variable information.
    5. Click CREATE VARIABLE.
    Edit a variable
    1. Select "" > Formula.
    2. In the Formula Builder, click VARIABLES.
    3. Hover over a Rule Variable, then select "" > Edit.
    4. Update the variable information.
    5. Click SAVE VARIABLE.
    Delete a variable
    1. Select "" > Formula.
    2. In the Formula Builder, click VARIABLES.
    3. Hover over a Rule Variable, then select "" > Delete.
    4. Click Yes.
  3. Click CONTINUE.