Jump to content

Find Dupes, display top ten


rayh34

This topic is 6272 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 1 month later...

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..

Dupe_Script.JPG

Dupe_result.JPG

Link to comment
Share on other sites

This topic is 6272 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.