topic Case sensitive Issue in Data Quality

Case sensitive Issue

Anonymous — Sat, 16 Nov 2024 10:36:51 GMT

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

Re: Case sensitive Issue

Anonymous — Mon, 30 May 2016 03:02:25 GMT

Hi,
Could you please indicate the data quality product build version you are using?
Best regards
Sabrina

Re: Case sensitive Issue

Anonymous — Mon, 30 May 2016 08:03:42 GMT

Hi, thanks. Im on version 6.1.1

Re: Case sensitive Issue

msjian — Wed, 08 Jan 2020 09:33:18 GMT

I think you need to regenerate the job after change analysis setting

can you have a try?

Regards
Jian
----------------------------------------------------------
Talend | Data Quality