Turn a DB insert step into an update step

Sometimes I have huge tables I am inserting data into, and they are in a condition, so if the record exists, update it, else, insert a new record.

The insert and update steps are almost identical, so would there be a simple way to add functionality do duplicate an insert step and change it into an update step rather with all the same parameters.

I know I could have added this as a feature request, but it my be too dumb an idea to make it to a feature request depending on what feedback I get.

I once had a dream…

I’d vote for it!

:slight_smile:

2 Likes

I’d prefer to vote for an UPSERT QUERY step.
I have used this in one project with MariaDB/MySQL via custom query. And it works well. Mantaining it is a nightmare though.
Although, having a quick dropdown for switching between insert & update would make sense, just like we have for pages, multi & single query.

2 Likes