Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to find wich PK have duplicates

Hi,

I've been searching, but i don't need to know how many duplicates are, i've already know this. I need to find wich are the duplicated ones to find why is getting duplicated.

I have a very large table with 66246 rows and only one duplicate, anyone know how to find it?. tring with EXCEL crashes...

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Hi!

It sounds contradicting when Primary key has duplicates. However to know those duplicates one method could be:

=Aggr(If(Count(column)>1,1,0),column)

Good luck!

Avinash

View solution in original post

1 Reply
Highlighted
Creator
Creator

Hi!

It sounds contradicting when Primary key has duplicates. However to know those duplicates one method could be:

=Aggr(If(Count(column)>1,1,0),column)

Good luck!

Avinash

View solution in original post