I am using the Filter Data Table activity to only show me items that have the following:
Subject column Starts With “Undeliverable”
DateTime columns does not start with either of “Mon”, “Tue”, “Wed”, “Thu”, “Fri”
The output for some reason is still showing items that start with something other than “Undeliverable” and shows all items with days of the week in DateTime.
What am I doing wrong please?
Also, is the top row in the Rows Filtering an AND or an OR condition? And does the order of conditions matter? My experience with other pieces of software is that one usually configures ORs and then ANDs. Many thanks!
UPD: Thank you, funnily enough I just changed all the OR conditions to AND and it produced the results I needed. Doesn’t make sense but worked so fine by me.
I asked the moderator to delete this topic, thank you all for your answers.