Get record count also along with SUM.
Posted: Wed May 03, 2017 11:52 am
Hi,
I know tha tusing SUM FIELDS I can sum the values in an input file in sort but how can I get the count of the fields too which are summed up? For example, if my input is like this:
The output should look like:
Please let me know if there is a way to achieve this?
I know tha tusing SUM FIELDS I can sum the values in an input file in sort but how can I get the count of the fields too which are summed up? For example, if my input is like this:
Code: Select all
ABC 250
ABC 150
EFG 700
EFG 100
EFG 100
EFG 050
Code: Select all
ABC 400 2
EFG 950 4