topic Re: Concatenate two columns in QlikView https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602121#M1106178 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Fri, 04 Apr 2014 11:50:39 GMT 2014-04-04T11:50:39Z Concatenate two columns https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602117#M1106172 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am trying to concatenate two columns to make one..</P><P>like</P><P></P><P>Col1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Col2</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</P><P>c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d</P><P>e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f</P><P></P><P>I have these two columns and values and i want to concatenate these two column to make one</P><P>like</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Col1</SPAN></P><P><SPAN style="font-size: 10pt;">a</SPAN></P><P><SPAN style="font-size: 10pt;">c</SPAN></P><P><SPAN style="font-size: 10pt;">e</SPAN></P><P><SPAN style="font-size: 10pt;">b</SPAN></P><P><SPAN style="font-size: 10pt;">d</SPAN></P><P><SPAN style="font-size: 10pt;">f</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Pls help...</SPAN></P><P><SPAN style="font-size: 10pt;">Thanks in advance...</SPAN><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Fri, 04 Apr 2014 11:27:40 GMT https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602117#M1106172 2014-04-04T11:27:40Z Re: Concatenate two columns https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602118#M1106174 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Load Col1 from tab1;</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Load Col2 as Col1 from tab1;</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Jagan</SPAN></P></BODY></HTML> Fri, 04 Apr 2014 11:29:46 GMT https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602118#M1106174 jagannalla 2014-04-04T11:29:46Z Re: Concatenate two columns https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602119#M1106176 <HTML><HEAD></HEAD><BODY><P>Hi Shivam,</P><P>Try to load each column as separate,</P><P><STRONG>SAMPLE</STRONG></P><P><STRONG>Load * Inline [</STRONG></P><P><STRONG>Col1</STRONG></P><P><STRONG>a</STRONG></P><P><STRONG>b</STRONG></P><P><STRONG>c</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Concatenate (SAMPLE)</STRONG></P><P><STRONG>Load * Inline [</STRONG></P><P><STRONG>Col1</STRONG></P><P><STRONG>d</STRONG></P><P><STRONG>e</STRONG></P><P><STRONG>f</STRONG></P><P><STRONG>];</STRONG></P></BODY></HTML> Fri, 04 Apr 2014 11:30:48 GMT https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602119#M1106176 jvishnuram 2014-04-04T11:30:48Z Re: Concatenate two columns https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602120#M1106177 <HTML><HEAD></HEAD><BODY><P>Thans alot</P></BODY></HTML> Fri, 04 Apr 2014 11:50:25 GMT https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602120#M1106177 2014-04-04T11:50:25Z Re: Concatenate two columns https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602121#M1106178 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Fri, 04 Apr 2014 11:50:39 GMT https://community.qlik.com/t5/QlikView/Concatenate-two-columns/m-p/602121#M1106178 2014-04-04T11:50:39Z