TD_GetRowsWithMissingValues Function Example | Teradata Vantage - TD_GetRowsWithMissingValues Example - Teradata® Database

InputTable: input_table

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.

passenger survived pclass name                                 sex    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       

    

SQL Call

SELECT * FROM TD_getRowsWithMissingValues (
  ON input_table AS InputTable
  USING
  TargetColumns ('[name:cabin]')
) AS dt;

Output

passenger survived pclass name                    sex  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