Lookup with non exact match

CloverDX Platform
1

Hi,

Scenario:
I want to perform simple lookup with exact and non exact match (string). I have lookup table with BRAND and COMPANY NAME.
I have another table master having field DESCRIPTION. I want to search BRAND name in to DESCRIPTION filed and return COMPANY NAME. Now the DESCRIPTION can be in lower or upper case. And BRAND name may be present as word or composite word in the DESCRIPTION. I am trying simple lookup but its search for exact match that is not helpful.

It will be great help from you. Thanks in advance.

Regards,
VIRAG
YPoint Analytics

2

Hi Virag

Based on what you want to achieve, putting the decription into lookup table is more convenient, because you want to search the description for a brand. However you don’t need to use lookup tables at all. It would be easier to have two data flows, both ending up in a cross join component, where a little bit of CTL code is searching the description for a match with the brand and outputs a company name. I’m sending you a graph which works this way, so you can explore it.

I hope this helps
Best regards