How to add sub-items while importing data into the table.

In the Import Data wizard in IBM Cognos Incentive Compensation Management you can add a new field to columns. Sub-items are a segment of the data in an existing column.

1. In step 5 of the Import Data wizard right-click any data source column to add a sub-item of that field and click Create New Field.
2. Type a new field name.
3. To add a sub-item complete one of the following steps:
   • Select 'Create a sub-item by selecting characters to include and type the selection'. For example type 1-5 if you want to include the first five characters of the field.
   • Select 'Use the following delimiter to create a sub-item for this field' type a delimiter and select the Index. For example if you have a Name field that contains first and last names separated by a space (for example Dan Huddle) and you want to add a First Name field you would type a space as the delimiter and select an Index of 1 since the first name is the first item before the delimiter.
   • 
   Important: You can confirm if your selection is correct by looking at the example in the Create New Field window.
   ?
4. Click OK.