topic Re: Changing field values in the LOAD script in QlikView https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280113#M851795 <HTML><HEAD></HEAD><BODY><P>Just use Upper() function</P><P></P><P><STRONG>LOAD Upper(Pi) as Pi,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....</STRONG></P></BODY></HTML> Tue, 28 Feb 2017 12:58:22 GMT sunny_talwar 2017-02-28T12:58:22Z Changing field values in the LOAD script https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280111#M851793 <HTML><HEAD></HEAD><BODY><P>I have a field called 'Pi' which has values 'Yes' or 'No'.&nbsp; Is there a way to LOAD the data into Qlikview but change all 'Yes' value to 'YES' and all 'No' value to 'NO' from the LOAD script?</P><P>Thanks</P><P>Greg</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280111#M851793 Anonymous 2020-11-25T16:16:04Z Re: Changing field values in the LOAD script https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280112#M851794 <HTML><HEAD></HEAD><BODY><P>upper(Pi) as Pi;</P></BODY></HTML> Tue, 28 Feb 2017 12:58:18 GMT https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280112#M851794 m_woolf 2017-02-28T12:58:18Z Re: Changing field values in the LOAD script https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280113#M851795 <HTML><HEAD></HEAD><BODY><P>Just use Upper() function</P><P></P><P><STRONG>LOAD Upper(Pi) as Pi,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....</STRONG></P></BODY></HTML> Tue, 28 Feb 2017 12:58:22 GMT https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280113#M851795 sunny_talwar 2017-02-28T12:58:22Z Re: Changing field values in the LOAD script https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280114#M851796 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 28 Feb 2017 14:02:30 GMT https://community.qlik.com/t5/QlikView/Changing-field-values-in-the-LOAD-script/m-p/1280114#M851796 Anonymous 2017-02-28T14:02:30Z