Split Dates and group by another column

Six Stars

Split Dates and group by another column

Hello All,

 

I have data as below

EmpID .     start .           end

12825610/04/1915/04/19
12825715/04/1925/04/19
   

 

I am trying to get the output as 

EmpID         start            end              Date 

12825610/04/1915/04/1910/04/19
12825610/04/1915/04/1911/04/19
12825610/04/1915/04/1912/04/19
12825610/04/1915/04/1913/04/19
12825610/04/1915/04/1914/04/19
12825610/04/1915/04/1915/04/19
12825715/04/1920/04/1915/04/19
12825715/04/1920/04/1916/04/19
12825715/04/1920/04/1917/04/19
12825715/04/1920/04/1918/04/19
12825715/04/1920/04/1919/04/19
12825715/04/1920/04/1920/04/19

 

The flow that i am working currently is 

 

tRowGenerator --> tJavaRow --> tFlowToIterate --> tJavaFlex --> tLogRow

Screen Shot 2019-04-30 at 7.18.55 AM.png

 

tJavaRow:- 

Screen Shot 2019-04-30 at 1.46.38 PM.png

 

tJavaflex:-

Screen Shot 2019-04-30 at 1.47.33 PM.png

 

Output:-

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

 

Can anyone please guide me where i am going wrong.

 

Any help Please.

Mohan V.

 


Accepted Solutions
Highlighted
Eleven Stars

Re: Split Dates and group by another column

Connect tFlowtoIterate and tJavaFlex using Link Iterator instead of onComponentOK

Regards
Abhishek KUMAR

All Replies
Highlighted
Eleven Stars

Re: Split Dates and group by another column

Connect tFlowtoIterate and tJavaFlex using Link Iterator instead of onComponentOK

Regards
Abhishek KUMAR

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now