Optional Syntax Elements for TD_RowNormalizeFit - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798
OUT clause
Accept the OutputTable clause.
Approach
Specify the normalization method:
Option Description Normalizing Formula
UNITVECTOR (Default) Scales each row of the dataset to have a unit norm or magnitude of 1. X' = X / (sqrt (Σi ϵ [1, n] Xi2))
FRACTION Scales each row of the dataset to have a sum of 1. This function is useful when the values in each row represent fractions or probabilities and need to add up to 1. X' = X / (Σi ϵ [1, n] Xi)
PERCENTAGE Scales each row of the dataset to have a sum of 100. This function is useful when the values in each row represent percentages and need to add up to 100. X' = X*100 / (Σi ϵ [1, n] Xi)
INDEX Scales each row of the dataset to a specified range between V and B. 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.