Advanced Mapping Definition Subtask
Use this subtask to specify more options for defining the key fields that map from Cobra to Costpoint.
This subtask changes to match the Cobra key fields in the Define Mapping table window. For example, if WBS is specified in the Cobra Key Fields field, the Advanced Definition for WBS will display on the selection button.
Advanced Mapping Definition
Use the field and options in this group box to specify prefix or literal preferences for the results data.
Field | Description |
---|---|
Prefix/Literal |
Enter a prefix or literal. The value in this field is added to the fields concatenated below. If no fields are expressed, then this effectively becomes the charge that is assigned to all records that fit the rule. |
Use Part of the Above Result |
Select this check box to choose a substring from the result of the advanced mapping definitions. |
Starting From Position |
Enter a starting point for a substring of the result. |
Ending Position |
Enter an ending point for the substring within the result. |
Length of Final Result |
This field displays the possible total length of the result. If the Use Part of the Above Result check box is cleared, you can enter a value in this field. The data values are truncated at this length. |
Advanced Mapping Definition Details
Use this table window to specify more detailed options for defining key fields.
Field | Description |
---|---|
Order Number |
Enter the order number in which this row's information is placed into the result. |
Field |
Enter, or click to select, a column name. |
Description |
This field displays the descriptive name of the selected Field. |
Table |
This field displays the table related to the selected Field. |
Starting Character Position |
Enter a value that designates the starting point you want to use when selecting a potential subset of the selected field's data. |
Ending Character Position |
Enter a value that designates the ending point you want to use when selecting a potential subset of the selected field's data. |
Characters Added to the End |
Enter up to four characters to be added at the end of the filed. The primary use of this field is to be a one character delimiter between field data values. |
Subtask
Subtask | Description |
---|---|
Result Test | Click this link to open the Result Test subtask and view sample data that satisfy the specified criteria in the Advanced Mapping Definition Details table window. |
- Related Topics:
- Result Test Subtask
Use this subtask to view sample data result that satisfy the criteria specified in the Advanced Mapping Definition Details table window.