topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/22290#M775396 <HTML><HEAD></HEAD><BODY><P>May be using SubField</P><P></P><P><STRONG>LOAD SubField(Field, '_', 1) as 1,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 2) as 2,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 3) as 3, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 4) as 4,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 5) as 5,</STRONG></P></BODY></HTML> Fri, 11 May 2018 16:15:34 GMT sunny_talwar 2018-05-11T16:15:34Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/22289#M775395 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data like this shown in below in excelsheet. Below is the field has the chain data.I need to split the one field in to multiple fields like AAA as 1, BBB as 2, CCC as 3,EEE as 4,FFF as 5..etc</P><P></P><P>Field</P><P>AAA_BBB_CCC_DDD_EEE_FFF_GGG</P><P></P><P>Can anyone help on this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/22289#M775395 pinky1234 2020-11-25T16:16:04Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/22290#M775396 <HTML><HEAD></HEAD><BODY><P>May be using SubField</P><P></P><P><STRONG>LOAD SubField(Field, '_', 1) as 1,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 2) as 2,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 3) as 3, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 4) as 4,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(Field, '_', 5) as 5,</STRONG></P></BODY></HTML> Fri, 11 May 2018 16:15:34 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/22290#M775396 sunny_talwar 2018-05-11T16:15:34Z