Forum Discussion
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...
Anonymous
Important to note: it ONLY works with this trigger code.
I used the interface and Power Query will make me chose a column from one of the Tables.
As a reasult the list of dates is handed over as Attributes parameter instead of the column name ("Date").
With that in mind: works great!
Have posted a summary of the two solutions proposed in form of functions here:
Overlaying/merging two tables to add missing data in empty cells and new rows/columns