SmallFry
Reputation: 153
Convert Scientific Notation to decimal in Azure Data Flows
I have an input file that has a column with mixture of decimal and scientific notation values. I have tried to convert the column using toDecimal, which seems to work for the non-zero decimals and the scientific notation values, but zeroes are converted to scientific notation. Is it possible to keep the zero values as plain zeroes?
Upvotes: 0
Views: 1153
Answers (1)
NiharikaMoola
Reputation: 5074
Looks like by default 0/0.0 is converted to exponential value when using the decimal function. One way is to convert decimal to string.
case(Value == 0.0, toString(0.0),toString(toDecimal(Value,20,10)))
Upvotes: 1
Related Questions
- Azure Data Factory: Reading doubles with a comma as decimal separator instead of a dot
- mapping data flow column pattern type =='decimal' not changing decimal columns
- data factory dataflow - convert exponential to decimal
- Azure Data Factory Expression Data Type Conversion Error
- Converting string to date , datetime or Int in Mapping dataflow
- Azure Data Factory - Executing Mathematical Operation from column value
- Truncate (NOT ROUND) decimal numbers in Azure Data Factory Mapping Data Flow
- how to convert currency to decimal in Azure Data Factory's copy data activity mapping
- Azure LogicApps: Conversion from String to Float returns zero
- Parquet troubles with decimal in Azure Data Factory V2