# Dataset null error in Perspective Table

**URL:** <https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 25, 2024, 2:33pm UTC](https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453 "2024-04-25T14:33:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 25, 2024, 2:33pm UTC](https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453/1 "2024-04-25T14:33:12Z")

</div>

After adding a fixed dataset to a table i getting an error because some values on selection.data.0 are null

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/0/507c95da7406ed6cf9a2c53353afdc41fc04ef48.png)

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [April 25, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453/2 "2024-04-25T14:35:06Z")

</div>

What is the error?

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 25, 2024, 2:38pm UTC](https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453/3 "2024-04-25T14:38:39Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/d/adb48244817af6c29b3507845caf1afd04d20590.png)

when i click on the error link me to the null value on selection.data.0

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 25, 2024, 2:42pm UTC](https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453/4 "2024-04-25T14:42:34Z")

</div>

Right-click on `selection.data.0` and copy.  
Go to [https://jsonlint.com/](https://jsonlint.com/) and paste it in and validate the JSON.  
I think you have characters in your column names which are not allowing in JSON keys.  
Ignition might be able to work with them.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 25, 2024, 3:12pm UTC](https://forum.inductiveautomation.com/t/dataset-null-error-in-perspective-table/89453/5 "2024-04-25T15:12:31Z")

</div>

This has nothing to do with your nulls.

Many of the object keys in your screenshot have spaces and special characters. Those are not allowed in JSON. They **are** allowed as column names in true datasets, so you will need to reconsider your dataset column names.

Keep in mind that your table does not have to use a dataset's column name as the column header. Supply a `columns` property with a header override as needed.