Hi Peeps,
Facing some issues while using fuzzy match tool .
Taking below table as an example:
| Record id | NAME |
| 1 | P R BISWAS |
| 2 | PULAKH RAJ BISWAS |
| 3 | RANJAN CHOPRA |
| 4 | R CHOPRA |
So basically I am applying (Best of Jaro & Levenshtein) Algorithm for making a match and i have kept a match threshold of 85%.
And After that i am using make group tool to generate parent key for all the possible matches.
for record id (3 & 4) match score = 92 so it shows me like this
| Record id 1 | Record id 2 | Match Score |
| 1 | 2 | Null |
| 3 | 4 | 92 |
And I know the reason for (Null) because match score is 50 for record id (1 & 2) when i tried it seperately.
Now this is the Problem that I want same for 1 & 2 as well just like (3 &4) so that Final output could be like this :
| Parent key | Child key |
| 1 | 1 |
| 1 | 2 |
| 3 | 3 |
| 3 | 4 |
