topic Splitting field values in QlikView https://community.qlik.com/t5/QlikView/Splitting-field-values/m-p/377491#M702139 <HTML><HEAD></HEAD><BODY><P>I am loading a excel file (extracted from our CRM) where the fields having multiple choice reside in the same field. See below (the last three listings)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="313"><TBODY><TR><TD height="15" width="313">EC Printer</TD></TR><TR><TD height="15">EC Printer</TD></TR><TR><TD height="15">EC PathView</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD height="15">EC Overnight,EC PathView</TD></TR><TR><TD height="15">EC Fax,EC Overnight</TD></TR><TR><TD height="15">EC Fax,EC Overnight</TD></TR></TBODY></TABLE><P></P><P>Using the last entry, EC Fax and EC Overnight need to be two unique values and no combined. How can I split these values out to correctly display the fields? </P><P></P><P>Needs to be:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 313px;"><TBODY><TR><TD height="15" width="313">EC Printer</TD></TR><TR><TD height="15">EC Printer</TD></TR><TR><TD height="15">EC PathView</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD height="15">EC Overnight</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD>EC PathView</TD></TR><TR><TD>EC Overnight</TD></TR><TR><TD>EC Overnight</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 13 Aug 2012 20:22:53 GMT 2012-08-13T20:22:53Z Splitting field values https://community.qlik.com/t5/QlikView/Splitting-field-values/m-p/377491#M702139 <HTML><HEAD></HEAD><BODY><P>I am loading a excel file (extracted from our CRM) where the fields having multiple choice reside in the same field. See below (the last three listings)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="313"><TBODY><TR><TD height="15" width="313">EC Printer</TD></TR><TR><TD height="15">EC Printer</TD></TR><TR><TD height="15">EC PathView</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD height="15">EC Overnight,EC PathView</TD></TR><TR><TD height="15">EC Fax,EC Overnight</TD></TR><TR><TD height="15">EC Fax,EC Overnight</TD></TR></TBODY></TABLE><P></P><P>Using the last entry, EC Fax and EC Overnight need to be two unique values and no combined. How can I split these values out to correctly display the fields? </P><P></P><P>Needs to be:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 313px;"><TBODY><TR><TD height="15" width="313">EC Printer</TD></TR><TR><TD height="15">EC Printer</TD></TR><TR><TD height="15">EC PathView</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD height="15">EC Overnight</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD height="15">EC Fax</TD></TR><TR><TD>EC PathView</TD></TR><TR><TD>EC Overnight</TD></TR><TR><TD>EC Overnight</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 13 Aug 2012 20:22:53 GMT https://community.qlik.com/t5/QlikView/Splitting-field-values/m-p/377491#M702139 2012-08-13T20:22:53Z Re: Splitting field values https://community.qlik.com/t5/QlikView/Splitting-field-values/m-p/377492#M702141 <HTML><HEAD></HEAD><BODY><P>See attached for an example. Note that there the strings are not separated by, but by | (to be able to load from inline)</P><P></P><P>This topic is helpful btw: <A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/16564">http://community.qlik.com/thread/16564</A></P></BODY></HTML> Mon, 13 Aug 2012 20:39:11 GMT https://community.qlik.com/t5/QlikView/Splitting-field-values/m-p/377492#M702141 2012-08-13T20:39:11Z