Forum Discussion
Using Power Query to Merge Excel Sheets Stored into a Folder
I have been successful in using Power Query to merge several excel sheets stored in a folder as one table. My concern is "what-if" a future excel file stored in the folder introduces new columns or removes a column. What is a good process to help identifiy these new columns or loss of columns?
1 Reply
It's your choice. The Table.Combine function is smart enough to append tables even if they don't have the same columns, or have columns in different order, are missing columns, or have extra columns. The end result is a full combination of all found columns with matches where possible and null where not.
