topic How to replace join by applymap in QlikView https://community.qlik.com/t5/QlikView/How-to-replace-join-by-applymap/m-p/965355#M946245 <HTML><HEAD></HEAD><BODY><P>How to replace join by applymap ?</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14507019964399026" jivemacro_uid="_14507019964399026"> <P>load *</P> <P>FROM</P> <P>E:\QVD\QVD\VenteFull.qvd</P> <P>(qvd);</P> <P>LEFT&nbsp; JOIN(Vente)</P> <P>IntervalMatch (datecol, [Code Site], [Code Article])</P> <P>LOAD DISTINCT DateDebutPermanent, DateFinPermanent, [Code Site], [Code Article]</P> <P> resident&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Permanent</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT JOIN (Vente)</P> <P>LOAD *</P> <P>RESIDENT Permanent;</P> </PRE></BODY></HTML> Mon, 21 Dec 2015 12:46:39 GMT Anonymous 2015-12-21T12:46:39Z How to replace join by applymap https://community.qlik.com/t5/QlikView/How-to-replace-join-by-applymap/m-p/965355#M946245 <HTML><HEAD></HEAD><BODY><P>How to replace join by applymap ?</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14507019964399026" jivemacro_uid="_14507019964399026"> <P>load *</P> <P>FROM</P> <P>E:\QVD\QVD\VenteFull.qvd</P> <P>(qvd);</P> <P>LEFT&nbsp; JOIN(Vente)</P> <P>IntervalMatch (datecol, [Code Site], [Code Article])</P> <P>LOAD DISTINCT DateDebutPermanent, DateFinPermanent, [Code Site], [Code Article]</P> <P> resident&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Permanent</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT JOIN (Vente)</P> <P>LOAD *</P> <P>RESIDENT Permanent;</P> </PRE></BODY></HTML> Mon, 21 Dec 2015 12:46:39 GMT https://community.qlik.com/t5/QlikView/How-to-replace-join-by-applymap/m-p/965355#M946245 Anonymous 2015-12-21T12:46:39Z Re: How to replace join by applymap https://community.qlik.com/t5/QlikView/How-to-replace-join-by-applymap/m-p/965356#M946246 <HTML><HEAD></HEAD><BODY><P>Dunno.</P><P></P><P>How many columns from Permanent are being joined into Vente? Every additional column needs a separate mapping table and applymap call. Are you really sure you want to replace this compact piece of script code? Too many records in table Vente?</P></BODY></HTML> Mon, 21 Dec 2015 12:54:27 GMT https://community.qlik.com/t5/QlikView/How-to-replace-join-by-applymap/m-p/965356#M946246 Peter_Cammaert 2015-12-21T12:54:27Z