Column Set Analysis - Skip empty cells

[Anonymous]

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!

[Anonymous]

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

[Anonymous]

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.