QQ - How do I map NA and other null strings to NULL?
- 1 Minute to read
- Print
- DarkLight
- PDF
QQ - How do I map NA and other null strings to NULL?
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
This article will look at 2 scenarios:
- Unloaded Data
- 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?