Forum Discussion
Charting Monthly Data from different tables
So every month I receive updated data in new tables. I am really struggling to layer those data points together so I can show trends on a month-to-month basis. Do I need to add a column to each month...
If all of the data is in the same format, I would recommend a Folder query. Dump all of the files into a folder with nothing else and then use the Folder query to import all of the data into a single table. When you get a new month, dump that file into the folder and refresh. Then, you will have a single table with all of your data that you can then use to show trends very easily.
How do you create a folder querry? is this something specific or just a folder in the computer and just import that folder?
