Hi,
I normally use Custom transformation (CASE statements) when I need to populate a field based on multiple conditions, in this case multiple “OR” conditions (Logical disjunction) . It was brought to my attention not to use CASE statements in Custom transformations.
So I have below an example using a fixed value transformation but I want to add two conditions to populate only when it is ‘FL’ or ‘OL’. When I add these conditions the conditions are on separate lines but still TX makes an “AND” logic of it so instead of (like ‘FL%’ or like ‘OL%’) it translate it to (like ‘FL%’ & like ‘OL%’).
How can I get the “OR” instead of “AND”?
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/5c830d18-b7f3-4f9d-a1f0-f5e87c4b9f0b.png)
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/623dc0e4-e1b9-4d2b-8cfc-b0d3084bc366.png)
Best answer by rogier.helmus
View original