Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-05-26 06:17 AM

Column Set Analysis - Skip empty cells

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 0683p000009MACn.png Many thanks!
Labels (2)
Labels
260 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2016-06-01 04:33 AM
Author

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
260 Views
0 Likes
Anonymous
Not applicable
‎2016-06-02 05:01 AM
Author

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.

0683p000009MFKM.png
260 Views
0 Likes