Join two row into 1 row

[Anonymous]

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|

[TRF]

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.

[Anonymous · Accepted solution]

@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