InputTable: titanic
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.
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
SQL Call
SELECT * FROM TD_FillRowID ( ON fillrowid_input AS InputTable USING RowIDColumnName ('PassengerId') ) AS dt;
Output
Survived Pclass Name Age PassengerId -------- ------ ------------------ --- ----------- 1 1 Mrs. John Bradley 38 0 0 3 Mr. Owen Harris 22 7 1 3 Mrs. Laina 26 8 0 3 Mrs. Jacques Heath 35 15