Outout to SQL - Key for update

Hi

I'm sorry but im not sure I get what I have to do:

In a small table where my UUID is pk.

So for obvious reasons if the uuid is not in the db already, then its new.

But what fields go into which? Feels like i have tried all combinations.

But adding 10.000 rows into a empty table stalls for ages. If I batch output it take 3 sec.

Output

Accepted answers

All comments

geraldo

@Hamder83

are you using odbc connection?
If not, there is another option to update or insert new

odbc offers more options

Hamder83

Hi @geraldo - i'm using odbc, and im trying to use update- insert if new.

But I cant really understand how to configure it?

In the left column is that the key for validating if new? or is right?

jdminton

I think we need more information here. We can’t see much of this process, but it would appear that this step is correct. Are there any other columns identified as primary key in your DB?

geraldo

@Hamder83

check this option

Hamder83

Hi @jdminton & @geraldo

I have a table with these columns:

Either the parcelnumberpurchase excist within the creditor and shipment year. If it does and the bookinglineid is added, then I want to update excisting record.

if the parcelnumberpurchase does not exist within the credit and shipmentyear I want to add it.

Wo which columns from my data goes into what coluimn in this window?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703