Forum Discussion
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...
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 SourceRegards,
Xiaoxin Sheng
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