topic Column Set Analysis - Skip empty cells in Data Quality

Column Set Analysis - Skip empty cells

Anonymous — Sat, 16 Nov 2024 10:37:12 GMT

Hi. Im trying to use Column Set Analysis in Open Studio for Data Quality to identify duplicated rows in several columns. In one of those columns though, many cells are blank and I would like to skip these rows and do not include them in results as duplicates. Any idea? Im quite new to all these tools and not really IT guy either so.. easy to understand solution would be much appreciated Many thanks!

Re: Column Set Analysis - Skip empty cells

Anonymous — Wed, 01 Jun 2016 08:33:32 GMT

Hi,
Could you please set an example with input and expected result for your case?
What does your input column look like (many cells are blank)?
Best regards
Sabrina

Re: Column Set Analysis - Skip empty cells

Anonymous — Thu, 02 Jun 2016 09:01:10 GMT

Hi. Well I have table something like this below (but million rows), many cells in second column are blank so they are identified as duplicates (such as rows 4 or 10), but I would like to skip those where the cell is blank.. I want row 2 only to be identified as duplicate in this case.