Hi,
Im extracting A,B,C columns from dataset. All the three columns have values which occur more than once. So I need to populate the column A only for the maximum occurence of B and maximum occurence of C. I have used aggregator to get the count. But the count can be done for only one column. If there any other way ?
Example
A B C
1 1 2
1 1 1
1 1 2
Result : A B C
1 1 2
how to get max count of 3 columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am