Applying Column Values - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
When one or more values selected from the Values display are dropped or otherwise selected on top of an existing element in the tree, then numeric, string or date literals are created as appropriate for each column value and one of the following menus is displayed. The same will occur if a value or values are dropped into a text box on the Properties dialog box for string or text literals or parameters.
  • Single value applied to a Text/String Literal or Parameter without an existing value
    • Set text equal to value
    • Replace this SQL element
  • Single value applied to a Text/String Literal or Parameter with an existing value
    • Replace text with value
    • Add value to list
    • Replace this SQL element
  • Multiple Values applied to a folder (such as under an IN/NOT IN operator)
    • Add one Literal element per value
    • Add one Literal Parameter per value
    • Add Text Literal with a list of all values
    • Add Text Parameter with a list of all values
  • Multiple values applied to a Text/String Literal or Parameter without an existing value
    • Set text equal to list of values
  • Multiple values applied to a Text/String Literal or Parameter with an existing value
    • Replace text with list of values
    • Append list of values to text
  • Multiple values applied to another element (other than String, Text or folder)

    To use this option instead of setting or replacing text with a list of values, drop values on an empty element.

    • Replicate Variable for each value

The final option for replicating variables has already been described in Replicating a Variable.