Filter out rows containing certain text

[RUSA]

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.

[MarqueeCrew · Accepted solution]

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

[RUSA]

Thank you for that. I am brand new to Alteryx so forgive me if my solution is not exactly as you laid out, but I got the answer I was looking for. It is attached in case anyone else can use it.