topic Re: Help in script in QlikView https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135631#M372803 <HTML><HEAD></HEAD><BODY><P>Hi Nishit,</P><P></P><P>Use below attachment. Hope its help.</P><P></P><P>Thanks <STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/gwassenaar">gwassenaar</A> </STRONG></P></BODY></HTML> Mon, 25 Jul 2016 10:41:19 GMT yadhunandhanan 2016-07-25T10:41:19Z Help in script https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135629#M372801 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have a table such as given below</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Column 1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Column 2</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">x,y,z</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">a,b,c</TD></TR></TBODY></TABLE><P></P><P>and i want to transform it into </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Column 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Column 2</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">x</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">y</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">z</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">c</TD></TR></TBODY></TABLE><P></P><P>thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 25 Jul 2016 10:28:49 GMT https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135629#M372801 2016-07-25T10:28:49Z Re: Help in script https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135630#M372802 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Column 1],</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Column 2],',') as [Column 2]</P><P>FROM&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...source...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ;</P><P><BR /> </P></BODY></HTML> Mon, 25 Jul 2016 10:30:20 GMT https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135630#M372802 Gysbert_Wassenaar 2016-07-25T10:30:20Z Re: Help in script https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135631#M372803 <HTML><HEAD></HEAD><BODY><P>Hi Nishit,</P><P></P><P>Use below attachment. Hope its help.</P><P></P><P>Thanks <STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/gwassenaar">gwassenaar</A> </STRONG></P></BODY></HTML> Mon, 25 Jul 2016 10:41:19 GMT https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135631#M372803 yadhunandhanan 2016-07-25T10:41:19Z Re: Help in script https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135632#M372804 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please find attached</P><P></P><P></P><P>Hope it helps !</P></BODY></HTML> Mon, 25 Jul 2016 10:42:35 GMT https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1135632#M372804 Anonymous 2016-07-25T10:42:35Z