searching for a solution to make a multiple row filter.
I have a List with customer names (over 150k) and another list with name patterns (198 in total) that i want to be searched in my customer name list.
The result i want to have is a filtered list, where all the customers appears that have a possible pattern from my pattern list.
this is one approach I like and try to utilize in this use cases:
Considering number of patterns might be a bit tricky but you can give it a try. Other (let’s say standard approach) is to use loop to iterate over customer names with pattern one at the time and do filtering/matching/marking.