topic Re: Difference between ADD and Concatenate? in QlikView https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497365#M1148196 <HTML><HEAD></HEAD><BODY><P>Thanks for response.</P></BODY></HTML> Fri, 31 Jul 2015 13:24:48 GMT nihhalmca 2015-07-31T13:24:48Z Difference between ADD and Concatenate? https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497363#M1148194 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Could you people say exact difference b/w ADD and Concatenate</P><P></P><P>Thanks in Advance,</P><P>Nihhal.</P></BODY></HTML> Fri, 21 Jun 2013 14:14:55 GMT https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497363#M1148194 nihhalmca 2013-06-21T14:14:55Z Re: Difference between ADD and Concatenate? https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497364#M1148195 <HTML><HEAD></HEAD><BODY><P>Concatenate</P><P>If two tables that are to be <A href="http://mce_host/mk:@MSITStoreC\Program%20Files\QlikView\English.chm:">concatenated</A> have different sets of <A href="http://mce_host/mk:@MSITStoreC\Program%20Files\QlikView\English.chm:">fields</A>, concatenation of two tables can still be forced with the <SPAN class="bold">concatenate</SPAN> prefix</P><P></P><P><IMG alt="concart.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/43110_concart.bmp" /></P><P></P><P>ADD</P><P>The <SPAN class="bold">add</SPAN> prefix can be added to any <A href="http://mce_host/mk:@MSITStoreC\Program%20Files\QlikView\English.chm:">load</A>, <A href="http://mce_host/mk:@MSITStoreC\Program%20Files\QlikView\English.chm:">select</A> or <A href="http://mce_host/mk:@MSITStoreC\Program%20Files\QlikView\English.chm:">map...using</A> statement in the script. It is only meaningful during <A href="http://mce_host/mk:@MSITStoreC\Program%20Files\QlikView\English.chm:">partial reloads</A>. During a partial reload the QlikView table, for which a table name is generated by the <SPAN class="bold">add load</SPAN>/<SPAN class="bold">add select</SPAN> statement (provided such a table exists), will be appended with the result of the <SPAN class="bold">add load/add select</SPAN> statement.</P></BODY></HTML> Fri, 21 Jun 2013 14:20:49 GMT https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497364#M1148195 2013-06-21T14:20:49Z Re: Difference between ADD and Concatenate? https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497365#M1148196 <HTML><HEAD></HEAD><BODY><P>Thanks for response.</P></BODY></HTML> Fri, 31 Jul 2015 13:24:48 GMT https://community.qlik.com/t5/QlikView/Difference-between-ADD-and-Concatenate/m-p/497365#M1148196 nihhalmca 2015-07-31T13:24:48Z