topic Re: Split Dates and group by another column in Data Quality https://community.qlik.com/t5/Data-Quality/Split-Dates-and-group-by-another-column/m-p/2276244#M3152 <P>Connect tFlowtoIterate and tJavaFlex using Link Iterator instead of onComponentOK</P> Tue, 30 Apr 2019 10:00:54 GMT akumar2301 2019-04-30T10:00:54Z Split Dates and group by another column https://community.qlik.com/t5/Data-Quality/Split-Dates-and-group-by-another-column/m-p/2276243#M3151 <P>Hello All,</P> <P>&nbsp;</P> <P>I have data as below</P> <P>EmpID .&nbsp; &nbsp; &nbsp;start .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;end</P> <TABLE> <TBODY> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>25/04/19</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I am trying to get the output as&nbsp;</P> <P>EmpID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;start&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date&nbsp;</P> <TABLE> <TBODY> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> <TD>10/04/19</TD> </TR> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> <TD>11/04/19</TD> </TR> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> <TD>12/04/19</TD> </TR> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> <TD>13/04/19</TD> </TR> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> <TD>14/04/19</TD> </TR> <TR> <TD>128256</TD> <TD>10/04/19</TD> <TD>15/04/19</TD> <TD>15/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>20/04/19</TD> <TD>15/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>20/04/19</TD> <TD>16/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>20/04/19</TD> <TD>17/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>20/04/19</TD> <TD>18/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>20/04/19</TD> <TD>19/04/19</TD> </TR> <TR> <TD>128257</TD> <TD>15/04/19</TD> <TD>20/04/19</TD> <TD>20/04/19</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The flow that i am working currently is&nbsp;</P> <P>&nbsp;</P> <P>tRowGenerator --&gt; tJavaRow --&gt; tFlowToIterate --&gt; tJavaFlex --&gt; tLogRow</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2019-04-30 at 7.18.55 AM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4xJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150675iB5D91E4DDF9368D1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4xJ.png" alt="0683p000009M4xJ.png" /></span></SPAN></P> <P>&nbsp;</P> <P>tJavaRow:-&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2019-04-30 at 1.46.38 PM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4xO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138128i1352C43FDDEF2A38/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4xO.png" alt="0683p000009M4xO.png" /></span></SPAN></P> <P>&nbsp;</P> <P>tJavaflex:-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2019-04-30 at 1.47.33 PM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4vJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141261i67B983F019B9B691/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4vJ.png" alt="0683p000009M4vJ.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Output:-</P> <P class="p1"><STRONG>For input string: EmpID</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|15-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|16-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|17-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|18-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|19-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|20-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|21-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|22-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|23-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|24-04-2019|128257</STRONG></P> <P class="p2"><STRONG>25-04-2019|15-04-2019|25-04-2019|128257</STRONG></P> <P class="p2"><STRONG>[statistics] disconnected</STRONG></P> <P class="p2">&nbsp;</P> <P class="p2">Can anyone please guide me where i am going wrong.</P> <P class="p2">&nbsp;</P> <P class="p2">Any help Please.</P> <P class="p2">Mohan V.</P> <P>&nbsp;</P> Sat, 16 Nov 2024 05:57:52 GMT https://community.qlik.com/t5/Data-Quality/Split-Dates-and-group-by-another-column/m-p/2276243#M3151 Anonymous 2024-11-16T05:57:52Z Re: Split Dates and group by another column https://community.qlik.com/t5/Data-Quality/Split-Dates-and-group-by-another-column/m-p/2276244#M3152 <P>Connect tFlowtoIterate and tJavaFlex using Link Iterator instead of onComponentOK</P> Tue, 30 Apr 2019 10:00:54 GMT https://community.qlik.com/t5/Data-Quality/Split-Dates-and-group-by-another-column/m-p/2276244#M3152 akumar2301 2019-04-30T10:00:54Z