Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

talend job

Hello Everyone,

 

can you please help me the below scenario.

 

Input

name             no           startdate         enddate

harry              10           01-05-2018      05-05-2018

sumanth         20           06-05-2018      07-05-2018

 

Output

name                no         date

harry                10        01-05-2018

harry                10        02-05-2018

harry                10        03-05-2018

harry                10        04-05-2018

harry                10        05-05-2018

sumanth          20        06-05-2018

sumanth          20        07-05-2018

 

can any one please share solution.

 

Thanks

SumanthKumar

 
 
 
Labels (2)
1 Reply
vapukov
Master II
Master II

- read input data (flow)

- tFlowToIterate - store all to variables

- loop until StartDate <= EndDate

- output data, use StartDate as date

- increment StartDate +1 day

that all