Forum Discussion

lishapruthi's avatar
lishapruthi
Icon for Helper I rankHelper 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

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver III
2 years ago

Hi lishapruthi,

Using merge queries to join the two tables into a single table. but there are similar columns needed to make a join between the two tables.

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.