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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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