Importing file by year period mapping
In importing a file using the period mapping "Year," you can select a year from the Year combo box. If your file contains a "Year" column, that year is used, otherwise the year from the combo box is used.
Before importing, make sure these conditions are met:
- The file should contain the period columns, and its name should be "Period".
- If the file contains the year column, its name should be "Year".
- The Year should be in the YYYY format.
- The Period should be
consistent with the Period Type.
Example:
- Months: 1, 2, 3, ... up to 12 only
- Weeks: 1, 2, 3, ... up to 52
- Quarters: 1, 2, 3, 4 (up to 4)
To import a file by year period mapping: