Azure Data factory convert string to decimal with precision shifting

SrinivasMurthy D 1 Reputation point
2021-06-28T13:36:24.897+00:00

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
toDecimal(substring('xyz',47,7),7,2,'#######.##00')

and this is giving me the result
1601.0

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.

Thanks

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