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.
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.