topic Renaming fields in load script in QlikView https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318707#M117462 <HTML><HEAD></HEAD><BODY><P>Thanks. I will try this.&nbsp; Do i add this statement prior to the load or after my first select * statement? </P></BODY></HTML> Fri, 29 Jul 2011 17:01:20 GMT 2011-07-29T17:01:20Z Renaming fields in load script https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318705#M117460 <HTML><HEAD></HEAD><BODY><P>In my data i have a field "AvgYear" which currently holds results of 1, 2, 3 and notavg.&nbsp; "1" represents the time period April 2010 through Mar 2011, "2" represents April 2009 thru Mar 2010 and so on.&nbsp; How do I code or alias my AvgField in my load script to show the actual period in my list box?</P><P></P><P>Hope this makes sense.</P><P>Jennifer</P></BODY></HTML> Fri, 29 Jul 2011 15:33:04 GMT https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318705#M117460 2011-07-29T15:33:04Z Renaming fields in load script https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318706#M117461 <HTML><HEAD></HEAD><BODY><P>Pick(AvgYear, 'April 2010 though Mar 2011', 'April 2009 through Mar 2010'...)</P><P></P><P>I'm not sure what notavg means though. If it isn't a number, then you may need something in addition to the Pick.</P></BODY></HTML> Fri, 29 Jul 2011 16:16:40 GMT https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318706#M117461 2011-07-29T16:16:40Z Renaming fields in load script https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318707#M117462 <HTML><HEAD></HEAD><BODY><P>Thanks. I will try this.&nbsp; Do i add this statement prior to the load or after my first select * statement? </P></BODY></HTML> Fri, 29 Jul 2011 17:01:20 GMT https://community.qlik.com/t5/QlikView/Renaming-fields-in-load-script/m-p/318707#M117462 2011-07-29T17:01:20Z