Multiple Row Filter with List of Patterns

Hello @ all,

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.

Any suggestion?

Best regards
Christopher

Hello @Christopher_Lozano,

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.

Br,
Ivan

1 Like

Thanks @ipazin

That was exactly what i was looking for. Workflow works properly and deploys the expected results.

Br,
Christopher

1 Like

Hi @Christopher_Lozano,

glad to hear that!

Br,
Ivan

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.