Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Split Dates and group by another column

Hello All,

 

I have data as below

EmpID .     start .           end

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

 

I am trying to get the output as 

EmpID         start            end              Date 

128256 10/04/19 15/04/19 10/04/19
128256 10/04/19 15/04/19 11/04/19
128256 10/04/19 15/04/19 12/04/19
128256 10/04/19 15/04/19 13/04/19
128256 10/04/19 15/04/19 14/04/19
128256 10/04/19 15/04/19 15/04/19
128257 15/04/19 20/04/19 15/04/19
128257 15/04/19 20/04/19 16/04/19
128257 15/04/19 20/04/19 17/04/19
128257 15/04/19 20/04/19 18/04/19
128257 15/04/19 20/04/19 19/04/19
128257 15/04/19 20/04/19 20/04/19

 

The flow that i am working currently is 

 

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

0683p000009M4xJ.png

 

tJavaRow:- 

0683p000009M4xO.png

 

tJavaflex:-

0683p000009M4vJ.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.

 

Labels (3)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

Connect tFlowtoIterate and tJavaFlex using Link Iterator instead of onComponentOK

View solution in original post

1 Reply
akumar2301
Specialist II
Specialist II

Connect tFlowtoIterate and tJavaFlex using Link Iterator instead of onComponentOK