Jump to content

ommiting duplicates...


markdesign
 Share

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

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?

Confused.

Link to comment
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

Loop

Test Record (i.e. gTestName = Name)

If Duplicate

Omit Record

Else

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.

Link to comment
Share on other sites

This topic is 7382 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
 Share

×
×
  • Create New...

Important Information

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