Case sensitive Issue

Highlighted
Six Stars

Case sensitive Issue

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
Highlighted
Moderator

Re: Case sensitive Issue

Hi,
Could you please indicate the data quality product build version you are using?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Six Stars

Re: Case sensitive Issue

Hi, thanks. Im on version 6.1.1
Highlighted
Employee

Re: Case sensitive Issue

Hi


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

can you have a try?

 

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read