Commencer un nouveau sujet
Répondu

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


Meilleure réponse

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 commentaire

Réponse

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

Connexion pour poster un commentaire