Azure Data factory convert string to decimal with precision shifting

SrinivasMurthy D 1 Reputation point

Hello All,

I am new to Azure Data factory. I am trying to convert a given string to decimal using the toDecimal().

There is column called xyz with values 253612375871010...1601...

now i have to use the above value as expression to another column.

the expression which i have tried is

and this is giving me the result

But now i want to shift the decimal places to 2 digits like 16.10.
I am not able to achieve the above result as i have tried all always.

Hoping for a response form anyone.


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
{count} votes