Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to list all duplicated record ?

Hi All

The reasons is duplicated record , create issue on display price list as there are 2 record QV does not know which one to display. so i need to find out how many duplicated record in my

database , and i need to manually delete those duplicated record.

I like to know how to add one more expression at the enclosed table , which will indicate all duplicate record with "1" ?

Below are the duplicated record :-

FC9001-0010

FC9002

FC9004

FC9011

Paul

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Chart : Straight Table

Dimension : PART_NO_

Expression: =If(Count(PART_NO_) > 1, Count(PART_NO_))

or if you have part_no with duplicate product groups

=If(Count(DISTINCT [Product Group]) > 1, Count(DISTINCT [Product Group]))

Regards,

jagan.

View solution in original post

18 Replies
jyothish8807
Master II
Master II

Hi Paul,

Create a Rowno() in your script so it will create a unique primary key for all the rows, then you can identify your duplicates easily.

Eg:

Load

Rowno() as Sino,

A,

B

from <>;

Regards

KC

Best Regards,
KC
tresesco
MVP
MVP

How do you decide the duplicacy of records, PART_NO coming more that once? If so, try list box expression:

Aggr(if(Count(PART_NO_)>1,PART_NO_),PART_NO_)

and it gives much more part_nos than you thought.

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Paul,

PFA,I hope it help to u

Kushal_Chawda

I think you have two different product group for FC9004 Part_no. that is why it is getting two row in your chart.

er_mohit
Master II
Master II

Try this expression

aggr(NODISTINCT RowNo(),PART_NO_)

paulyeo11
Master
Master
Author

Hi Mohit

When i add below into my expression :-

aggr(NODISTINCT RowNo(),PART_NO_)

I am not able make the table list all duplicate record , like FC9004. any advise ?

Paul

paulyeo11
Master
Master
Author

Hi Kush,

Yes you are right , that is my problem on my raw data . now i need to list them out , any idea ?

Paul

paulyeo11
Master
Master
Author

Hi Tres

Thank you. But how come it never list FC9004 ? As FC9004 have duplicated record .

Paul

paulyeo11
Master
Master
Author

Hi Peruma

Thank you very much , your answer very similar to Tres. But why FC9004 is not listed ?

Paul