Using the 'LIKE' operator in Scribe

Lets understand this with an example.

Source System = A

Target system= B


I am querying contacts from System A. Each contact will have a company. I am then looking up for accounts in the target system B. This is where I want to use the like operator as the company name in source will not be exact match to the account name in the target.

When I use the lookup criteria AccountName is LIKE Contact.Company, it doesn't work.


I also tried using AccountName is LIKE "%Contact.Company%", but it still did not work.


The example that I am testing has a Company=Cvent and Account Name=Cvent Private Limited.


Kindly help

(2) Answers