Round numbers
Description
The Round Numbers activity modifies numeric values in selected columns by applying rounding techniques such as Round, Ceil, and Floor. It also allows control over decimal precision and whether to retain original columns in the output.
This is especially useful when preparing financial, statistical, or aggregated data for presentation, comparison, or export.
Use this activity to:
- Round off floating-point numbers to a fixed decimal scale
- Apply ceiling or floor operations to values (e.g., pricing, score normalization)
- Add transformed versions of numeric columns while keeping the original values intact
Use case: In a pricing dataset, discount percentages and price amounts may have several decimal places. This activity can round prices to 2 decimal points and discounts to whole numbers using the appropriate rounding method.
Input
| Type | Description |
|---|---|
| Data | Tabular data with numeric fields to be rounded. |
Output
| Output Type | Format | Description |
|---|---|---|
| Data | Table | The dataset with transformed (rounded) values. |
Configuration Fields
| Field Name | Description |
|---|---|
| Column Map | Define one or more column transformation rules. Each rule includes:
|
| Include Original | If enabled, the original columns are preserved alongside their rounded counterparts. If disabled, only rounded versions are kept. |
Sample Input
| ID | Price (Original) | Discount |
|---|---|---|
| 1 | 12.345 | 5.9 |
| 2 | 99.999 | 10.2 |
| 3 | 45.678 | 8.5 |
Sample Configuration
| Column Name | Rounding Method | Precision |
|---|---|---|
| Price (Original) | Round | 2 |
| Discount | Floor | 0 |
| Include Original | Enabled |
The
Price (Original)column is rounded to 2 decimals using standard rounding, whileDiscountis floored to the nearest integer.
Sample Output
| ID | Price | Discount |
|---|---|---|
| 1 | 12.35 | 5 |
| 2 | 100.00 | 10 |
| 3 | 45.68 | 8 |
Column names in the output may match the originals or appear as new columns based on your Include Original setting.