Importing file by PPPP?YYYY period mapping

The question mark (?) in periodcalc format PPPP?YYYY represents the separator between period and year. The separator can be any letter or special character or null. The separator cannot be a number. The separator cannot be similar to the list separator of the file.

If your date is January 2017, these formats are acceptable:

  • 1-2017
  • 01-2017
  • 001-2017
  • 0001-2017
  • 12017
  • 012017
  • 0012017
  • 00012017

These example formats, using the same example date, are not acceptable (but not limited to these):

  • 0001-17
  • 2801-2017

Before importing, make sure these conditions are met:

  • The file should contain a column for the date.
  • The date should be in periodcalc format PPPP?YYYY.
  • There should be no duplicate rows. There should be no two rows having the same year and period.
  • The column name input in the Import File tab should match the column name in the file.
  • The separator (?) of PPPP and YYYY should not be similar to the list separator of the file.

To import a file by PPPP?YYYY period mapping:

  1. Select Action > Import File.
  2. Specify the configuration name.
  3. Specify the separator character in Options.
  4. In Import Parameters, specify this information:
    Dataset
    Select a dataset from the list.
    Transaction Type
    Specify the transaction type.
    Period Mapping
    Select PPPP?YYYY.
    Column Name with PPPP?YYYY values
    Specify the column name that contains PPPP?YYYY data.
  5. Specify a folder path where the file to be imported into DMP is located.
  6. Click Import.