help in icetool to sum the fields and eliminating duplicates
Posted: Tue Jul 29, 2008 7:42 pm
I need help to get the duplicate records eliminated for the file having 80 length of fixed block
my input looks like this:
i need a output file with sum of values in third field for duplicates and with maximum date in the second column:
Satheesh
my input looks like this:
AAA 20080122 1200
AAA 20091201 1800
AAA 20070506 3000
AAA 20091201 1800
AAA 20070506 3000
i need a output file with sum of values in third field for duplicates and with maximum date in the second column:
AAA 20091201 6000
Satheesh