Data Management Multicolumn Load - Selecting Periods

Summary

understanding the multicolumn import format type

Content

Hi. Setting up Data Management to load a multicolumn file where the columns are periods. The requirement is for users, when they load data, to pick which period they want to load. Prior periods should not be reloaded (unless specified) and future periods should not be loaded to avoid confusion. This used to be easy with the old multi period import format type. I set up the import format as multi column numeric data. The year is in the file as a field so used a year row to map that dimension. For the amount field, tried several versions of the expression