Merge two tables with new or updated row values

I have a `History table` in an Excel sheet that i want to merge with a `Salesforce table` (connection only) that refreshes and brings in New or Updated rows. I found this article interesting, but it requires both the tables to have the same number of columns. It also uses an `Anti-join` and displays only any new or updated rows as a `new table` in an Excel sheet. I want to update this `History table` with new or changed data, instead of creating a new table.

The `History table` has 14 columns ie. 11 standard columns and 3 Manual entry columns.

The `Saleforce table` has say 11 columns that match with the `History table`.

I only want the new or updated rows to show up in the `History table` using a `Left or Right Outer Join`, leaving the additional 3 manual-entry columns blank.

The M-code that is interesting for the `History table` from the article and that which i want to change to only pick values from the 1st 11 columns (excluding the 3 manual-entry columns), is this one:

= Table.AddColumn(ReorderedColumns, "HistoryKey", each Text.Combine(
                List.Transform(
                    
                        Record.FieldValues(_), 
                    each Replacer.ReplaceValue(
                        Text.From(_),
                        null,
                        "")),
                ";"))

However, it picks up and concatenates the row values from all the History table columns and not just the first 11 columns to create a `History Key` column that is then used in Merge.

Eventually what i want to do is:

- create a "New Key" column (using above code) in `Salesforce table`

- create a "History Key" column (using above code) in `History table`

- Merge the 2 tables on these keys that should update the `History table` with new or updated rows.

- finally delete the "History key" column from the `History table`

- dump the `History table` back to the same worksheet (i.e. update the worksheet table)

Any help would be most appreciated in making this happen.