Column Set Analysis - values combined

Anonymous — Mon, 20 Jun 2016 12:02:13 GMT

Hi. Im trying to identify duplicates across multiple columns. I have list of contacts with multiple fields for email, sample attached. The first column is the record Id. Im trying to use column set analysis however Id like to know if I can configure following:
1) The values in columns are not in same order, which means the tool would rather identify combination of values than exact sequence as they are in columns. In my sample this would mean Records 1 and 3 would be identified as duplicates. Is this possible? How?
2) Lets say two records share only one email address, Id like those two records to be identified as duplicates. In my sample this would be records 4 and 5.
Many thanks for help.

Re: Column Set Analysis - values combined

Anonymous — Wed, 22 Jun 2016 08:06:39 GMT

Hi,
Could you please take a look at TalendHelpCenter:Table analyses which includes business rule analysis, match analysis and functional dependency analysis?
Best regards
Sabrina

topic Re: Column Set Analysis - values combined in Data Quality

Column Set Analysis - values combined

Re: Column Set Analysis - values combined