TD_NORMALIZE_MEET Function | VantageCloud Lake - TD_NORMALIZE_MEET - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Combines the rows whose Period values meet so that the resulting normalized row contains the earliest beginning bound and the latest ending bound from the Period values of all the rows involved.

Result Type

This function returns result rows with the columns specified in the RETURNS clause as follows:
  • The grouping columns specified in the input argument.
  • The Period column with normalized Period values.
  • An optional INTEGER column containing the count of the rows that were normalized because their Period values meet.