topic Extended IntervalMatch problem in QlikView https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216790#M70065 <HTML><HEAD></HEAD><BODY><P>You don't want the extended syntax here. The extended syntax is telling the system to merge the two tables based on IPNUmber (in Start/End range) and LocID. But there's no LocID on the Session table, so the merge doesn't work, and wasn't what you wanted anyway.</P><P>All you want to merge on is the IPNumber vs. the Start and End. That's just a regular syntax. To get the LocId back onto the Session table, you'll need a second join.</P><P style="padding-left:30px;">LEFT JOIN ([Session])<BR />INTERVALMATCH (IPNumber)<BR />LOAD<BR /> Start<BR />,End<BR />RESIDENT [IPLocation]<BR />;<BR />LEFT JOIN ([Session])<BR />LOAD *<BR />RESIDENT [IPLocation]<BR />;</P></BODY></HTML> Fri, 16 Apr 2010 19:54:27 GMT johnw 2010-04-16T19:54:27Z Extended IntervalMatch problem https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216789#M70064 <HTML><HEAD></HEAD><BODY><P>What is the problem with this example?</P></BODY></HTML> Fri, 16 Apr 2010 19:24:05 GMT https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216789#M70064 2010-04-16T19:24:05Z Extended IntervalMatch problem https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216790#M70065 <HTML><HEAD></HEAD><BODY><P>You don't want the extended syntax here. The extended syntax is telling the system to merge the two tables based on IPNUmber (in Start/End range) and LocID. But there's no LocID on the Session table, so the merge doesn't work, and wasn't what you wanted anyway.</P><P>All you want to merge on is the IPNumber vs. the Start and End. That's just a regular syntax. To get the LocId back onto the Session table, you'll need a second join.</P><P style="padding-left:30px;">LEFT JOIN ([Session])<BR />INTERVALMATCH (IPNumber)<BR />LOAD<BR /> Start<BR />,End<BR />RESIDENT [IPLocation]<BR />;<BR />LEFT JOIN ([Session])<BR />LOAD *<BR />RESIDENT [IPLocation]<BR />;</P></BODY></HTML> Fri, 16 Apr 2010 19:54:27 GMT https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216790#M70065 johnw 2010-04-16T19:54:27Z Extended IntervalMatch problem https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216791#M70066 <HTML><HEAD></HEAD><BODY><P>Got it.</P><P>I thought, It should add LocID from range of Start/End for the IPNumber.</P><P>Thank you very much.</P></BODY></HTML> Fri, 16 Apr 2010 21:09:51 GMT https://community.qlik.com/t5/QlikView/Extended-IntervalMatch-problem/m-p/216791#M70066 2010-04-16T21:09:51Z