Jump to content
Sign in to follow this  

ommiting duplicates...

Recommended Posts

I have a huge data base, and I am trying to pull up the list of all the "names".

I pull up the report and sort it by the "name" so that the duplicates are in groups.

Now what I need is a list of the "names" with out the duplicates, so I know how many different names I have.

I tried using the omit multiple but that one you have to do it manually one at a time. And it will take way too long. In Excel, it was easy, all you had to do in excel was select the entire and click advanced sort and it would automatically omit all the multiple.

There has to be an automated way to do this...but i can not figure it out. Maybe i should post this in script board since it might be a scripting problem?


Share this post

Link to post
Share on other sites

You will basically have to loop through the found set and omit all the duplicates. It is a pretty easy solution. Basically:

Goto First Record

Store Starting Test Values (i.e. Name)

Goto Next Record


Test Record (i.e. gTestName = Name)

If Duplicate

Omit Record


Store Test Values

Goto Next Record [Exit after last]

End Loop

Some tweaks will need to be made, but this is basically the pattern. Obviously this is pseudo-code so do not look for this script steps exactly.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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