Case statement

To define Logical attributes PowerSuite implements CASE statement similar to the Microsoft SQL Case statement as described in https://learn.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql

PowerSuite Case statement defined as following.

CASE

    WHEN {logical expression} THEN {result expression}

    {optionally: ELSE {result expression}}

END

Multiple Case/End are not supported.