Remove duplicate values column - Join

[Anonymous]

Hi everyone,

I trying to remove values in column, image 1 result set

Image 1:

I need show a value "pedido_desconto" with one "pedido_numero", the correct result is this:

In the talend tool I developed this job:

The model is doing the correct 'join' between 'pedido_numero' and also brings the 'pedido_desconto', but I would like it to return as image 2, is it possible? how ?

[akumar2301 · Accepted solution]

If it well sorted ,

You can check prevId value with CurrId , if it is same , make pedido_desconecto as null otherwise Populate it.

here row6.id is your pedido_numero

[Anonymous]

Thank you so very much, Its working now!!!