Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine Two excel files with different column names and different amount of columns

Currently, I am receiving excel files from two different sources. I want to combine them for analysis on Power BI. However, because these reports are generated differently, the column/header names in...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    You can use try to use combine function to achieve your requirement:

    let
    Source = Table.Combine({T1, Table.RenameColumns(T2,{{"Manager","Account Manager"},{"Location Name","Location"}})})
in
    Source

    Regards,

    Xiaoxin Sheng

labuser1235's avatar
labuser1235
Icon for Helper IV rankHelper IV
6 years ago

You can do it easily in power bi edit queries. 

Change the column names in table 2 as per your requirement and re-arrange the order of the columns. 

After that, in Edit queries --> Home --> Click on Append Queries. Click on two tables and select table1. 

You will get your desired output then click on close and apply.