Hello All,
I am looking to compare the two address and calculate match percentage. Below is the sample data. Can anyone assist.
| ID | Data1 | Data2 | Match Score |
| 123456 | HAMBURG FEDERAL REPUBLIC OF GERMANY DE 20095 | HAMBURG FEDERAL REPUBLIC OF GERMANY 20095 | |
| 888888 | MONACO PRINCIPALITY OF MONACO MC 98000 | MONACO 98000 | |
| 888888 | MONACO PRINCIPALITY OF MONACO MC 98000 | MONACO 98000 | |
| 777777 | BERLIN FEDERAL REPUBLIC OF GERMANY DE 13187 | BERLIN BERLIN 13187 | |
| 222222 | HAMBURG FEDERAL REPUBLIC OF GERMANY DE 22297 | HAMBURG FEDERAL REPUBLIC OF GERMANY 22297 | |
| 222222 | HAMBURG FEDERAL REPUBLIC OF GERMANY DE 22297 | HAMBURG FEDERAL REPUBLIC OF GERMANY 22297 | |
| 222222 | HAMBURG FEDERAL REPUBLIC OF GERMANY DE 20249 | HAMBURG FEDERAL REPUBLIC OF GERMANY 20249 | |
| 333333 | MÜNSTER FEDERAL REPUBLIC OF GERMANY DE 48161 | MüNSTER FEDERAL REPUBLIC OF GERMANY 48161 | |
| 333333 | MÜNSTER FEDERAL REPUBLIC OF GERMANY DE 48161 | MüNSTER FEDERAL REPUBLIC OF GERMANY 48161 | |
| 789100 | ESCHEBURG FEDERAL REPUBLIC OF GERMANY 21039 | ESCHEBURG FEDERAL REPUBLIC OF GERMANY 21039 | 100% |
