Need to add new column with the amount

pradeepkit · New User Joined: 25 Jun 2008 Posts: 60 Location: chennai

Hi,

I have a file in the below mentioned record layout.

A 11-01-2014 10.0
A 11-01-2014 10.0
A 11-02-2014 20.0
B 11-01-2014 30.0
C 11-02-2014 20.0
C 11-03-2014 10.0

I need to creat the output file in the below format.

A 11-01-2014 10.0
A 11-01-2014 10.0 10.0
A 11-02-2014 20.0 20.0
B 11-01-2014 30.0 30.0
C 11-02-2014 10.0
C 11-03-2014 10.0 10.0

I need to add new column with the amount but written to the only last record of the First and second columns combination.

your help is appreciated.

Thanks,
Pradeep

Terry Heinze · Posted: Fri Nov 21, 2014 2:09 am

pradeepkit,

In the future, please try to use a more meaningful topic name.

Rohit Umarjikar · Posted: Fri Nov 21, 2014 2:46 am

Have you thought of JOINKEYS, IF THEN and BUILD? I think , that should help.

Bill Woodger · Posted: Fri Nov 21, 2014 6:45 pm

It is not quite clear what you want, but see if this and its links help.

Bill Woodger · Posted: Fri Nov 21, 2014 6:45 pm

It is not quite clear what you want, but see if this and its links help.

Arunkumar Chandrasekaran · New User Joined: 01 Jun 2010 Posts: 63 Location: India

Bill Woodger · Posted: Fri Nov 21, 2014 8:30 pm

Arunkumar Chandrasekaran,

Yes, and why does the value for that record also change from 20.00 to 10.00 :-)

I think we should pause until all this is clarified.

Arunkumar Chandrasekaran · New User Joined: 01 Jun 2010 Posts: 63 Location: India

Yes Bill. You are right.