Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I have a file that has duplicate part No's and I would like to print out a list showing only the first occurance of a Part No. I have tried a couple of scripts using omit but just can't get it to work. Need some help. TIA

Ivan

Posted

One method is to create a calculation using a self-relationship based on the Part No., equal to serial = selfRelationship::serial. This will return a 1 for the first unique record of each Part No. and a zero for all duplicates (assuming that the relationship is not sorted).

This topic is 7252 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.