topic Re: Merge two rows in Talend Studio

Merge two rows

sbhadra — Fri, 05 Apr 2019 13:23:27 GMT

I have some set of rows where I have one key (Emp Id in this scenario) and I want to merge values coming in two different rows. How to achieve this below scenario in Talend. Below is the example

Emp Id Current Address Old Address

1234 New York

1234 California,San Francisco,New Jersey

Basically it should come in one row instead of two rows.

Emp Id Current Address Old Address

1234 New York California,San Francisco, New Jersey

Re: Merge two rows

TRF — Fri, 05 Apr 2019 13:39:40 GMT

tAggregateRow is here for that:

Re: Merge two rows

Anonymous — Fri, 05 Apr 2019 13:46:57 GMT

I did it slightly different way.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Merge two rows

Anonymous — Fri, 05 Apr 2019 13:49:50 GMT

But I doubt whether my solution will work for multiple ids as multiple records for different ids might get rolled up to single record.

So I prefer TRF's solution.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Merge two rows

sbhadra — Mon, 15 Apr 2019 13:56:36 GMT

Hi Nikhil,

Yes, it is not working for multiple ids. The format which I am getting is like mentioned below

Emp Id Current Address Old Address

1234 California

1234 Los Angeles, New York

2123 New York

3141 Washington

3141 Boston, Minneapolis

There are multiple ids. If there is a duplication of Id I need to merge it to one single row.

And also suggest what is TRF solution and how the above can be achieved through TRF.

Re: Merge two rows

sbhadra — Tue, 16 Apr 2019 06:07:24 GMT

Team,

Any suggestion on the above problem will be really appreciated.

Re: Merge two rows

manodwhb — Tue, 16 Apr 2019 06:36:25 GMT

@sbhadra ,check the below one as @TRF suggested,it will work.

Re: Merge two rows

KamSH — Fri, 10 Nov 2023 03:01:18 GMT

The suggestion by TRF does not seem to be working for me.

Using the same data from OP as an example, the result given was this:

Emp Id Current Address Old Address

1234 New York

The row containing California,San Francisco, New Jersey was removed insteaed