Azure Data factory convert string to decimal with precision shifting

SrinivasMurthy D 1

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

KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2021-06-28T23:10:31+00:00

Hi @SrinivasMurthy D ,

Welcome to Microsoft Q&A forum and thanks for your query.
To better assist on this, could you please share a complete sample of source column value and the desired output you are looking for?

We look forward to your details.

Thank you
KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2021-06-29T20:11:55.453+00:00

Hi @SrinivasMurthy D ,

Just checking to see if you have got a chance to see my previous comment. If so could you please share the requested info to better assist on this requirement.

Thanks
KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2021-07-01T06:34:34.777+00:00

Hi @SrinivasMurthy D ,

We still have not heard back from you. Just wanted to check if you still need assistance on this query? If so, could you please provide the details requested in my previous response.

Thank you

Your answer