Forum Discussion
Solved
Upsert Query in power query
Hi Guys, i am looking for equivalent for upsert query like here: https://www.access-programmers.co.uk/forums/threads/append-if-rows-do-not-exists-else-update-if-exists.320254/ Ok user has t...
Create one custom column with the logic to select the "right" Color.
Fix the datatypes on the columns. You don't need to return the ID and Animal if they don't change.
If it works, it works.
you could start from tableToCompare and perform a merge (left outer) with TableInput on ID field.
You could then decide which column of color you prefer