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_GetRowsWithMissingValues InputTable: input_table
passenger survived pclass name gender age sibsp parch ticket fare cabin embarked --------- -------- ------ ------------------------------------ ------ ---- ----- ----- --------- ------ ----- -------- 1 0 3 Braund; Mr. Owen Harris male 22 1 0 A/5 21171 7.25 null S 30 0 3 Todoroff; Mr. Lalio male null 0 0 349216 7.8958 null S 505 1 1 Maioni; Miss. Roberta female 16 0 0 110152 86.5 B79 S 631 1 1 Barkworth; Mr. Algernon Henry Wilson male 80 0 0 27042 30 A23 S 873 0 1 Carlsson; Mr. Frans Olof male 33 0 0 695 5 B51 B53 B55 S
TD_GetRowsWithMissingValues SQL Call
SELECT * FROM TD_getRowsWithMissingValues ( ON input_table AS InputTable USING TargetColumns ('[name:cabin]') ) AS dt;
TD_GetRowsWithMissingValues Output
passenger survived pclass name gender age sibsp parch ticket fare cabin embarked --------- -------- ------ ----------------------- ------- ---- ----- ----- --------- ----- ----- ------- 1 0 3 Braund; Mr. Owen Harris male 22 1 0 A/5 21171 7.25 null S 30 0 3 Todoroff; Mr. Lalio male null 0 0 349216 7.8958 null S