Spotfire 220.127.116.11: Transforming Data - Change Data Types and Rounding
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.