[resolved] tSortRow with RowNumber

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

Thank you shong.