Hi @ellobyhn , one approach is to create a rule based row filter that finds all rows that match your rule.
So this finds the rows containing Code beginning S1, Stock=0, Order Quantity > 0
You can then join this back to your original data set on “Group” and that will bring through all rows for the required group and no others
Here I’ve also used a groupby on “Group” as a shortcut for ensuring I don’t have multiple rows containing the same “Group” coming though.
These “required groups” can then be joined back onto the original data, by “group” so it brings through all required rows, but none of the others
There are other ways that this could be achieved but hopefully this gives you an idea to work with.
filter using rule and join.knwf (11.1 KB)