topic Re: help me in QlikView https://community.qlik.com/t5/QlikView/help-me/m-p/624797#M229825 <HTML><HEAD></HEAD><BODY><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Subfield(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Name</SPAN>,',') as name</P><P>From FileName;</P></BODY></HTML> Thu, 10 Apr 2014 16:21:25 GMT MK_QSL 2014-04-10T16:21:25Z help me https://community.qlik.com/t5/QlikView/help-me/m-p/624795#M229823 <HTML><HEAD></HEAD><BODY><P>can anybody help me out in solving this?</P><P></P><P>input table is</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="20" width="64"> </TD><TD width="64">Name</TD></TR><TR><TD align="right" height="20">1</TD><TD>A,B,C</TD></TR><TR><TD align="right" height="20">2</TD><TD>D</TD></TR><TR><TD align="right" height="20">3</TD><TD>E,F</TD></TR></TBODY></TABLE><P></P><P></P><P>i want output as </P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">name</TD></TR><TR><TD align="right" height="20">1</TD><TD>A</TD></TR><TR><TD align="right" height="20">1</TD><TD>B</TD></TR><TR><TD align="right" height="20">1</TD><TD>C</TD></TR><TR><TD align="right" height="20">2</TD><TD>D</TD></TR><TR><TD align="right" height="20">3</TD><TD>E</TD></TR><TR><TD align="right" height="20">3</TD><TD>F</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 10 Apr 2014 16:14:16 GMT https://community.qlik.com/t5/QlikView/help-me/m-p/624795#M229823 2014-04-10T16:14:16Z Re: help me https://community.qlik.com/t5/QlikView/help-me/m-p/624796#M229824 <HTML><HEAD></HEAD><BODY><P>Use the subfield() function for the Name data</P><P></P><P></P><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; subfield(Name, ',') as Name</P><P>....</P></BODY></HTML> Thu, 10 Apr 2014 16:17:17 GMT https://community.qlik.com/t5/QlikView/help-me/m-p/624796#M229824 Colin-Albert 2014-04-10T16:17:17Z Re: help me https://community.qlik.com/t5/QlikView/help-me/m-p/624797#M229825 <HTML><HEAD></HEAD><BODY><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Subfield(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Name</SPAN>,',') as name</P><P>From FileName;</P></BODY></HTML> Thu, 10 Apr 2014 16:21:25 GMT https://community.qlik.com/t5/QlikView/help-me/m-p/624797#M229825 MK_QSL 2014-04-10T16:21:25Z Re: help me https://community.qlik.com/t5/QlikView/help-me/m-p/624798#M229826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please this discussion.</P><P></P><P><A href="https://community.qlik.com/message/479696">Problem with field</A></P><P><A _jive_internal="true" href="https://community.qlik.com/message/479696">http://community.qlik.com/message/479696</A></P><P></P><P>It have lots of solution as per your requirements,</P><P></P><P>Regards,</P></BODY></HTML> Thu, 10 Apr 2014 16:27:07 GMT https://community.qlik.com/t5/QlikView/help-me/m-p/624798#M229826 PrashantSangle 2014-04-10T16:27:07Z