User Profile
pbushaw
Copper Contributor
Joined Mar 28, 2023
User Widgets
Recent Discussions
Appending excel files after they have been edited in power query
I have an excel file with the same name put into a folder every day. It has a lot of garbage in it I do not want but I use power query to pull out the date, location, and a total number for that day. I want to be able to put that into a table that would keep that data for each date that I get in. The problem that I am running into is that the excel file for each day has the exact same name so it overwrites the previous data rather than just adding on to the table. What I need is a way to keep adding to the table without overwriting the previous day. I hope that make sense. I ultimately am going to use this in Power BI but I need to find a way to get the each days data into a history table. Thanks for any help.532Views0likes1Comment
Recent Blog Articles
No content to show