Skip to Content


Feb 15 at 12:05 PM


avatar image

Hi Experts,

When i am applying CASE WHEN condition in filter transformation to required column ,once save the flow graph the case when condition is copying to other field automatically when it save and few statements removing when i wrote the statement required column .actual condition statement is copying to unnecessary field. This is i am using WEB ide .

Ex: Field1 (case when Field1 is null then '' else 0)end . issue is condition is copying to other fields like Field3 and few statements removing field1. please look into issue and do the needful.

Thanks in advance



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jeff Kresse
Feb 15 at 03:40 PM

Hi Ramesh,

If you are using the CASE WHEN just for handling nulls, you can instead map with the IFNULL() function. This function will return the first non-null value in its list. Use it like this:

IFNULL(<input column reference>, <default value>)

If there are other uses for CASE WHEN in your flow, screenshots or text of the mapping expression and where you implemented it would be helpful.

Best regards,

Jeff K

10 |10000 characters needed characters left characters exceeded