Dynamically combine files from a folder

[ronaldbalza2023]

Hi everyone, I have files from a folder that adds a new file everyday. How can I dynamically combine these files based on the same name? Say DimController will be one table, DimMachine will be one table so and so....Thanks 🙂

[hnguy71 · Accepted solution]

Hi @ronaldbalza2023 ,

You can use the Power Query editor to make the necessary transformations. 

Select Get Data > Folder > Input your folder path

Then click Transform Data.

From here, for each of your tables you want, you can filter for the required files. For instance, if I wanted to filter and combine for DimController, the next applied step would be this:

If you did it right, you should only have your DimController files. Once correct, click the two down arrows to combine them together.

[ronaldbalza2023]

Thanks for taking the time on this @hnguy71 will give this a shot 🙂