Target data

If you are going to load target data, all these data columns must exist in this order, from left to right, in the .txt or .csv file:

• PERIOD_ID
• PERIOD_NAME
• UNIT
• UNIT
• SCENARIO_ID
• SCENARIO_NAME
• PLANOBJECT_ID
• PLANOBJECT_NAME
• VARIABLE_ID
• VARIABLE_NAME
• Amount

If you are loading measure data, the variable_ID=0 and Variable_NAME is Success. If loading variable data, use the ID or name as in the Variables table.

The column names are optional, but not the columns themselves, even if they do not have values. If you are loading data by ID, then all _ID columns (PERIOD_ID, UNIT_ID, SCENARIO_ID, PLANOBJECT_ID, and VARIABLE_ID) must have values. Or, if you are loading data by Name, then all _NAME columns (PERIOD_NAME, UNIT_NAME, SCENARIO_NAME, PLANOBJECT_NAME, and VARIABLE_NAME) must have values. The Amount column is the data column; it does not need values.