title: Avoiding inserting duplicate data into table in MS Dynamics AX
body: <p>I have a custom table that I'm inserting data into. I do not want duplicate data to end up there, so I created a unique index consisting of 20ish fields that I wish to be unique.  As expected, when I run my job to insert data it of course fails and tells me it was trying to insert a duplicate record and stops the job there.  If I wrap a tts around it the whole thing fails.</p>
  
  <p>My question is, how can I make it so that the jobs still continues and only just stops the duplicates from inserting?  Note, like I mentioned above, I have 20ish fields that make up the key, it'd be cumbersome to write up something that checks for existing records with data matching all 20 fields.</p>