Forum Discussion
Dynamically combine files from a folder
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.
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.
Thanks for taking the time on this hnguy71 will give this a shot 🙂