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