View previous topic :: View next topic
|
Author |
Message |
nnkthri
New User
Joined: 01 Apr 2016 Posts: 1 Location: India
|
|
|
|
Hello All,
Please suggest how to achieve below desired result using DFSORT.
Input:
------
Code: |
XXXXX;111;2014;AAAAA;222;2014;
XXXXX;111;2014;AAAAA;222;2014;
XXXXX;111;2014;AAAAA;222;2014;
ZZZZZ;111;2015;BBBBB;222;2015;
ZZZZZ;111;2015;BBBBB;222;2015;
ZZZZZ;111;2015;BBBBB;222;2015;
ZZZZZ;111;2015;BBBBB;222;2015;
|
Output:
-------
Code: |
2014 2015
Total Unique
111 1 0
222 1 0
Total Count
111 0 3
222 0 4
|
Total Unique --> distinct Count of XXXXX from pos 1 to 15 per year
distinct Count of AAAAA from pos 16 to 15 per year
Total count --> Number of occurances of XXXXX from pos 1 to 15 per year
Number of occurances of AAAAA from pos 16 to 15 per year |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
its not clear what is expected. but what is the problem that you face? There are many similar topics under dfsort forum, please take a look. |
|
Back to top |
|
|
|