Comparing two tables columns by columns

Hi divumj ,
You can ttry the following code

let
    // Load Table 1
    Source1 = #"Table 1",
    // Load Table 2 and rename columns to avoid conflict
    Source2 = Table.RenameColumns(#"Table 2", List.Transform(Table.ColumnNames(#"Table 2"), each {_, _ & "2"})),
    // Merge Tables
    MergedTables = Table.NestedJoin(Source1, "Unique", Source2, "Unique2", "Table2", JoinKind.Inner),
    // Expand the merged table
    ExpandedTable = Table.ExpandTableColumn(MergedTables, "Table2", Table.ColumnNames(Source2)),
    // Get the list of columns to compare
    ColumnsToCompare = List.RemoveItems(Table.ColumnNames(Source1), {"Unique"}),
    // Function to compare columns
    CompareColumns = (table as table, columns as list) as table =>
        List.Accumulate(
            columns,
            table,
            (state, current) =>
                Table.AddColumn(
                    state,
                    "Compare_" & current,
                    each if Record.Field(_, current) = Record.Field(_, current & "2") then "Match" else "Mismatch"
                )
        ),
    // Apply the comparison function
    Result = CompareColumns(ExpandedTable, ColumnsToCompare),
    // Remove unnecessary columns
    FinalResult = Table.SelectColumns(Result, List.Combine({{"Unique"}, List.Transform(ColumnsToCompare, each "Compare_" & _)}))
    in
        FinalResult

Final output

Best regards,
Albert He

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