Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am looking for some guidance on how to work with some raw data I have.
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. 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. i.e. the next month 'Jan 17' data will not be there but 'Jan 18' will appear.
My problems with working with this is that I need to write some IF statements based on these columns. How can I write my IF statements in my script if the header names will change each month? Without having to change my formulas every month too
I would suggest using a crosstable load to transpose your data or you can ignore the excel labels and use @1, @2, ....
I would suggest using a crosstable load to transpose your data or you can ignore the excel labels and use @1, @2, ....
Thanks I went with the simple ignoring the excel label option