Eliminating Duplicates in CA Sort Output

Document ID : KB000051516
Last Modified Date : 14/02/2018
Show Technical Document Details


You want to sort a file that has duplicate records, i.e. records with identical values for the sort key. You want the duplicates eliminated.


CA Sort does not have a general option to exclude duplicates from the output.

The SUM FIELDS option can be used when totaling the values of numeric fields. That special case is the only one in which CA Sort can eliminate duplicates.

CA Technologies has products such as VISION:Report and VISION:Results that have a selection process that will enable you to accomplish your goal.