Filter multiple Values by Expression

maxse

Hey guys I want to filter something special, depending on whether the data is there or not.

You do not know beforehand it will be one or the other combination therefore a kind of double filter:

There are 3 different parts:

Part A
Part B
Part C

If now all three parts are present, only part A and part B should be let through the filter.

But if part B is not there then part A and part c should be let through.

For example, if the database contains only

Part A
Part C

is available.

There are also only the two options,
so either all 3 parts are in, but then only A and B should go through the filter and C not and the second is if B is not there, only A and C should go through the filter.

how can I implement this?

IraWatt

Hey @maxse,

I dont fully understand your second example as to what should come out the True if only A and C are present but here is an idea of how to do this:

I just count the number of distinct parts before the filter then change the logic accordingly in the filter (see above/attached).

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com  

Workflow.yxmd