topic Load from load VS join. in QlikView https://community.qlik.com/t5/QlikView/Load-from-load-VS-join/m-p/287009#M1190499 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P></P><P>I can build a table and add columns to this using one of this two methods:</P><P></P><P>method 1:</P><P>Load *,</P><P>calculated_field1;</P><P>load *,</P><P>calculated_field2;</P><P>load *</P><P>resident atable;</P><P></P><P>method 2:</P><P>load *</P><P>resident atable;</P><P>join</P><P>load key_field,</P><P>calculated_field1</P><P>resident atable;</P><P>join</P><P>load key_field,</P><P>calculated_field2</P><P>resident atable;</P><P></P><P></P><P>Is there any advantage using any of this over the other?? maybe speed or memory usage??</P></BODY></HTML> Fri, 19 Aug 2011 17:38:53 GMT 2011-08-19T17:38:53Z Load from load VS join. https://community.qlik.com/t5/QlikView/Load-from-load-VS-join/m-p/287009#M1190499 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P></P><P>I can build a table and add columns to this using one of this two methods:</P><P></P><P>method 1:</P><P>Load *,</P><P>calculated_field1;</P><P>load *,</P><P>calculated_field2;</P><P>load *</P><P>resident atable;</P><P></P><P>method 2:</P><P>load *</P><P>resident atable;</P><P>join</P><P>load key_field,</P><P>calculated_field1</P><P>resident atable;</P><P>join</P><P>load key_field,</P><P>calculated_field2</P><P>resident atable;</P><P></P><P></P><P>Is there any advantage using any of this over the other?? maybe speed or memory usage??</P></BODY></HTML> Fri, 19 Aug 2011 17:38:53 GMT https://community.qlik.com/t5/QlikView/Load-from-load-VS-join/m-p/287009#M1190499 2011-08-19T17:38:53Z