topic Data separation in QlikView https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365405#M840808 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>i have one column data like this</P><P></P><P>Name</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 754px;"><TBODY><TR><TD class="xl63" height="17" width="754">ComprehensivePolicy,NCB Protect Cover,Zero Dep Cover,Invoice Cover,Engine Protect,Electronic Circuit Cover,Passenger Cover,Quick Assistance Cover</TD></TR></TBODY></TABLE><P></P><P></P><P>i need like</P><P></P><P>Name</P><P><SPAN style="font-size: 13.3333px;">ComprehensivePolicy,</SPAN></P><P><SPAN style="font-size: 13.3333px;">NCB Protect Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Dep Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Invoice Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Engine Protect</SPAN></P><P><SPAN style="font-size: 13.3333px;">Electronic Circuit Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Passenger Cover,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Quick Assistance Cover</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT qlikview979 2020-11-25T16:16:04Z Data separation https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365405#M840808 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>i have one column data like this</P><P></P><P>Name</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 754px;"><TBODY><TR><TD class="xl63" height="17" width="754">ComprehensivePolicy,NCB Protect Cover,Zero Dep Cover,Invoice Cover,Engine Protect,Electronic Circuit Cover,Passenger Cover,Quick Assistance Cover</TD></TR></TBODY></TABLE><P></P><P></P><P>i need like</P><P></P><P>Name</P><P><SPAN style="font-size: 13.3333px;">ComprehensivePolicy,</SPAN></P><P><SPAN style="font-size: 13.3333px;">NCB Protect Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Dep Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Invoice Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Engine Protect</SPAN></P><P><SPAN style="font-size: 13.3333px;">Electronic Circuit Cover</SPAN></P><P><SPAN style="font-size: 13.3333px;">Passenger Cover,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Quick Assistance Cover</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365405#M840808 qlikview979 2020-11-25T16:16:04Z Re: Data separation https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365406#M840809 <HTML><HEAD></HEAD><BODY><P>Try using subfield() like:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Load</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>SubField</STRONG>(Name, ',') as NewName</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">From &lt;&gt;;</SPAN></P></BODY></HTML> Thu, 04 May 2017 13:01:10 GMT https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365406#M840809 tresB 2017-05-04T13:01:10Z Re: Data separation https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365407#M840810 <HTML><HEAD></HEAD><BODY><P>Subfield() might help you.</P></BODY></HTML> Thu, 04 May 2017 13:02:34 GMT https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365407#M840810 MindaugasBacius 2017-05-04T13:02:34Z Re: Data separation https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365408#M840811 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Have a look. Hope it will help</P></BODY></HTML> Thu, 04 May 2017 13:17:22 GMT https://community.qlik.com/t5/QlikView/Data-separation/m-p/1365408#M840811 Anonymous 2017-05-04T13:17:22Z