INCLUDE EXCLUDE DEFINITION SUBTASK

Use this subtask to define the rules for including or excluding rows using row identification specifications, which are based upon specific columns and the data value within those columns.

Rule

This column must start at "1" and cannot skip any numbers. Enter as many rules as needed to exclude or include rows of data from processing.

If you enter rule numbers that are not in sequence, you must fix them before saving source file data.

If you fail to define any inclusion or exclusion rules, all input rows are considered available for processing.

Column

Use this column to identify the column that Costpoint uses to determine whether to include or exclude rows. The column number value must be greater than zero.

Column Data Value

Use this column to define the exact data content Costpoint uses to determine whether to include or exclude rows. This value must match the input file data pattern exactly.

Include/Exclude

Use this drop-down list to determine whether to include or exclude rows based on the content. Valid options are:

• INCLUDE

• EXCLUDE

And/Or

Use this drop-down list to specify how to handle multiple rules. The selections are:

• AND — This option is not available at this time.

• OR

Only OR is currently supported.