Modifying a sql query dataset

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?

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.

1 Like

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