Courses / Power Query (Get & Transform)
35. Combine Files with Transform Sample
Using the 'Combine Files' workflow that creates a sample transform to apply to every file in a folder.
Power Query M
Combine Files with Transform Sample
A workflow that records a transformation on one file (the sample) and automatically applies that same transform to every file in a folder.
"I set up the cleaning once and Power Query repeats it for every file in the folder."
You pick a folder of similar files, Power Query builds a small "sample" query showing the steps you want, then it turns that into a function and runs it for every file to produce a single combined table.
"I set up the cleaning once and Power Query repeats it for every file in the folder."
You pick a folder of similar files, Power Query builds a small "sample" query showing the steps you want, then it turns that into a function and runs it for every file to produce a single combined table.