Modifying a sql query dataset

[Eric_Ervin]

Im returning a dataset to an xy chart with a sql query binding.

Im wanting to modify the incoming data for formatting. The first column is return a value of volt amps. Id like to divide the value by 1000 to return kva value. Also Id like to use the round function to keep it from 8 decimal places.

Is it possible to do this on a per column basis?

[paul-griffith]

Can I modify an entire column from a dataset with system.dataset.setValue()?

def mapColumn(function, dataset, column): if isinstance(column, basestring): column = dataset.getColumnIndex(column) columnData = map(function, dataset.getColumnAsList(column)) columnsToKeep = range(dataset.columnCount) columnsToKeep.pop(column) dsWithoutColumn = system.dataset.filterColumns(dataset, columnsToKeep) return system.dataset.addColumn( dsWithoutColumn, column, columnData, dataset.getColumnName(column), dataset.getColumnType(column) ) It's relatively easy to…

You can drop something like this in your project library, to call a transformation function on an entire column of a dataset as one operation.

Phil's Integration Toolkit module also probably has some neat capabilities here.

[Eric_Ervin]

Appreciate this, can you give an example or point me in the direction of applying this function to a query binding?