Forum Discussion
pbushaw
Mar 28, 2023Copper Contributor
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.
If you data has unique key, or you may generate it as combination of columns, you may use self referencing tables in Power Query. Just google for bolded text, lot of posts. Mainly they are about adding columns with comments, etc, appending of tables works the same way.