# Extract Field transform displays "null"

**URL:** <https://community.grafana.com/t/extract-field-transform-displays-null/108902>\
**Category:** Table Panel\
**Created:** [November 29, 2023, 3:47pm UTC](https://community.grafana.com/t/extract-field-transform-displays-null/108902 "2023-11-29T15:47:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pgiraud](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/pgiraud/32/40119_2.png) [@pgiraud](https://community.grafana.com/u/pgiraud)\
**Post date:** [November 29, 2023, 3:47pm UTC](https://community.grafana.com/t/extract-field-transform-displays-null/108902/1 "2023-11-29T15:47:17Z")

</div>

- What Grafana version and what operating system are you using?

v10.1.0

- **What** are you trying to achieve?

[https://play.grafana.org/d/aac76d76-3493-4f71-99ea-bfd09959b753/extract-field-transform-null-values-issue?orgId=1](https://play.grafana.org/d/aac76d76-3493-4f71-99ea-bfd09959b753/extract-field-transform-null-values-issue?orgId=1)

I’m using the following data :

```auto
{"foo": "dude"}
{"bar": 125, "dude": null}

```

And using the Transform Data / Extract Field feature.

- What happened?

Some cells not containing data are empty. Some display a “null” string.

![Screenshot from 2023-11-29 16-46-51](https://us1.discourse-cdn.com/grafana/original/3X/f/9/f90eeed75540659f67fe8367766ee1d10c08caeb.png)

- What did you **expect** to happen?

I expect the cells not containing data to be empty. (or all of them to contain “null”).

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [November 29, 2023, 7:01pm UTC](https://community.grafana.com/t/extract-field-transform-displays-null/108902/2 "2023-11-29T19:01:01Z")

</div>

What is the data source for this data

---

<div class="post-metadata">

**Author:** ![pgiraud](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/pgiraud/32/40119_2.png) [@pgiraud](https://community.grafana.com/u/pgiraud)\
**Post date:** [November 29, 2023, 7:24pm UTC](https://community.grafana.com/t/extract-field-transform-displays-null/108902/3 "2023-11-29T19:24:37Z")

</div>

The data source doesn’t seem to be important. I tried first with a SQL query (PostgreSQL backend), but in the sandbox the data is Static.

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [November 29, 2023, 7:38pm UTC](https://community.grafana.com/t/extract-field-transform-displays-null/108902/4 "2023-11-29T19:38:17Z")

</div>

Actually it is important as you could leverage functions in the querying language of the data source. here is an example in MS SQL

![image](https://us1.discourse-cdn.com/grafana/original/3X/1/9/19cdc4b3e3c4300473c50e438d542f526ca87757.png)

or

```auto
;with src
as
(
select '{"foo": "dude"}' as zaza union
select '{"bar": 125, "dude": null}'
)

SELECT *
from src
cross apply OPENJSON(src.zaza) WITH (
    foo NVARCHAR(50) '$.foo',
	bar INT '$.bar',
    dude NVARCHAR(50) '$.dude'
    );

```
