[SOLVED] Is there a way to convert a dataset column type?

[witman]

Used DataSetBuilder to create a dataset with the right column types.

Vision: Convert dataset column type

Use Ignition’s DatasetBuilder. 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…

Then copy the rows from your dataset with the wrong types into the dataset with the correct column types.

Or it might be as easy to manipulate the CSV to specify the correct types before turning it into a dataset:

Convert columntype in table to integer

Use system.dataset.fromCSV to specify data types and column headers for your blank dataset like this: blankDataset = """#NAMES Header1, Header2, #TYPES d,I #ROWS,0""" See Ignition Manual for data types, etc.