Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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