# Vision: Convert dataset column type

**URL:** <https://forum.inductiveautomation.com/t/vision-convert-dataset-column-type/26341>\
**Category:** Ignition\
**Created:** [July 8, 2019, 7:32am UTC](https://forum.inductiveautomation.com/t/vision-convert-dataset-column-type/26341 "2019-07-08T07:32:06Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [July 8, 2019, 11:45am UTC](https://forum.inductiveautomation.com/t/vision-convert-dataset-column-type/26341/2 "2019-07-08T11:45:35Z")

</div>

Use Ignition’s [DatasetBuilder](http://files.inductiveautomation.com/sdk/javadoc/ignition79/795/com/inductiveautomation/ignition/common/util/DatasetBuilder.html). Something like this:

```auto
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):
        builder.addRow([sqlDS.getValueAt(r, c) for c in range(sqlDS.columnCount)])
    return builder.build()

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/vision-convert-dataset-column-type/26341)._