Forum Discussion

Redzero1's avatar
Redzero1
Frequent Visitor
2 years ago
Solved

Union function in Power Query

Hello, I have a simple request for M Query experts :   I have 3 different Tables ( Table1 , Table2, Table3) with different structure for each of them  Table1 (Sales , Amount , Date , region , pho...
Need Help
  • mtayyab07's avatar
    mtayyab07
    2 years ago

    Please try this code

    let
    // Correct the column names and select common columns for Table1
    Table1_Modified = Table.SelectColumns(Table.RenameColumns(Table1, {{"Amount", "Amount"}, {"Date", "Date"}, {"Sales", "Sales"}}), {"Sales", "Date", "Amount"}),

    // Correct the column names and select common columns for Table2
    Table2_Modified = Table.SelectColumns(Table.RenameColumns(Table2, {{"amount", "Amount"}, {"Trade_date", "Date"}, {"sales", "Sales"}}), {"Sales", "Date", "Amount"}),

    // Correct the column names and select common columns for Table3
    Table3_Modified = Table.SelectColumns(Table.RenameColumns(Table3, {{"amount", "Amount"}, {"date", "Date"}, {"sales", "Sales"}}), {"Sales", "Date", "Amount"}),

    // Combine the tables
    CombinedTable = Table.Combine({Table1_Modified, Table2_Modified, Table3_Modified})
in
    CombinedTable
mtayyab07's avatar
mtayyab07
Frequent Visitor
2 years ago

Please try this code

let
    // Correct the column names and select common columns for Table1
    Table1_Modified = Table.SelectColumns(Table.RenameColumns(Table1, {{"Amount", "Amount"}, {"Date", "Date"}, {"Sales", "Sales"}}), {"Sales", "Date", "Amount"}),

    // Correct the column names and select common columns for Table2
    Table2_Modified = Table.SelectColumns(Table.RenameColumns(Table2, {{"amount", "Amount"}, {"Trade_date", "Date"}, {"sales", "Sales"}}), {"Sales", "Date", "Amount"}),

    // Correct the column names and select common columns for Table3
    Table3_Modified = Table.SelectColumns(Table.RenameColumns(Table3, {{"amount", "Amount"}, {"date", "Date"}, {"sales", "Sales"}}), {"Sales", "Date", "Amount"}),

    // Combine the tables
    CombinedTable = Table.Combine({Table1_Modified, Table2_Modified, Table3_Modified})
in
    CombinedTable
Redzero1's avatar
Redzero1
Frequent Visitor
2 years ago

Thanks worked perfectly