topic Re: Working with changing raw data in QlikView https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229840#M856590 <HTML><HEAD></HEAD><BODY><P>Thanks I went with the simple ignoring the excel label option</P></BODY></HTML> Wed, 08 Feb 2017 10:08:54 GMT alwayslearning 2017-02-08T10:08:54Z Working with changing raw data https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229838#M856588 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am looking for some guidance on how to work with some raw data I have.</P><P></P><P>I upload data via Excel, several column headers are titled e.g. 'Jan 2017', 'Feb 2017', 'Mar 2017' ... 'Dec 17' and so on for 12 months.&nbsp; This file will be updated monthly and the raw data date columns is rolling which also mean the columns header names will change each month.&nbsp; i.e. the next month 'Jan 17' data will not be there but 'Jan 18' will appear.</P><P></P><P>My problems with working with this is that I need to write some IF statements based on these columns.&nbsp; How can I write my IF statements in my script if the header names will change each month?&nbsp; Without having to change my formulas every month too</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229838#M856588 alwayslearning 2020-11-25T16:16:04Z Re: Working with changing raw data https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229839#M856589 <HTML><HEAD></HEAD><BODY><P>I would suggest using a crosstable load to transpose your data or you can ignore the excel labels and use @1, @2, ....</P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Tue, 07 Feb 2017 15:35:55 GMT https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229839#M856589 sunny_talwar 2017-02-07T15:35:55Z Re: Working with changing raw data https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229840#M856590 <HTML><HEAD></HEAD><BODY><P>Thanks I went with the simple ignoring the excel label option</P></BODY></HTML> Wed, 08 Feb 2017 10:08:54 GMT https://community.qlik.com/t5/QlikView/Working-with-changing-raw-data/m-p/1229840#M856590 alwayslearning 2017-02-08T10:08:54Z