Is there a way to remove rows from a table that contain strings found in another table? The article below is very close to what I want to do, but it’s an exact match removal rather than removing all values that contain.
For example, if my main table has the following values:
nike shoes
running shoes
tennis shoes
hiking boots
And my table for things to remove has “shoes” in it, only ‘hiking boots’ would remain.
Hi @LoganRay Depends on what patterns the main table take. Does each row contain only two words, and the second word is the one that’s used to match with the reference table? In that case, you’ll have to use the cell splitter node to split the two words first. Then use the second column to match with the referenced table, via the Reference Row Filter Node. (Assuming the reference table consist of only one word too per row).
Not quite, I should’ve mentioned I’ll have several single-word lines in the exclude list. I can do this with a python node, but I’d prefer a purpose-built node/workflow if that’s possible.
Awesome! From the title of this post, I believe it’s gonna help future answer seekers find solutions fast for cases like this when they do their forum search.