# \[IGN-2200\]Replace values displayed as "null" in the perspective table

**URL:** <https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161>\
**Category:** Ignition\
**Tags:** ignition80, perspective\
**Created:** [April 1, 2021, 9:27am UTC](https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161 "2021-04-01T09:27:28Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [April 1, 2021, 4:10pm UTC](https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161/2 "2021-04-01T16:10:29Z")

</div>

If those columns are supposed to be numbers, a script transform like this to set the correct column types should work:

> [@\[BUG\] Perspective Table number format breaks if first row has null value](http://forum.inductiveautomation.com/t/bug-perspective-table-number-format-breaks-if-first-row-has-null-value/44897/9):
>
> Hopefully the underlying Perspective Table implementation will handle this in the future for columns with specified types. For now, this script transform does the trick: from java.lang import Float from com.inductiveautomation.ignition.common.util import DatasetBuilder if value is None: return value else: # Build new dataset with specified column types. colNames = ["Month 1", "Month 2", "Month 3"] colTypes = [Float, Float, Float] b = DatasetBuilder.newBuilder().colNames(colNames…

If they are strings, you could do a script transform that replaces the `null` with `""`.

---

_[View the full topic](https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161)._