topic How to split the single filed into 2 fields. in QlikView https://community.qlik.com/t5/QlikView/How-to-split-the-single-filed-into-2-fields/m-p/1786234#M1210068 <P>Dear Guys,</P><P>I have&nbsp; one filed (No delimiter in that field). I need split that into two fields.&nbsp; Like</P><P>Ex:&nbsp; Filed1:</P><P>&nbsp; &nbsp; &nbsp; &nbsp;S1ETM</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S1STM</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S2EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S3EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S4EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S2END</P><P>etc..</P><P>I need output Like (LAST 3 RECODS)</P><P>Time:</P><P>&nbsp; &nbsp; &nbsp; &nbsp;ETM</P><P>&nbsp; &nbsp; &nbsp; &nbsp;STM</P><P>&nbsp; &nbsp; &nbsp; &nbsp;EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; END</P><P>&nbsp;</P><P>&nbsp;Kindly help.</P><P>&nbsp; &nbsp; &nbsp;</P> Thu, 25 Feb 2021 15:07:59 GMT Sivarapu250 2021-02-25T15:07:59Z How to split the single filed into 2 fields. https://community.qlik.com/t5/QlikView/How-to-split-the-single-filed-into-2-fields/m-p/1786234#M1210068 <P>Dear Guys,</P><P>I have&nbsp; one filed (No delimiter in that field). I need split that into two fields.&nbsp; Like</P><P>Ex:&nbsp; Filed1:</P><P>&nbsp; &nbsp; &nbsp; &nbsp;S1ETM</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S1STM</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S2EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S3EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S4EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; S2END</P><P>etc..</P><P>I need output Like (LAST 3 RECODS)</P><P>Time:</P><P>&nbsp; &nbsp; &nbsp; &nbsp;ETM</P><P>&nbsp; &nbsp; &nbsp; &nbsp;STM</P><P>&nbsp; &nbsp; &nbsp; &nbsp;EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; EMT</P><P>&nbsp; &nbsp; &nbsp; &nbsp; END</P><P>&nbsp;</P><P>&nbsp;Kindly help.</P><P>&nbsp; &nbsp; &nbsp;</P> Thu, 25 Feb 2021 15:07:59 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-single-filed-into-2-fields/m-p/1786234#M1210068 Sivarapu250 2021-02-25T15:07:59Z Re: How to split the single filed into 2 fields. https://community.qlik.com/t5/QlikView/How-to-split-the-single-filed-into-2-fields/m-p/1786238#M1210070 <P>right(<SPAN>Filed1,3) as Time</SPAN></P> Thu, 25 Feb 2021 15:13:14 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-single-filed-into-2-fields/m-p/1786238#M1210070 derekjones 2021-02-25T15:13:14Z