Specifying CSV Column Types

Each CSV file type defines a set of required columns and optional columns. The CSV file can contain columns that are not used by the Network Model wizard. Columns can be in any order but the Network Model wizard requires that you specify their types so the wizard knows how to interpret them. Specify the column type using one of the following methods:

• Specify the column type in the header of the CSV file itself, prior to launching the Network Model wizard. For instructions, see Specify the Column Type Using a Header.

• While running the Network Model wizard, assign the appropriate column type for each column in the Select Column Headers panel. For instructions, see Assign the Column Type in the Wizard.

Columns not used by the Network Model wizard must be assigned the column type Ignore. Only columns of type Ignore and Category URI can be repeated in the CSV file. For all other column types, only one instance of the column type can be assigned in the file. If duplicate columns of a non-repeatable column type exist in the CSV file, one of the columns should be assigned the Ignore column type. In a zones CSV file for example, if two name columns appear in the CSV file, assign one to the Name column type and the other to the Ignore column type.