Forum Discussion
Transform files from folder before combining?
Thanks, Frank! Unfortunately that wouldn't work for me because, as I said, I have hundreds of files to transform and combine. I did manage to achieve what I needed through a combination of these solutions, though:
Combine CSVs from Folder - Separate Function
Re: Retain file name column when using Folder as a data source - Power Query M
So I'm gonna leave them here in case they would help anyone else. :)
Thanks, Frank! Unfortunately that wouldn't work for me because, as I said, I have hundreds of files to transform and combine. I did manage to achieve what I needed through a combination of these solutions, though:
Combine CSVs from Folder - Separate Function
Re: Retain file name column when using Folder as a data source - Power Query M
So I'm gonna leave them here in case they would help anyone else. :)
thank your for asking that question. i have the same need, to transform before combining. but i was not able to figure out how to do it using the links you shared. any advice?
I had this question too but I was able to resolve it after I saw this thread
you can adjust the sample file to how you want it to import into your actual query