Can u help me in writing a SORT card which will count the number of similar records clubbed to sum:
My Input file is:
2013-10-01 00:00:00|ABC |-000000100.15
2013-10-01 00:00:00|ABC |+000000200.15
2013-11-01 00:00:00|DEF |+000000200.15
2013-11-01 00:00:00|DEF |+000000100.15
2013-11-02 00:00:00|XYZ |+000000250.15
2013-11-02 00:00:00|XYZ |+000000400.15
I need an output which will do the following:
2013-10-01 00:00:00|ABC |+000000100.00|2
2013-11-01 00:00:00|DEF |+000000300.30|2
2013-11-02 00:00:00|XYZ |+000000650.30|2
Here, 2 records for ABC from input file were added and so that count is displayed after each unique record.
Can I have the SORT card for getting the same?