Hi Every One!
I have a requirement and need to write a new program.
My input file will be like below:
Mem-nbr Prod-nbr Begin-dt end-dt amt
A123 p111 01162011 01312011 5000
A123 p111 02102011 01282011 10000
A123 p111 03122011 03312011 2000
A123 p222 04162011 04302011 7000
A123 p222 01162011 01312011 5000
A444 p333 05162011 05312011 2000
A444 p123 06122011 06302011 14000
A444 p222 07162011 07302011 2000
A444 p444 03162011 03312011 4000
my output file should be like below:
total-amt=5000+10000+2000+7000+5000 = 29000
Header of A123 total-amt
Detail record of A123
Detail record of A123
Detail record of A123
Detail record of A123
Detail record of A123
Header of A444 total-amt
Detail record of A444
Detail record of A444
Detail record of A444
Detail record of A444
i.e output file :
A123 29000
A123 p111 01162011 01312011 5000
A123 p111 02102011 01282011 10000
A123 p111 03122011 03312011 2000
A123 p222 04162011 04302011 7000
A123 p222 01162011 01312011 5000
A444 22000
A444 p333 05162011 05312011 2000
A444 p123 06122011 06302011 14000
A444 p222 07162011 07302011 2000
A444 p444 03162011 03312011 4000
can anybody help me out to write the logic for above requirement ?
Thanks in advance...