-
Fuzzy Matching Logic
Hi, I have a requirement to match records from two separate systems on the basis of FirstName, LastName and DOB from System1 and FisrtName, MiddleName, LastName and DOB from System2 to return the match Id from System2 to System1. Below are the challenges The names are not consistent in both systems . For eg in system1 for…
-
Why this function is not working when using replace matches?
Good afternoon, Could you please help me to undertand why the following function isn't returning the desired outcome. Here is the what it should be doing: Looks if the combination of two columns have a match between the tables i.e. I’m using the match table 1 - Job title/table 2 - position name and table 1 - job…
-
Lookup step returning unexpected values
Hello. I am currently using version 2.8.8.27. I've discovered recently that in one of my workflows, the Lookup step is not returning the expected results in all cases. I have quickly set up a test scenario I have attached below. The idea is the following: The lookup should give back the "Value" column's values in cases…
-
Replacing the string value with Null if the end of the string matches with the LOV
I have company names in a field I want to replace the end of the company name with Null if the name is ending with OY, OYJ, RY etc. For example if I have company name as Mahu COMPANY OY I want to replace it as Mahu Company I have a long list so I have kept that in a lookup table now which function should I use to achieve…
