@KasiaM40 @ThomasSasnett This is exactly what the TableView component is there for and it is soooo simple to use.

1. Set your LookupTable as the TableProvider for the TableView
2. Set the TableView filter using the syntax you provided
3. Call the ApplyFilter method from the TableView
4. Call the appropriate ToTable method from the TableView which will output your filtered datatable

ToTable has 4 method signatures that are useful for various tasks:

• with zero or one parameter it outputs the filtered table
• with 2 or 3 parameters you choose whether to return distinct values and which columns to return - I use this for retrieving data like you do in Excel when you filter a column - you can return all unique values in a column

This component has many other very helpful uses. Try it out.

@KasiaM40 As Jeff alluded to, the TabelView actually works for this. In the attached solution, I built your expression (although used Closed instead of Open to see records as I didn't get around to changing much of the data in the spreadsheet) and it works.

The syntax you want to use is;

Status = 'Open' AND (Bank Like '*Morgan*' OR Bank Like '*UBS*')

Use single quotes around strings and then asterisks instead of percentage signs.