-
Click Create New Column Header from the Column Headers pane toolbar to open the Create New Column Header dialog box.
-
In the Column header pane, select the column type required from the Column Type list box. The options on this dialog box differ for the column type selected. For more information, see Column types.
-
Provide a name and any other details required for the selected column header type, such as in the Column Header Text box.
-
Select the Multiple Values Column checkbox if any column in your CSV file contains multiple values.
For example, if a tag has to be related to many secondary disciplines (such as MECH, ELEC, CIVIL), you can separate the values in the CSV file using a comma, and then select this checkbox when creating the column header.
The Multiple Values Column option is supported for Physical and Computed Column types only. For Computed Column type, the function can return multiple values. However, it does not support multiple values as input.
-
Select the Ignore properties with blank values option if you want properties with blank values in your CSV file to be ignored.
-
From the Add New Mapping options, choose whether to map the new column header to:
-
an object using a class definition
-
an object using an interface definition
-
a property
-
a relationshp
-
a relationship property
-
-
If you do not want to add prompted values for the Prompted API, Prompted, and Prompted Picklist column types, select the Value for this column can be blank option. A prompted value is then not needed when you create a job in Data Validator Job Management.
-
When you select the Ignore properties with blank values option for the Prompted API, Prompted, and Prompted Picklist column types, a prompted value is not needed when you create a job in Data Validator Job Management, and the property will not be instantiated in the target system.