Start a new topic
Answered

How to generate partial match on a lookup enricher?

Hello, Is there a way in a lookup enricher to instead of having exact match between the lookup value and the lookup column in order to have a result ,to look for a partial match. For example MATCH if the lookup column 'contains' the lookup value ? Thanks in advance


Best Answer

Hi Hammad

The Semarchy Lookup Enricher will only ever return one value. So, even it was possible to use a partial match, returning several values is not desired as you do not know which one to pick.

Have you tried using the plug-in parameter 'Custom SQL'  with a WHERE clause to identify your desired output?

Regards, Peter

1 Comment

Answer

Hi Hammad

The Semarchy Lookup Enricher will only ever return one value. So, even it was possible to use a partial match, returning several values is not desired as you do not know which one to pick.

Have you tried using the plug-in parameter 'Custom SQL'  with a WHERE clause to identify your desired output?

Regards, Peter

Login to post a comment