Add transformations to use for various number formatting options
It would be very helpful to have number transformations available for number to currency, options for decimals or not, options for currency symbol, adding commas, etc. I have a rating file from a vendor with the value amount showing as 56740 as an example. This is difficult to read so I would like to transform it to $56,740. Currently my only option is to use a formula in the source file in excel to convert it from the number to text in the $#,##0 format. I have to manually do this for 10+ columns every time I get a new import file.
3
votes