Join two entries rows ( Start time and End time) as a single row in Talend

[Reims]

I have Data coming from a MS SQL Database, it is concerning the the working hours of employees.

The problem is that, the start time and the end time are stored as 2 different entries, so when the employee comes, he scans his badge and this is considered arrival time, and when he leaves, he scans his badge again and this is considered departure time. There is one column that helps to make the difference between the start and the end time (CodeNr column : B1 = StartTime, B2 = EndTime)

so this is how my Table looks like

Now i need this data as a single entry, in Talend oder from the Database,

so that should looks like

What to use in order to achieve this please (specially in Talend and when to complicate than in MS SQL)?

[manodwhb]

@not specified not specified​ , til the End Minute you can get it by using tAggregaterow ,if the data needs to be sort then use tSortrow component before tAggregaterow and the use tMap or tjavarow to calculate Duration hours and Minutes.

Thanks,

Manohar

[vikramk]

do you think we can achieve this with tAggregaterow, because the he needs the start and end date into different columns, right now they are in same column, could you elaborate more how to do this