Select multiple value from column

Have you found a solution to this? I’m also looking at the same problem and one thing I’m considering is using the IN operator on a DataTable.Select query.

DataTable.Select(“[Result] IN (‘ok’,‘No’,‘yes’,‘black’)”)

Thing here is you have to dynamically build the IN query argument to cater to multiple values in the future.

If only there’s an operation called IN or LIKE within the Filter Wizard activity that would allow us to pass arrays!

ETA: I made a blog post tutorial about this solution here :slight_smile:

2 Likes