Filtering against a large list
SummaryI have a list of over 8k routing numbers. I want to know any one in transitions who has a routing number that does not match one of the 8k in the list.
We often have candidates that will not put their routing numbers in correctly and we would like to identify these mistakes before employment begins. I'm not really excited about creating a string of 8k numbers separated out by ; Is there a way to build this list into OBI and filter against it?