Find duplicate records

[#1]

Hi,

How to find duplicate records from given below tables:

order_number	city_name
10000004	rüsselsheim
10000008	kiel
10000009	schildow
10000011	mühlenbach
10000012	brandenburg
10000013	schildow
10000014	schildow
10000004	rüsselsheim
10000008	kiel
10000008	kiel
10000008	kiel

Result is 2, kindy gives suggestion to resolve it.

Regards,

Zain.

[SunilChauhan]

in dimension

OrderNumber and city Name

and in expression

Count(OrderNumber )-count(distinct OrderNumber )

hope this helps

[#3]

I tried but its show me count result 4.

Regards,

Zain.

[SunilChauhan]

see the attached file

hope this helps

[#5]

Thanks for reply, but my problem still same, i need count just dislay 2 not with dimension, second i used your condition but its show me some result is true and some result is false i dont know why, i will send you application, right now if(count(OH.order_number)>1,count(OH.order_number)) this expression is ok to me.

its gave me correct result but i unable to show total count in  text object.

Regards

Zain.

[nagaiank]

A sample application showing the two duplicate order_numbers for your data is attached. Hope this helps.

[#7]

Thanks for your replay, i need expression show me result without any changes in script, i did and got result in script.

Regards,

Zain.

[nagaiank · Accepted solution]

Use the following expression in a text box and see if this meets your requirements.

='Number of Dupplicates = ' & Sum(Aggr(If(Count(city_name)>1,1,0),order_number))

[#9]

Thanks a lot its working now.

Regards,

Zain.