Search found 1 match
- 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: 3563
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 like this: XX 240 2 Y...