DSXchange

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

Use Aggregator and specify Max rather than Count.

In a sort stage sort on A(Ascending) then B(Descending) and C(Descending).And hash partition on A.Now use a remove duplicate stage on the basis of A.You will get the maximum occurrence.