Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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