Dear All,
Currently, I am getting the data from a folder and it has few fixed text data columns and then months column with numbers in them.
Every month I received the updated file which has the latest month data but my query does not pick the data for the new month and manually I have to adjust the code to include the new month data.
What I have observed is it has hard coded the months name.
Please see the picture, I have highlighted in yellow.
What I need is to automate the process, so when ever new month data column is available, the query should pick it up.
Your help would be really appreciated.
Currently, I am getting the data from a folder and it has few fixed text data columns and then months column with numbers in them.
Every month I received the updated file which has the latest month data but my query does not pick the data for the new month and manually I have to adjust the code to include the new month data.
What I have observed is it has hard coded the months name.
Please see the picture, I have highlighted in yellow.
What I need is to automate the process, so when ever new month data column is available, the query should pick it up.
Your help would be really appreciated.