One Star

fuzzy match for a column in same table

Hi,
I am trying to perform fuzzy match on table.
I am trying to compare rows in same table and find duplicate rows.
For Example
FirstName, LastName, DOB
Mary          Jones       12/16/1960
Mary          Jones       12-16-1960
Mary          Jones       1960-12-16
Mery          Jones       1960-12-16

All of these records can be duplicate record, i need to mark them as duplicate. How can i do that using tFuzzyMatch? I am using TOS-DI tool.
Thanks
1 REPLY
Moderator

Re: fuzzy match for a column in same table

Hi,
Have you already checked component reference about:TalendHelpCenter:tFuzzyMatch?
What does your expected result look like? Do you also check component TalendHelpCenter:tUniqRow which is used to compare entries and sorts out duplicate entries from the input flow?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.