Forum Discussion
Need help in joining two tables using (JOIN/APPEND/MERGE)
I do not know to use append or merge or join in this situation. Let me explain my situation first. I have two separate data sheet. Let's call it data A and data B. Data A consists of data...
Hi, this sounds like a no brainer. Thanks, but is there an option where PowerQuery can automatically change the column name, and merge them together rather than changing them in the Excel and merge them. The dashboard need to be updated daily with new files, and I was planning for it using date extraction, and include/exclude parameters. Thank you.
lbendlin
Super User
Super UserNot sure what you mean by "automatically" but you could do that renaming as part of the load process. Be very aware that Power Query is case sensitive.