Spotfire 7.6.0.45: Transforming Data - Change Data Types and Rounding

Hi All,

I inherited a DXP file that has multiple Data Tables generated from source queries utilizing OracleClient Data Provider to access the database.

Analyzing the query and the data transformation applied to the fields, I am not able to replicate the Round() function and rounding values up.

e.g. Below is a exerpt from the Data Tables source query and at the end it indicates in addition to changing the Data Type of the field to an Integer, it also applies a round function away from 0. 

What steps are required to reproduce the transformation?

2. For column: YR_PACKSTART
Changed data type to: Integer
Rounding method: Round (halves away from 0)
3. For column: WEIGHT
Changed data type to: Integer
Rounding method: Round (halves away from 0)

Thanks an advance.

(2) Answers

Login