topic IntervalMatch in QlikView https://community.qlik.com/t5/QlikView/IntervalMatch/m-p/730439#M261636 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12.0pt;">I have two tables</SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;">Machine Maintenance Due to Fault</SPAN></P><P></P><P style="margin-left: 36.0pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">MachineMaintenance:<BR /> </SPAN><SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"><STRONG>Load</STRONG></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Inline</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> Machine,Problem Start,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Problem End<BR /> M1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/06/2014 12:00,&nbsp;&nbsp;&nbsp; 12/06/2014 14:00<BR /> M2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/06/2014 10:00,&nbsp;&nbsp;&nbsp; 13/06/2014 13:00<BR /> M3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/06/2014 14:00,&nbsp;&nbsp;&nbsp; 14/06/2014 14:30<BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; </SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;">Machine Work</SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">MachineWork:<BR /> </SPAN><SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"><STRONG>Load</STRONG></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Inline</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> Machine,&nbsp;&nbsp; WorkOrder, From,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To<BR /> M1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/06/2014 10:00,&nbsp;&nbsp;&nbsp; 12/06/2014 18:00<BR /> M1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/06/2014 20:00,&nbsp;&nbsp;&nbsp; 13/06/2014 22:00<BR /> M2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/06/2014 08:00,&nbsp;&nbsp;&nbsp; 13/06/2014 15:55<BR /> M2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/06/2014 16:00,&nbsp;&nbsp;&nbsp; 14/06/2014 23:55<BR /> M3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/06/2014 13:00,&nbsp;&nbsp;&nbsp; 14/06/2014 16:00<BR /> M3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 105,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/06/2014 18:00,&nbsp;&nbsp;&nbsp; 14/06/2014 20:00<BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; </SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">I need to know the below output which shows against which work order, the machine has got fault.</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">The output table looks like below…</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="418"><TBODY><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Machine</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Problem Start</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Problem End</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>WorkOrder</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M1</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>12/06/2014 12:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>12/06/2014 14:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>100</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M2</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>13/06/2014 10:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>13/06/2014 13:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>102</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M3</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>14/06/2014 14:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>14/06/2014 14:30</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>104</STRONG></SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Appreciate your quick response</P></BODY></HTML> Mon, 23 Jun 2014 14:51:56 GMT MK_QSL 2014-06-23T14:51:56Z IntervalMatch https://community.qlik.com/t5/QlikView/IntervalMatch/m-p/730439#M261636 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12.0pt;">I have two tables</SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;">Machine Maintenance Due to Fault</SPAN></P><P></P><P style="margin-left: 36.0pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">MachineMaintenance:<BR /> </SPAN><SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"><STRONG>Load</STRONG></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Inline</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> Machine,Problem Start,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Problem End<BR /> M1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/06/2014 12:00,&nbsp;&nbsp;&nbsp; 12/06/2014 14:00<BR /> M2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/06/2014 10:00,&nbsp;&nbsp;&nbsp; 13/06/2014 13:00<BR /> M3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/06/2014 14:00,&nbsp;&nbsp;&nbsp; 14/06/2014 14:30<BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; </SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt; line-height: 1.5em;">Machine Work</SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">MachineWork:<BR /> </SPAN><SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"><STRONG>Load</STRONG></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Inline</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> Machine,&nbsp;&nbsp; WorkOrder, From,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To<BR /> M1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/06/2014 10:00,&nbsp;&nbsp;&nbsp; 12/06/2014 18:00<BR /> M1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/06/2014 20:00,&nbsp;&nbsp;&nbsp; 13/06/2014 22:00<BR /> M2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/06/2014 08:00,&nbsp;&nbsp;&nbsp; 13/06/2014 15:55<BR /> M2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/06/2014 16:00,&nbsp;&nbsp;&nbsp; 14/06/2014 23:55<BR /> M3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/06/2014 13:00,&nbsp;&nbsp;&nbsp; 14/06/2014 16:00<BR /> M3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 105,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/06/2014 18:00,&nbsp;&nbsp;&nbsp; 14/06/2014 20:00<BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; </SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">I need to know the below output which shows against which work order, the machine has got fault.</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">The output table looks like below…</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="418"><TBODY><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Machine</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Problem Start</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Problem End</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>WorkOrder</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M1</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>12/06/2014 12:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>12/06/2014 14:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>100</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M2</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>13/06/2014 10:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>13/06/2014 13:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>102</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M3</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>14/06/2014 14:00</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="125"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>14/06/2014 14:30</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" width="91"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>104</STRONG></SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Appreciate your quick response</P></BODY></HTML> Mon, 23 Jun 2014 14:51:56 GMT https://community.qlik.com/t5/QlikView/IntervalMatch/m-p/730439#M261636 MK_QSL 2014-06-23T14:51:56Z Re: IntervalMatch https://community.qlik.com/t5/QlikView/IntervalMatch/m-p/730440#M261637 <HTML><HEAD></HEAD><BODY><P>Sorted out myself...</P></BODY></HTML> Mon, 23 Jun 2014 15:15:33 GMT https://community.qlik.com/t5/QlikView/IntervalMatch/m-p/730440#M261637 MK_QSL 2014-06-23T15:15:33Z