Forum Discussion

lishapruthi's avatar
lishapruthi
Helper I
2 years ago
Solved

Combine files with different column structure

Hi Everyone,   There is one question, Can we combines files with differnt structure in Powerquery. Example : one excel file contain column A, B, C, D but second file contains A, B, C, D, E Can we ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lishapruthi ,

    Replace the expanded column names with the following code:

    List.Distinct(List.Combine(List.Transform (#"Removed Other Columns1"[Transform File],each Table.ColumnNames(_))))

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lishapruthi ,

Replace the expanded column names with the following code:

List.Distinct(List.Combine(List.Transform (#"Removed Other Columns1"[Transform File],each Table.ColumnNames(_))))

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

lbry9's avatar
lbry9
New Member
1 year ago

Hi,

 

This solution is the closest I've come to being able to do this. I'm running into an error though. I have 4 files in a folder and I'm getting the following error at this last step. It may be because only one of my files says it's setup as a table. If so, could you help guide me?