Forum Discussion

freelensia's avatar
freelensia
Advocate II
6 years ago

Function to update any table with new values from another table

This is just an idea out there for discussions...I imagine this kind of function would be incredibly useful for many people out there.   Imagine I have table A, of 10 columns and 100,000 rows, we c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

DylanEvans's avatar
DylanEvans
Frequent Visitor
4 years ago

Sorry to jump on a 2yo thread, but for noobs hoping to reuse this code, can you explain where to add this function?  Which string refers to the tables?  Which string refers to the unique column?  Also: will this work as-is for merging a single table with pre-existing dupe records against itself?