Skip to Content
Dec 02, 2013 at 03:13 PM

Looking up a substring


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

My lookup table has

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