Variables in Workflows | Vantage Analyst - Variables in Workflows - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst User Guide

Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.4.1
Published
May 2022
Language
English (United States)
Last Update
2022-05-09
dita:mapPath
ufz1626905554941.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
Product Category
Teradata Applications

You can use the following variable types in Workflows.

Variable Type Where Created Where Used
Global Global variables
  • Rules
  • Workflows
Rule Map and Calculate step in Rules
  • Rules
  • Workflows
System-defined (Workflow) N/A: Listed in the Formula Builder (Map and Calculate step in Rules) Rules
Variable Names
  • Do not include spaces in variable names. Alternatively, you can use underscore character.
  • Rule variables and workflow-level variables can have the same name.
  • Global variable names must be unique.
  • The following reserved words cannot be used as variable names:
    • activateType
    • callback
    • currentUser
    • execution_credentials
    • executionResumable
    • integrationId
    • last_data
    • last_enddate
    • last_errorcode
    • last_exception
    • last_rowcount
    • last_status
    • last_startdate
    • lastTaskId
    • results
    • resume_seq_num
    • resumes
    • rootWorkflowId
    • rootWorkflowName
    • runId
    • subRunId
    • taskId
    • taskName
    • validate
    • workflowExecutionType
    • workflowId
    • workflowName
  • The following reserved words cannot be appended to variable names:
    • _results
    • _resumes
    • _resume_subworkflow_processes
    • _rootworkflow_resume
    • _checkpoint
    • _calling_task_id
  • The following reserved words cannot be prepended to variable names:
    • lastTaskId_

The reserved words are not case-sensitive.

Global Variables
  • Global variables are system-wide variables that have their values populated during workflow execution and relate to the state of that workflow or customer list and its tasks. You cannot override the values.
Rule or Data Source Variables
  • Rule variables are added to a rule or data source at the Map and Calculate step (see Mappings and Calculations). Use the Formula Builder to create rule variables. You can add variables after a rule is created by accessing the Rule summary page (select a rule for editing).
System-Defined Variables
  • System-level variables are predefined and give users access to Workflows information such as workflow ID. They can also be used in the Notify node and as assignments to other variables in the workflow.
Workflow-Level Variables
Add workflow- or customer list-level variables to allow the system to read values from data sources (using Select rules, Select data sources, or output parameters in a stored procedure). You can use these variables for a number of purposes, for example:
  • Direct workflowpaths using conditional expressions
  • Pass to variables in sub-workflows and rules
  • Pass as input parameters to Stored Procedure and Macro nodes
  • Use in calculations in Variable nodes