Skip to Content

CASE WHEN Issue

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

Regards

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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

    Add comment
    10|10000 characters needed characters exceeded