Outout to SQL - Key for update

[Hamder83]

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.

[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?