Remove dups and summation

picus_mf · New User Joined: 09 Jun 2006 Posts: 52

Hi,
My requirement is to remove duplicates and sum the values corresponding to the duplicates.
Say for ex:
Emp ID Sal
E001 1000
E002 2000
E001 1000
E001 1000
E002 2000
E003 3000

I should get the output as
Emp ID Sal
E001 3000
E002 4000
E003 3000
How can I get this done?

Thanks.

karthikr44 · Posted: Tue Mar 17, 2009 3:31 pm

Hi,

Try below one

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Hi,
To remove duplicates
adding a small change to the previous post

Arun Raj · Posted: Tue Mar 17, 2009 4:39 pm

Anand,

The card provided by Karthik looks ok. I don't think the OP was asking for an 'XSUM'.

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Arun,
OP was saying Remove dups and summation so it needs to be there to have the duplicates in a seperate file

Anuj Dhawan · Posted: Tue Mar 17, 2009 5:06 pm

Hi,

If you look at the input/output shown by OP - you'll find that sort-card from KARTHIK should suffice.

Arun Raj · Posted: Tue Mar 17, 2009 5:09 pm

Anand,

The OP never mentioned about extracting the duplicates in a "separate file". Duplicate records automatically get removed during summation and that's what I understood. May be I am missing something here. We can wait for his response.

picus_mf · New User Joined: 09 Jun 2006 Posts: 52

Thanks all,

Karthik's reponse has solved my issue. I do not want duplicates in a separate file.