topic Re: Remove duplicate values column - Join in Talend Studio

Remove duplicate values column - Join

Anonymous — Mon, 25 Mar 2019 14:31:40 GMT

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 ?

Re: Remove duplicate values column - Join

akumar2301 — Mon, 25 Mar 2019 15:02:38 GMT

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

Re: Remove duplicate values column - Join

Anonymous — Sun, 31 Mar 2019 17:14:56 GMT

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