topic Re: Transformatio field in QlikView https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037396#M936580 <HTML><HEAD></HEAD><BODY><P>see SubField() in help.</P></BODY></HTML> Mon, 15 Feb 2016 15:00:57 GMT luciancotea 2016-02-15T15:00:57Z Transformatio field https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037395#M936579 <HTML><HEAD></HEAD><BODY><P>hey all,</P><P></P><P>if i have for example this field key: ''1234|Account|Domici"</P><P>‌i want to transform it into 3 field first one :1234 </P><P>Second one :Account </P><P>Third one : Domici</P><P></P><P>hope u can help</P></BODY></HTML> Mon, 15 Feb 2016 14:59:22 GMT https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037395#M936579 mario-sarkis 2016-02-15T14:59:22Z Re: Transformatio field https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037396#M936580 <HTML><HEAD></HEAD><BODY><P>see SubField() in help.</P></BODY></HTML> Mon, 15 Feb 2016 15:00:57 GMT https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037396#M936580 luciancotea 2016-02-15T15:00:57Z Re: Transformatio field https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037397#M936581 <HTML><HEAD></HEAD><BODY><P>Try this may be:</P><P></P><P><STRONG>SubField(FieldKey, '|', 1) as FirstField,</STRONG></P><P><STRONG style="line-height: 1.5em; font-size: 13.3333px;">SubField(FieldKey, '|', 2) as SecondField,</STRONG></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;"><STRONG>SubField(FieldKey, '|', 3) as ThirdField,</STRONG></SPAN></P></BODY></HTML> Mon, 15 Feb 2016 15:01:27 GMT https://community.qlik.com/t5/QlikView/Transformatio-field/m-p/1037397#M936581 sunny_talwar 2016-02-15T15:01:27Z