topic Re: Concatination of columns in QlikView https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727422#M1062129 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>try</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">A &amp; '_' &amp; B as C,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ASHFAQ<BR /></SPAN></P></BODY></HTML> Thu, 18 Sep 2014 07:03:56 GMT ashfaq_haseeb 2014-09-18T07:03:56Z Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727419#M1062126 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to concatenate two columns(say A and B).</P><P>As in make another field(say C) which displays both A and B in horizantal allignment</P><P>Please let me know the solution(s).</P><P></P><P>Thanks in advance</P></BODY></HTML> Thu, 18 Sep 2014 06:58:20 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727419#M1062126 2014-09-18T06:58:20Z Re: Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727420#M1062127 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try</P><P>A &amp; B as newfield</P></BODY></HTML> Thu, 18 Sep 2014 06:59:52 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727420#M1062127 2014-09-18T06:59:52Z Re: Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727421#M1062128 <HTML><HEAD></HEAD><BODY><P>in script</P><P></P><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A &amp; ' ' &amp; B as C,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ......</P><P>from</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ....</P></BODY></HTML> Thu, 18 Sep 2014 06:59:53 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727421#M1062128 maxgro 2014-09-18T06:59:53Z Re: Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727422#M1062129 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>try</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">A &amp; '_' &amp; B as C,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ASHFAQ<BR /></SPAN></P></BODY></HTML> Thu, 18 Sep 2014 07:03:56 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727422#M1062129 ashfaq_haseeb 2014-09-18T07:03:56Z Re: Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727423#M1062130 <HTML><HEAD></HEAD><BODY><P>in script</P><P></P><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A &amp; ' ' &amp; B as C,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ......</P><P>from</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ....</P></BODY></HTML> Thu, 18 Sep 2014 07:18:16 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727423#M1062130 2014-09-18T07:18:16Z Re: Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727424#M1062131 <HTML><HEAD></HEAD><BODY><P>Load A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A &amp; '-'&amp; B as new Field</P><P>from</P><P>table name;</P></BODY></HTML> Thu, 18 Sep 2014 07:44:31 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727424#M1062131 2014-09-18T07:44:31Z Re: Concatination of columns https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727425#M1062132 <HTML><HEAD></HEAD><BODY><P>Hello Depak,</P><P>you can add the script like this</P><P></P><P><STRONG>TableName:</STRONG></P><P><STRONG>Load fieldA &amp; fieldB as fieldC</STRONG></P><P><STRONG>from datasource;</STRONG></P><P></P><P></P><P>Regards</P><P>Charitha.</P></BODY></HTML> Thu, 18 Sep 2014 07:52:31 GMT https://community.qlik.com/t5/QlikView/Concatination-of-columns/m-p/727425#M1062132 2014-09-18T07:52:31Z