1.1 - Creating or Editing Output Parameters for a Select Rule - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst with Machine Learning Engine User Guide

Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.1
Published
December 2019
Language
English (United States)
Last Update
2020-08-06
dita:mapPath
ezh1551894635141.ditamap
dita:ditavalPath
wsp1565965728073.ditaval

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.