As the number formats used across the world are not the same, you may need to
change the format used in a column containing numbers.
Procedure
-
Select the column for which you want to change the number format.
-
In the Functions panel,
type Format Number and click the result to
open the options for the associated function.
-
In the Current separators list, select the number format
used in the selected column. You can:
- Use a predefined separator.
- Define it yourself with custom.
- Let Talend Data Preparation automatically guess the format.
-
In the Target Format list, choose the number format you
want to use in the selected column.
-
Click Submit.
You have the possibility to output the result of this function in a new
column by selecting the Create new column check
box.
Results
The number format is changed in the selected column.