CODEWITHSUNDEEP
azureazure-data-lakeazure-data-factory
weehong ngeo
weehong ngeo

Reputation: 3

ADF DataFlow toFloat function

I have try to use ADF dataflow to convert a column with data like '630.180004119873' to float data type using toFlaot() function, however when output i can see the data been converted to '630.18'.

Is there anyone have idea how to prevent ADF DataFlow toFloat function to keep the result as '630.180004119873' instead of converted to '630.18'?

The code are as below: ADF Derived Column Settings

Upvotes: 0

Views: 1923

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

Actually, we can't use toFloat do the conversion. You could use toDouble or toDecimal: enter image description here

For example:

toDecimal: you can customize the precision and scale. enter image description here

toDouble: enter image description here

Hope this helps.

Upvotes: 2

Related Questions