cancel
Showing results for 
Search instead for 
Did you mean: 

Looking up a substring

former_member202087
Active Participant
0 Kudos


I have a situation where I need to lookup against just a portion of a field (i.e. the equivalent of LIKE in SQL).  How can I make this happen in data services as it seems I cannot manipulate the column in the lookup table as part of lookup_ext.

As an example.

I have a source email field with jsmith@abc.com

My lookup table has jsmith1@abc.com

I want to lookup and find that jsmith1 record as a match.

Accepted Solutions (0)

Answers (3)

Answers (3)

abhi2636
Participant
0 Kudos

Hello Ken,

Try using match transform for your requirement.

In match transform editor Select 'Options' tab--> Select 'Edit Options' box---> Under 'Group Forming' option Add 'Candidate Selection'--> Use 'Create custom SQL' option to add second source which is used to compare and use 'column mapping' option to map the columns---> Use 'Match Criteria' option to provide the % of values to be matched.

To get idea on 'Candidate Selection', Download match transform 'Match transform Blueprints' provided by SAP and work on them.

Regards,

Abhi

former_member200473
Contributor
0 Kudos

Hi Ken,

I agree with Arun.

May be you can take a try also :

1 Way- In Lookup_ext(), you have an option called Custom SQL, you can try with that and

2 Way - Just a guess, first apply normal lookup_ext() and and then when you find '=' sign ,just replace this with "like" operator. but again you can give one value (for example : where abc like '%abc%'), you can not give multiple value and may be you can take a chance with 'IN' operator.

Request you update the thread with your research

Cheers,

Shiva Sahu

Former Member
0 Kudos

Hi,

There is no match operator in lookup that help you.

You have to use a join instead of a lookup.

Thanks,
Arun