Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago
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...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    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.

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago

thanks HotChilli. 

what you mean by column of color ? 

 

Best,
Jacek