topic Re: How to achive from one Date to multiple dates in Talend Studio

How to achive from one Date to multiple dates

Anonymous — Sat, 16 Nov 2024 09:48:28 GMT

sourcetarget

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

TRF — Tue, 09 May 2017 19:13:58 GMT

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 — Thu, 11 May 2017 04:47:56 GMT

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

Anonymous — Thu, 11 May 2017 13:39:48 GMT

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 — Thu, 11 May 2017 17:07:26 GMT

thank u very much i will try and let u know

TRF — Thu, 11 May 2017 17:52:05 GMT

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 — Thu, 11 May 2017 19:37:02 GMT

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