topic Re: concatenate in QlikView https://community.qlik.com/t5/QlikView/concatenate/m-p/454753#M169663 <HTML><HEAD></HEAD><BODY><P>Hey</P><P></P><P>you must be right, after copying the column names from the top it worked. Thank you</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Thu, 21 Feb 2013 08:36:20 GMT 2013-02-21T08:36:20Z concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/454751#M169661 <HTML><HEAD></HEAD><BODY><P>Hi I want to create a table in qv and I have 3 excel files I want to concatenate but it always ignore the last excel file it just doesnt do a concatenate load.</P><P>does anyone know why??</P><P></P><P>please help me</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Wed, 20 Feb 2013 12:26:26 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/454751#M169661 2013-02-20T12:26:26Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/454752#M169662 <HTML><HEAD></HEAD><BODY><P>Probably because the field names and number of fields aren't exactly the same. QV is case sensitive so a capital letter can make a field name different. You can force concatenating by using the concatenate keyword in front of load</P><P></P><P>T1:</P><P>load * from abc.qvd (qvd);</P><P></P><P>concatenate (T1) load * from cde.qvd (qvd);</P><P></P><P><EM>(works the same for excel files in case you're wondering)</EM></P></BODY></HTML> Wed, 20 Feb 2013 12:34:39 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/454752#M169662 Gysbert_Wassenaar 2013-02-20T12:34:39Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/454753#M169663 <HTML><HEAD></HEAD><BODY><P>Hey</P><P></P><P>you must be right, after copying the column names from the top it worked. Thank you</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Thu, 21 Feb 2013 08:36:20 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/454753#M169663 2013-02-21T08:36:20Z