After you have uploaded the preliminary data (with “0” values for resort and metro), use MySQL to set the values using the previous survey year’s table. For example, to update 2017 using 2016’s data:
UPDATE _2017 a JOIN _2016 b on a.fscskey = b.fscskey SET a.resort = b.resort, a.metro = b.metro;In natural language, the roughly equates to:
Join the 2017 and 2016 tables using FSCS keys, then update the resort and metro values for 2017 using the 2016 data.