topic Re: Load field only up to comma in QlikView https://community.qlik.com/t5/QlikView/Load-field-only-up-to-comma/m-p/1196956#M628611 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>LOAD ID,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"> SubField(Type, ',', 1) as Type</SPAN></STRONG></P><P><STRONG>FROM ....</STRONG></P></BODY></HTML> Fri, 30 Sep 2016 18:17:11 GMT sunny_talwar 2016-09-30T18:17:11Z Load field only up to comma https://community.qlik.com/t5/QlikView/Load-field-only-up-to-comma/m-p/1196955#M628610 <HTML><HEAD></HEAD><BODY><P>I have&nbsp; a field a table that looks like this.</P><P></P><TABLE border="1" class="jiveBorder" height="99" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 679px; height: 96px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Type</TH></TR><TR><TD style="padding: 2px;"><P>300</P></TD><TD style="padding: 2px;">Jim,Dave,Scott</TD></TR><TR><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">Ron,Betty,Jeff</TD></TR><TR><TD style="padding: 2px;">600</TD><TD style="padding: 2px;">Sara,Nick,Nick</TD></TR></TBODY></TABLE><P></P><P></P><P>When loading into Qlik I need only the charteres to the left of the first comma in the type column. The result should look like this.</P><P></P><TABLE border="1" class="jiveBorder" height="101" style="border: 1px solid rgb(0, 0, 0); width: 676px; height: 103px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Type</TH></TR><TR><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">Jim</TD></TR><TR><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">Ron</TD></TR><TR><TD style="padding: 2px;">600</TD><TD style="padding: 2px;">Sara</TD></TR></TBODY></TABLE><P></P><P></P><P>Any help??</P><P></P><P>Thanks in advanced.</P></BODY></HTML> Fri, 30 Sep 2016 17:40:01 GMT https://community.qlik.com/t5/QlikView/Load-field-only-up-to-comma/m-p/1196955#M628610 jeckstein 2016-09-30T17:40:01Z Re: Load field only up to comma https://community.qlik.com/t5/QlikView/Load-field-only-up-to-comma/m-p/1196956#M628611 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>LOAD ID,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"> SubField(Type, ',', 1) as Type</SPAN></STRONG></P><P><STRONG>FROM ....</STRONG></P></BODY></HTML> Fri, 30 Sep 2016 18:17:11 GMT https://community.qlik.com/t5/QlikView/Load-field-only-up-to-comma/m-p/1196956#M628611 sunny_talwar 2016-09-30T18:17:11Z