Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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
Creator III
Creator III

- 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