Derive Function | Vantage Analytics Library - Derive - Vantage Analytics Library

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage

Use the Derive transformation to enter the result of a column-based formula in a table. For example, if you know that all values in an input table column are nonnegative, you can use Derive to add one to each value in the column, take the natural logarithm of the resulting value, and enter the final result in an output table column.

The formula can include the following operators, arguments, and functions:

+, -, **, *, /, %, (, ), x, y, z, abs, exp, ln, log, sqrt

Each argument (x, y, and z) can assume only the value of an input table column.

Arguments must be numeric.

For more details, see formula in Syntax.