Forum Discussion

braulio's avatar
braulio
Frequent Visitor
2 years ago
Solved

table combine

Hi, Is it possible to combine two tables with the same structure but different column names without having to rename the columns so that they remain the same? = Table.Combine({#"primer bloque", #"s...
  • lbendlin's avatar
    lbendlin
    2 years ago
    let
    Source = List.Zip({Table.ColumnNames(Table2),Table.ColumnNames(Table1)}),
    Result = Table1 & Table.RenameColumns(Table2,Source)
in
    Result
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi braulio ,

 

You can first use append to form a new table, and then use the merge column function to generate new columns. Finally, delete the redundant columns.

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • braulio's avatar
    braulio
    Frequent Visitor
    2 years ago

    Adamk, tks, it works, but I have 50 tables with 48 vars each one, I'll keep it in mind.

    Tks