Add All - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

A variation of the standard Add operator is supported for adding two or more numeric expressions together, generating the SQL: expression1 + expression2 +…+ expressionN. Character expressions are automatically converted, if possible, to numbers before adding. The resulting numeric type depends on the type of the expressions. For information on binary arithmetic result data types, see Teradata® Database SQL Functions, Operators, Expressions, and Predicates, B035-1145.

When dragging an Add All operator into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Arithmetic > Add All

Columns and/or other expressions can be moved into the (empty) branches of the tree, where the first argument is to the left of the plus operator, the second to the right, and so forth. In the example below, numbers 1, 2 and 3 are added together to yield the SQL 1+2+3, which displays as 6.

Variable Creation > Input > Variables: SQL Elements pane - Arithmetic > Add All (Expressions)

There are no special properties for the Add All operator.