Data Import

Data imported from SQL database tables can contain NULL values. Rax replaces these values with missing values. The import statement in the example below will replace each NULL value with missing values appropriate for each tuple field type.

    {[#:id, #:channel, |:viewing]}: viewData :=
      import [(#)"RESP_ID", (#)"CHANNEL", (|)[(@)"BEGIN", (@)"END"]]
        "viewingsdb.T_VIEWING_DATA";
         

Data in an XML or CSV file does not contain NULL values and, therefore, do not need such special processing.