QQ - How do I map NA and other null strings to NULL?
  • 1 Minute to read
  • Dark
    Light
  • PDF

QQ - How do I map NA and other null strings to NULL?

  • Dark
    Light
  • PDF

Article summary

This article will look at 2 scenarios:

  1. Unloaded Data
  2. Numeric Data loaded as String because of Null values

Unloaded Data

Where data has not yet been loaded, or where the data can be reloaded easily enough, the simplest action is to change the field definition from String to Integer.  Any non-integer data will be discarded by the loader, which will result in NA records being loaded as NULL.

Change From String:

  "definition": [   
    "ind_nuevo|DISCRETE|STRING|BYTE"
  ],
  "loading": [    
    "ind_nuevo"   
  ],

To Integer:

  "definition": [   
    "ind_nuevo|DISCRETE|INTEGER|BYTE"
  ],
  "loading": [    
    "ind_nuevo"   
  ],


Numeric Data Loaded as string

If Data has already been loaded, and it is not possible or desirable to change the load definition, use the Engineering | Functions | String | ICast or Engineering | Functions | String | DCast function to cast the field as a numeric:



Was this article helpful?