formatting exponential

arkiboys 7,861 Reputation points
2022-06-28T10:43:57.19+00:00

Hello,
I am ingesting data into delta parquet using dataflow in data factory...
One of the columns, column1 sometimes has values such as:

Column1
--------
35. 5
1E-07
0. 9
...

Question:
Whilst ingesting, how can I convert the exponential to a number?

Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,305 questions
No comments
{count} votes

Accepted answer
  1. Olaf Helper 25,886 Reputation points
    2022-06-28T11:03:05.853+00:00

    how can I convert the exponential to a number?

    You get already numeric values (!!!), even if they look like in scientific format in your frontend (which ever you use); so what do you what to convert here?

    https://en.wikipedia.org/wiki/Scientific_notation


0 additional answers

Sort by: Most helpful