Solved

Comparison of two columns for matches in One Desktop

  • 27 February 2023
  • 1 reply
  • 64 views

Userlevel 3
Badge +3

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

icon

Best answer by AKislyakov 27 February 2023, 06:10

View original

1 reply

Userlevel 4
Badge +4

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 firstname1

Or 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

 

Reply