How to achive from one Date to multiple dates

[Anonymous]

sourcetarget

By using this source file how to get multiple dates in order

[TRF]

Using TalendDate routines (https://help.talend.com/display/TalendOpenStudioforBigDataUserGuide520EN/10.5+TalendDate+Routines) compute the difference between start and end date, then tLoop from 1 to nb_days, add i to start date giving current date. You got what you need for your job.

[Anonymous]

Can you please help me.I tried with tjava and tloop but not able to do

[Anonymous]

This is actually a bit tricky.

I did some rough work and came up with this solution. Hope it gives you some idea.

You have to first calculate the difference between the start date and end date and store it in a context value.

Then for each row, you have to use the tLoop component to generate the missing dates.

The layout of the job,

tMap12 Config,

tJava Code,

tLoop Config,

tFixedFlow Component Config,

tMap13 config,

Here we have two contexts created. One is the context Loop of integer datatype for storing the max loop number.

Other one is the context startDate of datatype date for storing the starting date.

Remember to check the append option if your output is a file.

There might be a better way to do this. Hopefully this template gets you started on what you want.

[Anonymous]

thank u very much i will try and let u know

[TRF]

Hi,

Thanks to @ArvinRapt to have detailed the solution I proposed.

I don't think it's too much tricky.

Maybe you can change tJava by tSetGlobalVar and use global variables instead of context variables, but it's a detail.

Also I think you can move the operation made in the tMap into the tFixedFlowInput component to comple the startDate field.

Regards,

[Anonymous]

@TRF Agreed. Those two suggestions make the job easier on the eyes.