Forum Discussion
Append data
I would think that you could use a Folder query (Combine Binaries) for this. You would place all of the Excel files in a single folder. Then you create a Folder query and select one file as your sample file. You do your required transformations and save the query. A Folder query will apply the transformations to every file in the folder and append all of them together at the end. So, when next month comes around, you just refresh and all of your data is there.
I would think that you could use a Folder query (Combine Binaries) for this. You would place all of the Excel files in a single folder. Then you create a Folder query and select one file as your sample file. You do your required transformations and save the query. A Folder query will apply the transformations to every file in the folder and append all of them together at the end. So, when next month comes around, you just refresh and all of your data is there.