topic Selecting Top N Transactions from a transaction file in Talend Studio

Selecting Top N Transactions from a transaction file

_AnonymousUser — Sun, 14 Jul 2013 09:02:43 GMT

Hi, I have a transaction file containing cust_id and tran_amt columns, i want to pick top 3 transaction made by each cust_id. I have tried using tMap, tAggregated, but not able to get the correct results. can you suggest how do i achieve this.
Input Data
cust_id|tran_amt
1001|23
1001|24
1001|25
1004|67
1004|68
1004|69
1004|70
1004|71
1002|45
1002|46
1002|47
1002|48
1002|49
1003|55
1003|56
1003|57
1003|58
===============
Output Data
1001|25
1001|24
1001|23
1002|49
1002|48
1002|47
1003|58
1003|57
1003|56
1004|70
1004|69
1004|68
Regards
Sanjay

Re: Selecting Top N Transactions from a transaction file

alevy — Sun, 14 Jul 2013 11:28:16 GMT

Use tFilterRow with the advanced expression:
Numeric.sequence(input_row.cust_id,1,1)<4

Re: Selecting Top N Transactions from a transaction file

Anonymous — Sun, 14 Jul 2013 13:32:48 GMT

Got it thanks Alevy...posted at 2 locations to get quick answers