Data Operation - Upsert

Undraw Data Processing

About

A upsert operation is an operation against the data that will:

  • try to insert a record
  • and update it if it already exists.

The data upsert operation supports the upsert operation.

Requirements

What happens when multiple target unique constraint matches the source columns

A upsert does an update when a unique constraint is violated after insertion. This is not possible to specify two unique constraints and therefore Tabulify needs to choose one.

If you have multiple target unique constraints matched by the source columns, the process takes as unique constraint:

  • the first target unique key found in the source columns.
  • and if not present the target primary key.



Related HowTo
Undraw Data Processing
Learning Tabulify - Step 6 - How to transfer Data Resources

In Tabulify, when you want to manipulate data, it's called a transfer. You want to move data, you transfer You want to copy data, you transfer You want to insert data, you transfer You want to...
Undraw Data Processing
Learning Tabulify - Step 8 - How to modify the content of a table

Tabulify learning guidetransfer step The transfer page should have made you familiar with the transfer concept where we have introduced the copy operation. The copy and move operation does not modify...

Task Runner