topic Re: search and map data in QlikView https://community.qlik.com/t5/QlikView/search-and-map-data/m-p/767206#M472945 <HTML><HEAD></HEAD><BODY><P>Just Resident load&nbsp; temp table and derieve the minumum() of the field.</P><P>Now you can easily map the minimum based on the valid Key in your data model,</P><P>by using <SPAN style="text-decoration: underline;"><STRONG>Applymap() oe Left Join()</STRONG></SPAN></P></BODY></HTML> Wed, 03 Dec 2014 11:13:50 GMT sujeetsingh 2014-12-03T11:13:50Z search and map data https://community.qlik.com/t5/QlikView/search-and-map-data/m-p/767205#M472944 <HTML><HEAD></HEAD><BODY><P>Hello, i'm sure you can help me with this.</P><P></P><P>i've got a loadscript with some tables - lets call them "Sales" and "Customer". In Customer the Key-Field is No_.</P><P></P><P>Now i'd like to search for the min([Posting Date]) of every Customer.No_ in the Sales-Table. The found result should be added to the Customer-Table, the name of the field is "[first bought]"</P><P></P><P>can you explain me how this works in the loadscript?</P><P></P><P>Thank you!</P><P></P><P>Best,</P><P>Tim</P></BODY></HTML> Wed, 03 Dec 2014 11:09:32 GMT https://community.qlik.com/t5/QlikView/search-and-map-data/m-p/767205#M472944 2014-12-03T11:09:32Z Re: search and map data https://community.qlik.com/t5/QlikView/search-and-map-data/m-p/767206#M472945 <HTML><HEAD></HEAD><BODY><P>Just Resident load&nbsp; temp table and derieve the minumum() of the field.</P><P>Now you can easily map the minimum based on the valid Key in your data model,</P><P>by using <SPAN style="text-decoration: underline;"><STRONG>Applymap() oe Left Join()</STRONG></SPAN></P></BODY></HTML> Wed, 03 Dec 2014 11:13:50 GMT https://community.qlik.com/t5/QlikView/search-and-map-data/m-p/767206#M472945 sujeetsingh 2014-12-03T11:13:50Z