Searching for a Pattern in a Lookup Table column

Hello,

I want to search a particular column in a lookup table for a given pattern.

For example, let's say one of the rows for that columns has: "12342","544332",5533442"

I want to search "544332" and find a match in that row.

I hope that makes sense? How can I do this?

Thank you,

David.

said almost 2 years ago

Hi David,

You can either use an action to lookup an entry or use a lookup formula to find a corresponding value. See image below:

Please also visit our docs regarding lookup table here.

Send us a ticket, we will try our best to assist you with your problem