In the previous post Rename column names in a dynamic way with #Excel #PowerQuery, I talked about the key steps involved to rename column names in a dynamic approach; and the inspiration as well as the thinking process.
As mentioned at the end of that post, we could apply the techniques for a practical and common problem – Append tables with inconsistent column names, as shown in the diagram above.
As promised, here’s the video to illustrate how to do it. I hope you like it. 😉
Thanks mma173 for the great tip of using List.Zip and MissField.Ignore
You may download sample files to follow along:
Workbooks with the finished queries:
Note: Video in Cantonese is
under production. Stay tuned now available. 😉