In an implementation I'm working on, we need to do a couple of Filters in a Data Flow. I noticed that we seem to only be able to create AND comparators when adding extra rows to Filter against. So for any OR checks we want to do, we would need to build a complex expression using functions etc. There is a situation where we need to do some relatively bulky checks with OR, which would be very achievable in a When rule.
As using When rules on Filters in Data Flows doesn't seem to be an option at this time, I've considered building a data transform step instead, where we can then call the When from, and set a property or parameter which is then used in a Filter shape after the Data Transform shape.
Are there any better OOTB functionalities that anyone can suggest?