Forum Discussion

botjeff's avatar
botjeff
Regular Visitor
2 years ago

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...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Change the name of the first column so it matches exactly between the two tables, then in Power Query do a Table.Combine (or & ) on Data A and Data B.  Power Query will merge matching columns and add the extra columns from both sides.

  • botjeff's avatar
    botjeff
    Regular Visitor
    2 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Not 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.