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.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
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

    Thank you so much for tipping me,

     

    Best,
    Jacek