I have a source file including 12 columns with the period of the current year. This file needs to be periodically updated into the Anaplan model. The file contains headers such as 1, 2, 3, etc. and I have to map these to the time dimension for the months based on the year the file is uploaded. Can anyone help me with this?
If you set the file options so the file has no header row (by setting it to zero) and map column headers to time, then the time tab will be different and instead of matching column headers or parsing period formats you have to manually map the (numbered) columns into the timescale. I think the same will happen if the is a header row but a column header is blank or there are duplicate column headers.