Forum Discussion
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...
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.