topic Re: Map two tables with ranges in QlikView https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293244#M1189895 <HTML><HEAD></HEAD><BODY><P> Many thanks Miguel,</P><P></P><P>It was a good exampel <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />, Now I'm back on the road again</P></BODY></HTML> Tue, 23 Aug 2011 11:51:38 GMT 2011-08-23T11:51:38Z Map two tables with ranges https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293241#M1189892 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two tables,</P><P>one with a list of AccoutsNo and Valus on each account</P><P>and another table with Acount Groups, AccountNoFrom, AccountNoTo</P><P>Now I don't know how to map this two together, Is there some one who have tip?</P><P></P><P>Many thanks in advance</P><P>Lars&nbsp; </P></BODY></HTML> Tue, 23 Aug 2011 11:16:09 GMT https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293241#M1189892 2011-08-23T11:16:09Z Map two tables with ranges https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293242#M1189893 <HTML><HEAD></HEAD><BODY><P> i dont know exactly but i think one of AccountNoFrom and&nbsp; AccountNoTo</P><P>will be used as key</P><P>which is linked with AccoutsNo</P></BODY></HTML> Tue, 23 Aug 2011 11:21:53 GMT https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293242#M1189893 SunilChauhan 2011-08-23T11:21:53Z Re: Map two tables with ranges https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293243#M1189894 <HTML><HEAD></HEAD><BODY><P>Hi Lars,</P><P></P><P>One solution would be using the IntervalMatch() load. You can find a working example in <A _jive_internal="true" href="https://community.qlik.com/thread/12152">this thread</A> among many other posts in the Community.</P><P></P><P>Hope that helps.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Tue, 23 Aug 2011 11:25:02 GMT https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293243#M1189894 Miguel_Angel_Baeyens 2011-08-23T11:25:02Z Re: Map two tables with ranges https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293244#M1189895 <HTML><HEAD></HEAD><BODY><P> Many thanks Miguel,</P><P></P><P>It was a good exampel <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />, Now I'm back on the road again</P></BODY></HTML> Tue, 23 Aug 2011 11:51:38 GMT https://community.qlik.com/t5/QlikView/Map-two-tables-with-ranges/m-p/293244#M1189895 2011-08-23T11:51:38Z