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. :)
Hi Clara,
Actually it is not possbile to apply the same transformation steps to all filtered queries at once. However you can duplicate the query and edit the steps accrodingly.
Regards,
Frank
Hi Clara,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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
