You are not logged in.
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
I want output file like
So I have designed my job like
but its gives me output file as mentioned below with first address instead of last address.
please help me how I achieve output file with last address only or is there any way to sort by row number?
Last edited by NitinMunjani (2012-06-02 10:29:26)
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.