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

[paulyeo11]

Hi Jyothish

I try to use expression to do it first , till i have no choice , then i will try load script.

Paul

[jyothish8807]

Hi Paul,

I have a doubt, why do you want to delete the duplicates since the product group associated with Part no is different?

Use Sum(Listprice) as expression.

Regards

KC

[jagan · Accepted solution]

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.

[perumal_41]

Hi Paul,

In my application listing FC4009.

PFA

[Kushal_Chawda]

Please see the attached.

I have created one table for Duplicate records

[paulyeo11]

Hi Jagan

Your answer , so far it the best .Because you can display duplicated rec on table.

Thank

Paul

[paulyeo11]

Hi Perumai

Okay after i change the presentation Tab number of line = 9999 , i can view FC9004.

Thank you.

Paul

[paulyeo11]

Hi Kush

Thank you very much , your also working.

Paul

[paulyeo11]

Hi Jyothish

you ask a very impt question , because it is very hard for me to remove manually all duplicated record. as i have too many duplicated record.

can i show you my actual QV doc , and you can advise me how to modify my expression , so that FC9004 can be display out ?

Paul