topic Re: what is mapping load? in QlikView https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049794#M923764 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid rgb(0, 0, 0); width: 316px; height: 149px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">EMPID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DeptId</TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD>101</TD><TD>Kiran</TD><TD>10</TD></TR><TR><TD>102</TD><TD>Sunny</TD><TD>20</TD></TR><TR><TD>103</TD><TD>Kumar</TD><TD>30</TD></TR><TR><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid rgb(0, 0, 0); width: 220px; height: 8px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DeptId</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DName</TH></TR><TR><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">IT</TD></TR><TR><TD>20</TD><TD>MBA</TD></TR><TR><TD>30</TD><TD>MCA</TD></TR></TBODY></TABLE><P></P><P></P><P>Consider you have two tables and loaded them into Qlikview and the two tables with be associated with DeptId, now if I want to load the Dname values into the first table by removing the second table completely from the data model then we use mapping load at this situations as below</P><P></P><P>Dept:</P><P>Mapping Load</P><P>DeptId,</P><P>Dname</P><P>from Dept;</P><P></P><P>Emp:</P><P>Load</P><P>EMPID,</P><P>Name,</P><P>DeptID,</P><P>Applymap('Dept',DeptID) as Dname</P><P>from emps;</P><P></P><P>The second table while loading will bring all the Dnames from the first table to the second table and after loading you won't find the first table in the data model.</P><P></P><P></P><P>There are some more advantages of using Applymap see the following link from Qlik Design group.</P><P><A href="https://community.qlik.com/qlik-blogpost/2756">Don't join - use Applymap instead</A></P><P></P><P>Hope it helps you</P><P></P><P>Kiran Kumar</P></BODY></HTML> Mon, 18 Apr 2016 12:12:28 GMT kkkumar82 2016-04-18T12:12:28Z what is mapping load? https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049790#M923760 <HTML><HEAD></HEAD><BODY><P>hi give me simple example for mapping load.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049790#M923760 2020-11-25T16:16:04Z Re: what is mapping load? https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049791#M923761 <HTML><HEAD></HEAD><BODY><P>See help:</P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/Mapping.htm?q=mapping" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/Mapping.htm?q=mapping">Mapping ‒ QlikView</A></P></BODY></HTML> Mon, 18 Apr 2016 11:36:57 GMT https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049791#M923761 oknotsen 2016-04-18T11:36:57Z Re: what is mapping load? https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049792#M923762 <HTML><HEAD></HEAD><BODY><P>Apply Map</P><P><A href="https://community.qlik.com/thread/210445">Create a Sub Group</A></P><P></P><P>Vikas</P></BODY></HTML> Mon, 18 Apr 2016 11:38:54 GMT https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049792#M923762 vikasmahajan 2016-04-18T11:38:54Z Re: what is mapping load? https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049793#M923763 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/message/436728">Re: MAPING LOAD,BINARY LOAD</A></P></BODY></HTML> Mon, 18 Apr 2016 11:44:24 GMT https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049793#M923763 Chanty4u 2016-04-18T11:44:24Z Re: what is mapping load? https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049794#M923764 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid rgb(0, 0, 0); width: 316px; height: 149px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">EMPID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DeptId</TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD>101</TD><TD>Kiran</TD><TD>10</TD></TR><TR><TD>102</TD><TD>Sunny</TD><TD>20</TD></TR><TR><TD>103</TD><TD>Kumar</TD><TD>30</TD></TR><TR><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid rgb(0, 0, 0); width: 220px; height: 8px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DeptId</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DName</TH></TR><TR><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">IT</TD></TR><TR><TD>20</TD><TD>MBA</TD></TR><TR><TD>30</TD><TD>MCA</TD></TR></TBODY></TABLE><P></P><P></P><P>Consider you have two tables and loaded them into Qlikview and the two tables with be associated with DeptId, now if I want to load the Dname values into the first table by removing the second table completely from the data model then we use mapping load at this situations as below</P><P></P><P>Dept:</P><P>Mapping Load</P><P>DeptId,</P><P>Dname</P><P>from Dept;</P><P></P><P>Emp:</P><P>Load</P><P>EMPID,</P><P>Name,</P><P>DeptID,</P><P>Applymap('Dept',DeptID) as Dname</P><P>from emps;</P><P></P><P>The second table while loading will bring all the Dnames from the first table to the second table and after loading you won't find the first table in the data model.</P><P></P><P></P><P>There are some more advantages of using Applymap see the following link from Qlik Design group.</P><P><A href="https://community.qlik.com/qlik-blogpost/2756">Don't join - use Applymap instead</A></P><P></P><P>Hope it helps you</P><P></P><P>Kiran Kumar</P></BODY></HTML> Mon, 18 Apr 2016 12:12:28 GMT https://community.qlik.com/t5/QlikView/what-is-mapping-load/m-p/1049794#M923764 kkkumar82 2016-04-18T12:12:28Z