Importing file by YYYY?PPPP period mapping

The question mark (?) in periodcalc format YYYY?PPPP 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:

  • 2017-1
  • 2017-01
  • 2017-001
  • 2017-0001
  • 20171
  • 201701
  • 2017001
  • 20170001

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

  • 17-0001
  • 2017-2801

Before importing, make sure these conditions are met:

  • The file should contain a column for the date.
  • The date should be in the periodcalc format YYYY?PPPP.
  • 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 YYYY and PPPP should not be similar to the list separator of the file.

To import a file by YYYY?PPPP 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 YYYY?PPPP.
    Column Name with YYYY?PPPP values
    Specify the column name that contains YYYY?PPPP data.
  5. Specify a folder path where the file to be imported into DMP is located.
  6. Click Import.