Expand Column Reference (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This function is only available when connected to a Teradata database.

An Expand Column Reference can be used to reference the alias of an Expand On expansion period, as described in Variable Creation - INPUT - Expert Options - SQL Elements. An Expand Column Reference can be used in the definition of a Variable or in an ORDER BY expert clause, but not in a Dimension, join clause search condition, subquery or expert clause other than ORDER BY. It may also not appear in an Aggregate or Ordered Analytical function.

There are no special properties for the Expand Column Reference SQL element. It is not necessary for the user to provide the value of the Expand Column Alias here; it is taken automatically from the Expand On expert clause (which must, however, exist if an Expand Column Reference is used).