Hi. Im trying to use DQ Basic Column Analysis to identify duplicates in list of email addresses. The issue Im facing is that the tool differentiates values such as 'j.smith@yahoo.com' and 'J.Smith@yahoo.com'. Im trying to configure the job to ignore the case, so in Analysis Settings in Analysed Columns section I expand the corresponding column and click Options for Duplicate Count. I check the checkbox 'ignore case' but after running the job the result is completely same. The tool does not recognize j.smith@yahoo.com and J.Smith@yahoo.com as duplicates. Can anyone tell me what Im doing wrong please? Many thanks for help
