Which of my merge inputs has the problem?

28
2
03-17-2020 07:07 AM
RandyMcGregor2
Regular Contributor

I have a merge with 14 inputs. One field has blank values in it and that throws up an error. Selecting blanks and calculating them = "NULL" solves the problem, but I THINK I have done that for all the ones that have blank values and I am still getting the error.

Is there any way to figure out which of the inputs has the problem? The error message does not indicate which input is the culprit.

Thank you,

Randy McGregor

Reply
0 Kudos
2 Replies
DanPatterson_Retired
MVP Esteemed Contributor

Is this in a featureclass or table in a geodatabase?

Make a copy of one of your inputs to serve as the new destination, then incrementally use

Append—Data Management toolbox | Documentation 

RandyMcGregor2
Regular Contributor

These are tables. You mean append one at a time? That is a good idea. You could run it, get an error, fix it, continue. I was hung up on running all of them at once and had a bout 7 failures in a row. 

Reply
0 Kudos