Split dates group by Employee ID

Anonymous — Sat, 16 Nov 2024 05:58:02 GMT

Hello All,

I was trying few different data transformations on dates along with employee id data.

Before that, I was able to get the dates between start and end using below flow.

tRowGenerator:-

tJavaRow:-

tJavaFlex:-

The output that i am getting after this is:-

[statistics] connecting to socket on port 3520

[statistics] connected

30-04-2019|25-04-2019|25-04-2019

30-04-2019|25-04-2019|26-04-2019

30-04-2019|25-04-2019|27-04-2019

30-04-2019|25-04-2019|28-04-2019

30-04-2019|25-04-2019|29-04-2019

30-04-2019|25-04-2019|30-04-2019

[statistics] disconnected

Then i tried to do add emp id's to the same and my input data looks like below.

Data:-

EmpID . start end

128256	10/04/19	15/04/19
128257	15/04/19	25/04/19

The Output that iam expecting is:-

I tried the same way as above flow,

But i couldnt get the output as i am expecting.

Output:-

[statistics] connected

For input string: "EmpID"

25-04-2019|15-04-2019|15-04-2019|128257

25-04-2019|15-04-2019|16-04-2019|128257

25-04-2019|15-04-2019|17-04-2019|128257

25-04-2019|15-04-2019|18-04-2019|128257

25-04-2019|15-04-2019|19-04-2019|128257

25-04-2019|15-04-2019|20-04-2019|128257

25-04-2019|15-04-2019|21-04-2019|128257

25-04-2019|15-04-2019|22-04-2019|128257

25-04-2019|15-04-2019|23-04-2019|128257

25-04-2019|15-04-2019|24-04-2019|128257

25-04-2019|15-04-2019|25-04-2019|128257

[statistics] disconnected

The dates are not getting differentiated by EmpID's

How can i get this.

Please help.

Thanks in Advance.

Mohan V.

Re: Split dates group by Employee ID

Anonymous — Mon, 27 May 2019 07:46:39 GMT

Hi Mohan,
I think you need a tLoop component to achieve it, the job design looks like:
tFileInputDelimited--main-tFlowToIterate--iterate--tJava--oncomponentok--tLoop--iterate--tFixedFlowInput--main--tLogRow
on tJava: populate the number of days between startDate to endDates, this number will be the variable value of To parameter on tLoop component.

tFixedFlowInput: generate the current record.

Can you try and let me know if you need more help?

Regards
Shong

topic Split dates group by Employee ID in Talend Studio

Split dates group by Employee ID

Re: Split dates group by Employee ID