topic Re: How to set data correctly in columns? in QlikView https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738928#M1056692 <HTML><HEAD></HEAD><BODY><P>Please can anyone suggest me would it be possible or not?</P></BODY></HTML> Thu, 16 Oct 2014 15:38:11 GMT 2014-10-16T15:38:11Z How to set data correctly in columns? https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738926#M1056689 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have below data executed from SQL query.</P><P></P><P><STRONG>country,&nbsp; Code, closed,&nbsp;&nbsp; CY,&nbsp;&nbsp;&nbsp;&nbsp; CusName,&nbsp;&nbsp; a1,&nbsp;&nbsp;&nbsp; a2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gender,&nbsp;&nbsp; ref,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tori,&nbsp;&nbsp;&nbsp; Joiuy,&nbsp;&nbsp; Populate,&nbsp;&nbsp; int</STRONG></P><P>USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 324&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Null&nbsp;&nbsp;&nbsp; 554&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ejrlgn&nbsp; btebte&nbsp; btbte cvdvdrv&nbsp;&nbsp; POi O90&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34758573 vnvjv&nbsp;&nbsp; POland&nbsp;&nbsp;&nbsp;&nbsp; jdvsv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P></P><P></P><P></P><P>When I am copying and pasting the above values with column headers into excel it is showing output as below</P><P></P><P><STRONG>country,&nbsp; Code, closed, CY,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CusName,&nbsp;&nbsp; a1,&nbsp;&nbsp;&nbsp; a2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a5,&nbsp;&nbsp;&nbsp;&nbsp; Gender,&nbsp;&nbsp; ref,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tori,&nbsp; Joiuy,&nbsp;&nbsp; Populate,&nbsp;&nbsp; int</STRONG></P><P> ejrlgn&nbsp;&nbsp;&nbsp;&nbsp; btebte&nbsp;&nbsp;&nbsp; btbte&nbsp;&nbsp; cvdvdrv&nbsp;&nbsp; POi O90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp; 34758573&nbsp; vnvjv&nbsp;&nbsp; POland&nbsp;&nbsp;&nbsp;&nbsp; jdvsv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P></P><P></P><P></P><P>Would it be possible to set using Qlikview file. Can anyone suggest me please.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 16 Oct 2014 14:32:22 GMT https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738926#M1056689 2014-10-16T14:32:22Z Re: How to set data correctly in columns? https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738927#M1056690 <HTML><HEAD></HEAD><BODY><P>I have tried TRIM function but not working for below columns</P><P></P><P>country,&nbsp; Code, closed,&nbsp;&nbsp; CY,&nbsp;&nbsp;&nbsp;&nbsp; CusName,&nbsp;&nbsp; a1,&nbsp;&nbsp;&nbsp; a2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gender,&nbsp;&nbsp; ref,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tori,&nbsp;&nbsp;&nbsp; Joiuy,&nbsp;&nbsp; Populate,&nbsp;&nbsp; int</P><P></P><P></P><P></P><P>please can anyone help me to get this.<BR /> </P></BODY></HTML> Thu, 16 Oct 2014 14:49:04 GMT https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738927#M1056690 2014-10-16T14:49:04Z Re: How to set data correctly in columns? https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738928#M1056692 <HTML><HEAD></HEAD><BODY><P>Please can anyone suggest me would it be possible or not?</P></BODY></HTML> Thu, 16 Oct 2014 15:38:11 GMT https://community.qlik.com/t5/QlikView/How-to-set-data-correctly-in-columns/m-p/738928#M1056692 2014-10-16T15:38:11Z