Find Dupes, display top ten

[rayh34]

I have a DB that has duplicates in it. I need to be able to display the top ten records with most duplicates. Not sure if this enough info. Working on other issues right now, just trying to get a jump for when I dive into this one.

[mr_vodka]

Create a calc field (cDupKey) to concat all the fields that you want to check what at a duplicate is.

Create a Self Join relationship based off this new calc field. 'SelfJoin::cDupKey'

Have a new calc field (cDupNum) with formula Count (SelfJoin::cDupKey).

Then you can create a script that does the following:

Show All Records

Sort cDupNum by Descending Order

Go to Record/Request [First]

Omit Multiple Records [10]

Show omitted Only

[rayh34]

Cool, sounds good. will try that. Thank you.

[rayh34]

Ok, started to actually work on this issue, not really sure how to set up the pervious suggestion. I have users that submit recipes, I need to be able to display the top 5 submiters. So I need to figure out how to check for dupes, sort according to hightest dupes. and omit all after. I need to display all 5 in a window.

[LaRetta]

So I need to figure out how to check for dupes, sort according to hightest dupes. and omit all after. I need to display all 5 in a window.

What, of John's suggestions, did you try? And what didn't work for you? The only thing not explained was the new window and that would be adding the following to the beginning of John's script of:

New Window [ bla bla ]

[rayh34]

Create a calc field (cDupKey) to concat all the fields that you want to check what at a duplicate is.

Basically, I am having problems understanding the very first part. If I can get a handle on what "concat" means and get this done, then I believe I understand the rest. I have only one field that I need to check for dup.

[LaRetta]

Easier then ... just join that field to itself. A concatenated field means combining all the fields which make up the duplicate into a text calculation thus: Field1 & " " & Field2 etc. But since you only have one field, just use IT instead (in your join). :wink2:

[Lee Smith]

From the Online Help. Keywords [color:blue]Text operators

& = Concatenate

Appends the text string on the right to the end of the text string on the left. Text strings can be fields, constants enclosed in quotes, or certain functions.

HTH

Lee

[rayh34]

Making Progress, Here is what I have done;

Created following Fields:

Created a Self Join relationship "URL Staging Area::Domain Name"

cDupDomain = Calc, Unstored, From URL Staging Area, = Sum (Domain Dupes::One)

One = Calc, from URL Staging Area, = 1

SumOne = Summary = Total of One

I will just attach jpg's of both the scripts and result.

Just want one of each record to display, and would like to have in a portal.

If this sounds incohent.. due to major lack of sleep..