Function to update any table with new values from another table

Hi Thomas,

Sorry, was not clear in my post - thee attributes list assumes "group by" columns, in your case [Date]. 1-5 are "value" columns.

If you do it this way it should work Ok, in my test 1-5 has "number-type" values, everything works fine. In fact, it doe not matter what type of data is in these columns, it will be removed in any case (a code for adding the formatting back is quite simple anyway). You can even mix formats in the "old" and "new" data, in this case a number can be replaced by a text and vice versa.

This is my code for using the function (assuming it is called fUpdate😞

let
    Source = fUpdateTable(DictionaryTbl, UpdateTbl, {"Date"})
in
    Source

Kind regards,

John