how to transform data having same id.

[Anonymous]

Hi Team,
we are stuck at one point below are the requirement. i have table having 3 column namely(sso,id,output) and we need to transform those column and put the records in third column that is output. how can we do this in talend.
example are below-->
sso,id-----output
1234,XV--->PL17
1235,PL17-->PL17
1234,PL17--->PL17
1239,XV-->XV

if same sso has both id values(PL17 || XV) then we need to populate PL17 in output column.

pls help me out to resolve the issue . thanks in advance.

regards

Shail

[Anonymous]

hi guys,
Can anyone pls help me out to solve the above problem.as its bit urgent and i am not able to solve.

[Anonymous]

Hi All,
any update on above request ?
regards
Shail