Search found 1 match

by saeedansari
Sun Sep 04, 2016 10:16 pm
Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
Topic: Get record count while using SUM FIELDS in SORT.
Replies: 1
Views: 5432

Get record count while using SUM FIELDS in SORT.

Hi.

I ned a help in a SORT. Consider the input like this:

XX 100
XX 140
YY 500
YY 50
YY 50


I need the counts of duplicates in another column. Using SUM fields gives the follwoing output:

XX 240
YY 600


But as I said before, I also need to add count of duplicate records in output ...

Go to advanced search