COMMUNITY FORUM

My question is “how can I accomplish this?” as I can’t figure out the right order of steps. Do I need to do custom validation for this?

• My data source is a staging table where I haven’t yet checked if the records already exist in GP.


• I’d like to use the SQL Validation option as it’s nice and clean but I want to update a status column in my staging table if a document fails validation. I can’t seem to get the right order of events to make that work.

Thx
Jen