Numerical Formatting

Description

This transformation is used to format numerical values in a dataset based on a selected format pattern.

Input

Data

Output

Transformed Data

---

Configuration Fields

• Column Map Specifies the name of the column to transform and the format to apply.

  • Column Name Select columns from the previous activity containing numerical values.
  • Format Select a formatting style from the following options
    • Auto
    • ####
    • ##,##
    • ##,##,##
    • ##,##,##
    • Percentage (%)
    • None (No formatting)

• Include Original (Switch)

  • If enabled, retains the original columns in addition to the transformed columns.

Sample Input

Product	Sales	Profit
A	500000	0.15
B	120000	0.20
C	950000	0.05
D	45000	0.12

Sample Configuration

Sample Output

Product	Sales	Profit
A	500,000	15%
B	120,000	20%
C	950,000	5%
D	45,000	12%