Asked a question 8 months ago

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

Training & Solutions Architect at Semarchy

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

hammad akhtar 
Thank you for your answer, yes this is what i finally done. I made a custom sql request that answer my needs.