Hello everyone!
I have an interesting task related to the desktop, we have a table combined with certain attributes and with full names, full names are divided into columns (firstname, lastname, midname) and they need to be compared with other columns (firstname1, lastname1, midname1) it is necessary to output non-matching full names. I can't compare one table between columns, I need your help. Do you know how to implement this?
I will be very grateful for your help
HI
For this task I advise you to use the Filter step.
You can use either some straightforward conditions, like
lastname is not lastname1 //is not used to cover null
or midname is not midname1
or firstname is not firstname1Or you can apply some matching functions to do a fuzzy matching.
editDistance(lastname, lastname1) + editDistance(firstname, firstname1) + editDistance(middlename, middlename1) >= 2
//Checks that there is at least 2 changed symbols between the names
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.