---
title: "QQ - How do I map NA and other null strings to NULL?"
slug: "qq-how-do-i-map-na-and-other-null-strings-to-null"
updated: 2022-11-28T11:13:36Z
published: 2022-11-28T11:13:36Z
canonical: "docs.datajet.app/qq-how-do-i-map-na-and-other-null-strings-to-null"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

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

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:

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

To Integer:

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

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1669627819735.png)

### 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: