How to generate partial match on a lookup enricher? : Portal

Start a new topic

Answered

How to generate partial match on a lookup enricher?

Fathia Jama

started a topic over 2 years 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

Best Answer

Fathia Jama said over 2 years ago

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

Fathia Jama

said over 2 years ago

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