How to Import Data with an Optional Trailing Data Column

Goal

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. 

Learn

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.