How to list all duplicated record ?

[paulyeo11]

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

[jyothish8807]

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

[tresesco]

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]

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]

Try this expression

aggr(NODISTINCT RowNo(),PART_NO_)

[paulyeo11]

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]

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]

Hi Tres

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

Paul

[paulyeo11]

Hi Peruma

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

Paul