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.