TD_GetRowsWithoutMissingValues Example | Teradata Vantage - Example: How to Use TD_GetRowsWithoutMissingValues - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-01-20
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
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_GetRowsWithoutMissingValues 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

Example: TD_GetRowsWithoutMissingValues SQL Call

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

TD_GetRowsWithoutMissingValues Output Table

passenger survived pclass name                                 gender  age sibsp parch ticket fare    cabin       embarked
--------- -------- ------ ----                                 ------  --- ----- ----- ------ ----    -----       --------
      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