Split Dates and group by another column

Highlighted
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

View solution in original post


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

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download 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