I have a table called "alternate street names" that contains values such as: NORTH, NORTH MILL, NORTH, DRIVE, MILL, MILL DRIVE, DRIVE. (These are the permutations of 'NORTH MILL DRIVE'.)
I also have a table of "exclusions", such as: AVENUE, STREET, DRIVE, NORTH.
The objective is to only write the rows from "alternate street names" where the alternate name is not in "exclusions". Also note that the "exclusions" must be read at run time.
I did a lot of searching and trying different transformers, but could not get anything to work. This seems like a very simple task and I'm just overlooking something.