mapping query

[VijayTalend]

Hi,

I am using cMap for development. I have a requirement where I have to take Start time and Stop time from input file and prepare output where its distributed on hour basis.

In input file , I am getting standard start and end time.

Input is as follows -

ABC;12;2020-04-08T06:00:00;2020-04-08T09:00:00
ABC;14;2020-04-08T06:00:00;2020-04-08T09:00:00
ABC;16;2020-04-08T06:00:00;2020-04-08T09:00:00

Output should be as follows which take start time and increases it by 1 hour until Stop time is reached -

ABC;12;2020-04-08T06:00:00;2020-04-08T07:00:00
ABC;14;2020-04-08T07:00:00;2020-04-08T08:00:00
ABC;16;2020-04-08T08:00:00;2020-04-08T09:00:00

Can you please help to know how can I achieve it in Talend.

Regards