IEW Posted January 18, 2005 Posted January 18, 2005 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
-Queue- Posted January 18, 2005 Posted January 18, 2005 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).
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now