View previous topic :: View next topic
|
Author |
Message |
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hello All,
Here is my requirement with tweaked data.
I would like to list out the number of calls made from each caller to each receiver for the current month.
Input:
Code: |
Caller Receiver Minutes
ABCD1 BGDF1 4:05
ABCD1 BGDF1 2:15
ABDD4 BVFF1 2:85
BVCD4 KDFM1 5:15
CBCD1 DDFF2 3:45 |
I would like to get the count of the records as a separate column with the similar values in Caller & Receiver fields.
Output:
Code: |
Caller Receiver Call-Count
ABCD1 BGDF1 2
ABDD4 BVFF1 1
BVCD4 KDFM1 1
CBCD1 DDFF2 1 |
Please suggest me Which sort trick should we use ?
Code'd |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
After 300 posts I'm sure you should know how to use the Code tags and the Preview button.
Use OUTFIL reporting, with NODETAIL,REMOVECC and SECTIONS with TRAILER3 to produce the information you want and the COUNT. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi Bill Wooder,
Sorry for not following the forum rules while posting.
Thanks for giving me the clue. I will use the SECTIONS now. |
|
Back to top |
|
|
|