Update and Insert if new

[praneshsapmm]

Hi ,

I have this requirement with database updation using Update and Insert if new command . 

Whenever the incoming record already exsists in the database iam using uppdate and Insert if new Output Option . But the requirement is to update only specific fields / not to update specific fields. how this can be done . 

Thanks

[geraldo]

@praneshsapmm 

for this procedure your table must have a primary key.

you will have to configure all the existing columns in the table and the ones that will be updated,