# Error trying to coerce value with system.dataset.setValue

**URL:** <https://forum.inductiveautomation.com/t/error-trying-to-coerce-value-with-system-dataset-setvalue/56868>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [March 4, 2022, 10:14pm UTC](https://forum.inductiveautomation.com/t/error-trying-to-coerce-value-with-system-dataset-setvalue/56868 "2022-03-04T22:14:51Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [March 5, 2022, 3:14am UTC](https://forum.inductiveautomation.com/t/error-trying-to-coerce-value-with-system-dataset-setvalue/56868/4 "2022-03-05T03:14:36Z")

</div>

As @Transistor hinted at, the type of column nitro\_enable is numeric. So if you want to convert it you will need to either rebuild the dataset with the `system.dataset.*` functions, or the DatasetBuilder class.

For reference see:

> [@Vision: Convert dataset column type](https://forum.inductiveautomation.com/t/vision-convert-dataset-column-type/26341/2):
>
> Use Ignition’s [DatasetBuilder](http://files.inductiveautomation.com/sdk/javadoc/ignition79/795/com/inductiveautomation/ignition/common/util/DatasetBuilder.html). Something like this: from com.inductiveautomation.ignition.common.util import DatasetBuilder from java.lang import Integer, String, Object from java.awt import Color def forceTypes(sqlDS): builder = DatasetBuilder.newBuilder() builder.colNames(sqlDS.columnNames) originalTypes = list(sqlDS.columnTypes) i = #some column index for a color originalTypes[i] = Color builder.colTypes(originalTypes) for r in range(sqlDS.rowCount): bui…

---

_[View the full topic](https://forum.inductiveautomation.com/t/error-trying-to-coerce-value-with-system-dataset-setvalue/56868)._