DUPKEY MAX, eliminating duplicates and obtain the max



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

DUPKEY MAX, eliminating duplicates and obtain the max

Postby alho200 » Fri Dec 15, 2017 6:03 am

Compare records with same key


Hi,
I need an output file with the line is one registry per key (1,4) and max value (11,4)

Input File
AAAA X1X1 3333
AAAA Y1Y1 9999
AAAA Z3Z3 1111

Output File
AAAA Y1Y1Y1 9999

Is it possible in one step?
i try this:

SORT FIELDS=(1,4,CH,A)
         DUPKEYS MAX=(11,4,ZD)


but the result is:
AAAA Z3Z3 9999
alho200
 
Posts: 1
Joined: Fri Dec 15, 2017 5:40 am
Has thanked: 0 time
Been thanked: 0 time

Re: DUPKEY MAX, eliminating duplicates and obtain the max

 

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post