The output table contains the matching information from both input tables and the mmatching score. If multiple row entries exist for the same id, the higher scoring entry gives the best match. For example, the first row (with score 1) is a better match than the second (with score 0.6036). The creditscore column contains applicant credit scores.
IdentityMatch Output Table (Columns 1-6)
a.id |
a.firstname |
a.lastname |
a.email |
a.zipcode |
a.department |
1 |
John |
Dewey |
john.dewey@corp-mark.com |
77459 |
Marketing |
1 |
John |
Dewey |
john.dewey@corp-mark.com |
77459 |
Marketing |
2 |
Sarah |
Anders |
sarah.anders@corp-sales.com |
77584 |
Sales |
3 |
Elizabeth |
Hall |
elizabeth.hall@corp-eng.com |
77550 |
Engineering |
4 |
James |
Nickson |
james.nick@corp-it.com |
77501 |
IT |
6 |
Jessica |
Right |
jessica.right@corp-mark.com |
77459 |
Marketing |
IdentityMatch Output Table (Columns 7-13)
b.id |
b.lastname |
b.email |
b.zipcode |
b.department |
b.creditscore |
score |
1 |
Dewey |
john.dewey@corp-mark.com |
7774 |
market |
700 |
1.0000 |
4 |
right |
|
77459 |
Marketing |
690 |
0.6036 |
3 |
Anders |
sarah.anders@corp-sales.com |
77584 |
sales |
650 |
1.0000 |
2 |
Hall |
|
77550 |
eng |
790 |
0.7000 |
5 |
Nickson |
|
7750 |
IT |
620 |
0.8000 |
4 |
right |
|
77459 |
Marketing |
690 |
1.0000 |