Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
VijayTalend
Contributor
Contributor

mapping query

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

Labels (3)
0 Replies