Monday, April 19, 2021

Power Query Append Queries Not Working - Mismatch Columns Order & Name

Combining or appending files should be a straightforward process and using Power Query makes it easier. If the files that have the same header names and are in the same column order it’s really easy. However if the header names of different between files and the column orders are also different (i.e., mismatched column names and mismatched column orders) it’s a bit harder. If you only have a few files or tables to combine or append it’s just a copy and paste. But if you do this on a recurring basis or if there’s a LOT of files, it’s much harder. But still Power Query will make it easier, so check out the video to see how.

No comments:

Post a Comment