Round Numbers
Description
This activity rounds the numerical values in the specified columns using different rounding methods such as Round, Ceil, and Floor. It also allows setting precision for rounding and choosing whether to keep the original values.
Input
Data only
Output
Transformed Data
Configuration Fields
- ColumnMap Defines the set of columns and actions whose values should be rounded.
- Column Name Name of the column to be rounded. Rounding Method The rounding method for the column (Round,CeilFloor).
- Precision The number of decimal places to round to.
- Include Original Whether to keep the original columns along with the transformed ones.
Sample Input
| ID | Price (Original) | Discount |
|---|---|---|
| 1 | 12.345 | 5.9 |
| 2 | 99.999 | 10.2 |
| 3 | 45.678 | 8.5 |
Sample Configuration
Sample Output
| ID | Price | Discount |
|---|---|---|
| 1 | 12.35 | 5 |
| 2 | 100.00 | 10 |
| 3 | 45.68 | 8 |