topic [resolved] tSortRow with RowNumber in Talend Studio

[resolved] tSortRow with RowNumber

Anonymous — Sat, 02 Jun 2012 09:20:22 GMT

Hello Talend Team,
I have csv delimiter file which contains column accountname and accountaddress. I want unique accountname with only one address details.
my csv data file
accountname accountaddress
account1 add1
account1 add2
account2 add1
account2 add2
account1 add3
I want output file like
accountname accountaddress
account1 add3
account2 add2
So I have designed my job like
tFileInputdelimiter --------------->tSortRow-------------->tUniqueRow---------------->tFileOutputdelimiter
(accountname) (accountname)
but its gives me output file as mentioned below with first address instead of last address.
accountname accountaddress
account1 add1
account2 add1
please help me how I achieve output file with last address only or is there any way to sort by row number?
Thanks,
Nitin

Re: [resolved] tSortRow with RowNumber

Anonymous — Sat, 02 Jun 2012 13:38:29 GMT

Hi
Yes, you can add an row number for each and sort by the row number. To do it:
1. Add a new column on the output table on tMap, let's call it 'row_number', set its expression as Numeric.sequence("s1",1,1)
2. On tSortRow component, sort by row_number with desc order.
Best regards
Shong

Re: [resolved] tSortRow with RowNumber

Anonymous — Mon, 04 Jun 2012 06:06:33 GMT

Thank you shong.