Visual Integrator / VI
So I had a particular situation in which I had a source file that contained records that would update existing records (wanted behavior) and create new records (unwanted behavior) so I found the following works quite well to make sure that only existing records are updated and no new records are created. The table in question was GL_Account and as most fields were automatically assigned, I couldn't just pick a field on the Select Tab and specify the field is not blank.
So on the Data Tab, pick any field that is not part of the primary key and add it to the field list, even if you are intentionally updating the field, just add a duplicate of it as seen in the image.
Set the Operation to Assign.
Set the Default to NEW.
Add the following to the Conditional field.
```
coBusiness'EditState=2
```
On the Select Tab, add the field you selected above.
Set the Relation to Not Equal.
Set the Selection Value to NEW.
Now when a record is being read and data is populated into the fields, if the EditState property equals 2 (2 means new record, 1 means existing record) then the field you selected will be assigned the NEW value which will cause the Select logic to not select it.