TD_RowNormalizeFit Syntax Elements

TD_RowNormalizeFit Syntax Elements - Teradata® Database

Database Analytic Functions

Product

Teradata® Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-28

dita:mapPath

Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap

dita:ditavalPath

Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval

dita:id

B035-1206

lifecycle

Product Category

Teradata Vantage™

OutputTable

[Optional] Specify a name for the output table.

If you omit OutputTable, you must create the output table for TD_RowNormalizeTransform with a CREATE TABLE AS statement:

CREATE TABLE output_table AS (
  SELECT * FROM TD_RowNormalizeFit ( ... ) AS alias
) WITH DATA;

TargetColumns

Specify the names of the InputTable columns to normalize row-wise.

Approach

[Optional] Specify the normalization method:

Option	Normalizing Formula
UNITVECTOR (Default)	X' = X / (sqrt (Σ i ϵ [1, n] X i 2))
FRACTION	X' = X / (Σ i ϵ [1, n] X i )
PERCENTAGE	X' = X*100 / (Σ i ϵ [1, n] X i )
INDEX	X' = V + ((X - B) / B) * 100

In the normalizing formulas:

X' is the normalized value.
X is the original value.
B is the value in the base column.
V is the base value.

BaseColumn

[Required with Approach ('INDEX'), ignored otherwise.] Specify the name of the InputTable column that has the B values to use in the normalizing formula.

BaseValue

[Required with Approach ('INDEX'), ignored otherwise.] Specify the V value to use in the normalizing formula.