question

KunalBhatia-2218 avatar image
1 Vote"
KunalBhatia-2218 asked KunalBhatia-2218 commented

Expression Required for Replacing the Value (DerivedColumn) ADF

What Expression should I use to Replace the Value From 0.00000000 to 1.00000000

In Derived Column - I tried using this Expression , but it gives me NULL result in Preview Output.

This Expression --> case(LocalToBaseRate == 0.00000000,'1')

Column Name = LocalToBaseRate
Value I want to Replace whereever it finds "0.00000000" , it should replace to "1.00000000"

197436-image.png


Please suggest the expression for Derived column .

Thanks


azure-data-factory
image.png (36.6 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

nasreen-akter avatar image
1 Vote"
nasreen-akter answered KunalBhatia-2218 commented

Hi @KunalBhatia-2218,

Would you please try case(LocalToBaseRate == 0.00000000, 1.00000000, LocalToBaseRate) . Thanks!

· 13
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KunalBhatia-2218 avatar image KunalBhatia-2218 ·

Hi @nasreen-akter

This gives me error, below is the screen shot
197458-image.png


0 Votes 0 ·
image.png (19.3 KiB)
nasreen-akter avatar image nasreen-akter KunalBhatia-2218 ·

Hi @KunalBhatia-2218, what is the datatype for LocalToBaseRate field?

0 Votes 0 ·
KunalBhatia-2218 avatar image KunalBhatia-2218 nasreen-akter ·

Data Type is Decimal

0 Votes 0 ·
Show more comments