https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idi-p/1874714 <P>It would be great if we could have mapping table with one <STRONG>key column</STRONG> and n <STRONG>value column</STRONG> (instead of only one currently)</P> <P>Of course, a new parameter should be added in the applymap function to define which<STRONG> value column</STRONG> should be used .</P> <P>&nbsp;</P> <P>Example</P> <P>mapping</P> <P>mMultiple:</P> <P>key, value1, value2, value3</P> <P>1, AA, BB, CC</P> <P>2, AA, DD, EE</P> <P>...</P> <P>&nbsp;</P> <P>applymap('mMultiple', myKey,value1) as field1,</P> <P>applymap('mMultiple', myKey,value2) as field2,</P> Thu, 23 Dec 2021 14:15:48 GMT colombari-g 2021-12-23T14:15:48Z https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idc-p/1879813#M8206 <P>Is this functionality already provided by the Lookup() function?</P> <P><A href="https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/LookUp.htm" target="_blank">https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/LookUp.htm</A></P> <P>Lookup is not as fast as ApplyMap, but it does provide the ability to specify the field.&nbsp;</P> Tue, 11 Jan 2022 22:46:22 GMT https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idc-p/1879813#M8206 rwunderlich 2022-01-11T22:46:22Z https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idc-p/2118888#M16169 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/280221" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Mon, 18 Sep 2023 17:29:21 GMT https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idc-p/2118888#M16169 Meghann_MacDonald 2023-09-18T17:29:21Z https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idc-p/2118889#M16170 Mon, 18 Sep 2023 17:29:22 GMT https://community.qlik.com/t5/Suggest-an-Idea/Mapping-table-with-n-columns/idc-p/2118889#M16170 Ideation 2023-09-18T17:29:22Z