TD_GetRowsWithMissingValues Function Example | Teradata Vantage - Example: Using TD_GetRowsWithMissingValues to Find NULL Values - 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_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