Selective rejection of records based on sum in SYNCSORT



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

Selective rejection of records based on sum in SYNCSORT

Postby sujithsamuel » Wed Mar 14, 2012 11:47 am

Hi

I have a particular requirement in which there is a need to discard records based on whether the resultant sum of a particular field is zero.

Please find the input file below

BHASKAR 29| 10
BHASKAR 29| 00
BOSE 29| 00
BOSE 29| 00
NATU 27| 00
NARESH 27| 12

The key is from the start of the record till the pipe character '|'.

The requirement is to sum the records based on the key and then discard the records which give zero sum.

The output in this case should be
BHASKAR 29| 10
BHASKAR 29| 00
NARESH 27| 12

Note that in above case the second record did not get discarded because for the same key non zero value exists.

Please help on the same
_________________
Sujith
sujithsamuel
 
Posts: 2
Joined: Thu Nov 03, 2011 9:16 am
Has thanked: 0 time
Been thanked: 0 time

Re: Selective rejection of records based on sum in SYNCSORT

Postby NicC » Wed Mar 14, 2012 1:40 pm

Please do not post in multipl forums at the same time - topic locked.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post