Forum Discussion
Merge and update History table from Update table having new or updated values
I'd recommend checking out these relevant resources for the self-referencing logic:
Self Referencing Tables in Power Query
Inserting text manually in a custom column and should be visible on refresh of the report
To do the update, I appended the tables together, grouped by ProductKey taking the latest version of the data, expanded the non-manual columns, and then merged back in the manual columns from the beginning of the query.
Please see the attached.
Yeah, get rid of rows with blanks before combining. Maybe by doing a group by and taking the max over the manual columns?
AlexisOlson just too many Manual columns. 😞
But i cleaned the data of duplicates and in m-code also used `RemovedDuplicates` over ProductKey column.
Not sure if i understood `Groupby and taking a Max over the Manual columns`...