Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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