Forum Discussion

maahutch's avatar
maahutch
New Contributor
3 years ago

How to ignore duplicate rows when inserting record into table

I'm developing a pipeline to request data from an API and load it into a MS SQL Server table. The first run of the pipeline loaded 50 records to the table, each with a unique 'user_name' value. The t...
alchemiz's avatar
alchemiz
Contributor III
3 years ago

Hi maahutch ,

Good day, you can also use the sql execute or sql stored procedure snaps and script the condition there if you're not expecting to update existing records otherwise ssapa suggestion is the solution as it will do upsert ( insert new record/ update existing record )
example:

Thanks,
EmEm