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

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Vantage Analytics Library
Release Number
2.2.0
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-07-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.