topic Join two row into 1 row in Talend Studio

Join two row into 1 row

Anonymous — Sat, 16 Nov 2024 03:59:33 GMT

The data is look like this after processed.

|11/13/2019 05|SPEED|8 | |
|11/13/2019 06|SPEED|8 | |

|11/13/2019 05|SPEED| |9 |
|11/13/2019 06|SPEED| |9 |

What i want is data like this...Anyway or any operator can help to solve this problem?

|11/13/2019 05|SPEED|8 |9 |
|11/13/2019 06|SPEED|8 | 9|

Re: Join two row into 1 row

TRF — Thu, 28 Nov 2019 07:28:34 GMT

Could be interesting to know the rest if the process. Anyway, if we consider these 4 records as the starting point, use this input as the main and Lookup for a tMap with an inner join based on 1rst field. Then get 3 fields from the main row and the 4th one from the lookup.

Re: Join two row into 1 row

Anonymous — Thu, 28 Nov 2019 14:56:59 GMT

@Teoh_96

I believe below solution will help in your case. I am assuming the first pipe symbol is not needed. If the data is coming in that way from source, you can read the empty string before first pipe symbol in your input data to a dummy string and ignore them in subsequent flow using a tMap.

Hope I answered your query 🙂

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