topic ApplyMap() with multiple columns in the lookup file? in QlikView https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494919#M185113 <HTML><HEAD></HEAD><BODY><P>Hi, how do I use ApplyMap with multiple columns in the lookup file?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MappingIdLkup</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Category</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Agreement</STRONG></TH></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Exchange Traded</TD><TD style="padding: 2px;">Yes</TD></TR><TR><TD style="padding: 2px;">1002</TD><TD style="padding: 2px;">Over the Counter</TD><TD style="padding: 2px;">No</TD></TR><TR><TD style="padding: 2px;">1003</TD><TD style="padding: 2px;">Exotics</TD><TD style="padding: 2px;">No</TD></TR><TR><TD style="padding: 2px;">1004</TD><TD style="padding: 2px;">Exchange Traded</TD><TD style="padding: 2px;">Yes</TD></TR><TR><TD style="padding: 2px;">1005</TD><TD style="padding: 2px;">Exchange Traded</TD><TD style="padding: 2px;">Yes</TD></TR></TBODY></TABLE><P></P><P>I want to map ID and pull in both Category and Agreement as two columns.&nbsp; But I don't want to have to use two separate Lookup files.</P><P></P><P>Is there an option in ApplyMap() that tells it to look in col1, col2, etc. when pulling in data?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Nov 2013 17:32:10 GMT 2013-11-26T17:32:10Z ApplyMap() with multiple columns in the lookup file? https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494919#M185113 <HTML><HEAD></HEAD><BODY><P>Hi, how do I use ApplyMap with multiple columns in the lookup file?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MappingIdLkup</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Category</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Agreement</STRONG></TH></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Exchange Traded</TD><TD style="padding: 2px;">Yes</TD></TR><TR><TD style="padding: 2px;">1002</TD><TD style="padding: 2px;">Over the Counter</TD><TD style="padding: 2px;">No</TD></TR><TR><TD style="padding: 2px;">1003</TD><TD style="padding: 2px;">Exotics</TD><TD style="padding: 2px;">No</TD></TR><TR><TD style="padding: 2px;">1004</TD><TD style="padding: 2px;">Exchange Traded</TD><TD style="padding: 2px;">Yes</TD></TR><TR><TD style="padding: 2px;">1005</TD><TD style="padding: 2px;">Exchange Traded</TD><TD style="padding: 2px;">Yes</TD></TR></TBODY></TABLE><P></P><P>I want to map ID and pull in both Category and Agreement as two columns.&nbsp; But I don't want to have to use two separate Lookup files.</P><P></P><P>Is there an option in ApplyMap() that tells it to look in col1, col2, etc. when pulling in data?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Nov 2013 17:32:10 GMT https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494919#M185113 2013-11-26T17:32:10Z Re: ApplyMap() with multiple columns in the lookup file? https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494920#M185114 <HTML><HEAD></HEAD><BODY><P>An workaround is concatenate your desired fields</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Category </SPAN>&amp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Agreement </SPAN>as Search</P><P>&nbsp;&nbsp;&nbsp; yourexpression</P><P>resident yourtable</P></BODY></HTML> Tue, 26 Nov 2013 17:35:19 GMT https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494920#M185114 Clever_Anjos 2013-11-26T17:35:19Z Re: ApplyMap() with multiple columns in the lookup file? https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494921#M185115 <HTML><HEAD></HEAD><BODY><P>No option like this. </P><P>You can use two maps or maybe a join instead.</P></BODY></HTML> Tue, 26 Nov 2013 17:40:40 GMT https://community.qlik.com/t5/QlikView/ApplyMap-with-multiple-columns-in-the-lookup-file/m-p/494921#M185115 swuehl 2013-11-26T17:40:40Z