Change values in a column in Data warehouse cloud

[YanGerzon]

Hi,
I have a table with a column called Rate and I need to change the cells of this column which contain NULL values into the number 1.
How do I acheive this?
I assume I need to use expressions in a calculation element?
I just cant seem to figure out what the correct expression for this is.

[amoghkulkarni · Accepted solution]

Hello,

This can be achieved using CASE statement -

CASE WHEN RATE IS NULL THEN 1 ELSE RATE END

More information in the documentation - https://help.sap.com/docs/HANA_CLOUD_DATABASE/c1d3f60099654ecfb3fe36ac93c121bb/20a4389775191014b5a6b...

If this answers your original question, please mark this as the best answer.

Regards,

Amogh K