Skip to Content

Case statement in filter condition not working IDT SAP 4.1 sp3

Hi guys

I need to have a case statement for a new filter I need to have in blx as below:

case when (fact_table.event_key in (4,5)) then 'Current' else 'old'

I get an error message saying 'the where clause result type is not boolean'

any idea why?

cheers

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 21, 2016 at 03:38 AM

    Hi,

    You  missed the End Key word at the end of script please use below..

    case when (fact_table.event_key in (4,5)) then 'Current' else 'old' end


    Like e.g. CASE WHEN "EMPLOYEE"."SAL" IN(100,200) Then 500 ELSE 200 END

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded