I simply exported a table to excel to manipulate some of the data. Now I want to truncate and append the original table, though when I go to append, it errors out 000466 due to different schema. If I select Use the Field Map to reconcile schema differences, anything slightly different comes in as a <Null> value. How can I resolve this or force the input data to take the same schema as the target dataset?
