In my processing we recieve many files like this, for the part where your moving the non lookupvalues to another table, I typically deal with them by adding them to...