topic Re: script for applymap to get first row in QlikView https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497624#M186013 <HTML><HEAD></HEAD><BODY><P>I suggest you make sure there are only one possible matching field by loading only unique key fields in your mapping table.</P></BODY></HTML> Fri, 08 Nov 2013 10:05:05 GMT 2013-11-08T10:05:05Z script for applymap to get first row https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497623#M186012 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>When I am doing apply map in script side then there are multiple records against one value but I want to do first row mapping and get value against that. So how to write script for that.<A href="https://community.qlik.com/qlik-users/1">Administrator</A></P></BODY></HTML> Fri, 08 Nov 2013 09:50:55 GMT https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497623#M186012 2013-11-08T09:50:55Z Re: script for applymap to get first row https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497624#M186013 <HTML><HEAD></HEAD><BODY><P>I suggest you make sure there are only one possible matching field by loading only unique key fields in your mapping table.</P></BODY></HTML> Fri, 08 Nov 2013 10:05:05 GMT https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497624#M186013 2013-11-08T10:05:05Z Re: script for applymap to get first row https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497625#M186014 <HTML><HEAD></HEAD><BODY><P>Hi Pankaj,</P><P></P><P>You should implement it in your mapping load. Group by the ID to obtain an unique value for each one. These are some options...</P><P></P><UL><LI>Máx or Min Value.</LI><LI>Rank by number of rows and select the most common value.</LI><LI>Take the value of the first record for each ID using the rownum() function.</LI></UL></BODY></HTML> Fri, 08 Nov 2013 10:06:10 GMT https://community.qlik.com/t5/QlikView/script-for-applymap-to-get-first-row/m-p/497625#M186014 2013-11-08T10:06:10Z