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
Eleven 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
Eleven 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!!!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads