How to Import Data with an Optional Trailing Data Column


If you add new columns to an input file or otherwise change the schema, you need to make a new workbook that correctly handles the both the old data and the new schema. 


If the new and old schema don't match, you need to do some pre-processing in the workbook by creating a union sheet combining one Import Job or Data Link with another one.