Filtering table, keep rows that do not contain words

Hello all,
I currently am trying to filter an excel sheet keeping only certain rows.

I am able to keep the rows that dont have the headers but I want to also keep rows that do not contain certain words.

How would i set that up in the datatable filter table.

Use Read Range To read that sheet Data
Then Use filter Datatable Activity
In input give Output of Read Range
set condition for columns “Column Name” Contains “Your Word”
Then use Remove option

1 Like