Forum Discussion
Solved
Transform files from folder before combining?
Hello! I'm a starting user and I feel like I've reached a dead end here. (I've searched for a solution everywhere and haven't found any, sorry if I missed something obvious!) I have about 250 fil...
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