NUMBER_FORMAT
Returns a column in which a numeric value is converted into a formatted string.
Parameters
-
sourceColumn
– String. The name of an existing column. -
decimalPlaces
– Integer. The value of number of digits after the decimal separator. -
numericDecimalSeparator
– String. One of the following values indicating the decimal separator:-
"."
-
","
-
-
numericThousandSeparator
– String. One of the following values indicating the thousand separator:-
null. Indicates that a thousand separator isn't enabled.
-
","
-
" "
-
"."
-
"\\"
-
-
numericAbbreviatedUnit
– String. One of the following values indicating the abbreviation unit:-
null. Indicates that an abbreviation unit isn't enabled.
-
“THOUSAND”
-
"MILLION"
-
"BILLION"
-
"TRILLION"
-
-
numericUnitAbbreviation
– String. One of the following values or any custom value, indicating unit abbreviation:-
null. Indicates that unit abbreviation isn't enabled.
-
Abbreviation unit Options Thousands
K, k, M, thousand, custom
Million
M, m, MM, million, custom
Billion
B, bn, billion, custom
Trillion
T, tn, trillion, custom
-
Example
{ "RecipeAction": { "Operation": "NUMBER_FORMAT", "Parameters": { "sourceColumn": "income", "decimalPlaces": "2", "numericDecimalSeparator": ".", "numericThousandSeparator": ",", "numericAbbreviatedUnit": "THOUSAND", "numericUnitAbbreviation": "K" } } }