Remove duplicate values column - Join

Highlighted
Four Stars

Remove duplicate values column - Join

Hi everyone,

 

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

 

Image 1:

 

001.JPG

 

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

 

002.JPG

 

In the talend tool I developed this job:

 

003.JPG004.JPG

 

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 ?


Accepted Solutions
Nine Stars

Re: Remove duplicate values column - Join

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

 

TalendImage3.JPG

Regards
Abhishek KUMAR

All Replies
Nine Stars

Re: Remove duplicate values column - Join

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

 

TalendImage3.JPG

Regards
Abhishek KUMAR
Four Stars

Re: Remove duplicate values column - Join

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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads