Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
in dimension
OrderNumber and city Name
and in expression
Count(OrderNumber )-count(distinct OrderNumber )
hope this helps
I tried but its show me count result 4.
Regards,
Zain.
see the attached file
hope this helps
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.
A sample application showing the two duplicate order_numbers for your data is attached. Hope this helps.
Thanks for your replay, i need expression show me result without any changes in script, i did and got result in script.
Regards,
Zain.
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))
Thanks a lot its working now.
Regards,
Zain.