Filter out rows containing certain text

Question

I have a csv file with 27 columns and I need to filter out rows that contain either of 2 text strings. Because the text can be in any column I have found myself using on a filter for each column resulting in 27 * 2 filters.

In the attached workflow example I am filtering out rows containing "Alternate Hierarchies" or "Historical Hierarchies". If anyone can share a more efficient method of doing this I would appreciate the help.

Eliminate Rows With Certain Text.yxmd

MarqueeCrew · Accepted Answer

Here's my iPhone advice:

1. Add a RECORDID tool

2. TRANSPOSE the data with the recordid s your group field. 
3. FILTER as Value in (' thing 1', ' thing 2')

now you know what records to drop.

4 join your original data to this stuff on recordid.

output (not the j from the join) the left data and it is the rows without the bad things.

cheers,

mark