TD_FillRowID Example | FillRowID | Teradata Vantage - Example: Using TD_FillRowID to Generate Row Identifiers - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
lifecycle
latest
Product Category
Teradata Vantageā„¢

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file from the attachment in the left sidebar.

TD_FillRowID InputTable: fillrowid_input

 Survived Pclass Name               Age 
 -------- ------ ------------------ --- 
        0      3 Mrs. Jacques Heath  35
        0      3 Mr. Owen Harris     22
        1      3 Mrs. Laina          26
        1      1 Mrs. John Bradley   38

TD_FillRowID SQL Call

SELECT * FROM TD_FillRowID (
  ON fillrowid_input AS InputTable
  PARTITION BY Pclass
  ORDER BY Age
  USING
  RowIDColumnName ('PassengerId')
) AS dt;

TD_FillRowID Output

The output shows the generated IDs in the PassengerId column.

Survived  Pclass   Name            Age  PassengerId 
   -------- ------ ------------------ ---  ----------- 
        1      1   Mrs. John Bradley   38           4
        0      3   Mr. Owen Harris     22           4
        1      3   Mrs. Laina          26           8
        0      3   Mrs. Jacques Heath  35          12