Rule options - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
How Do I
Overview
Tips
Reference
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265
Option Description

Field name

Specifies the name of the dataflow field whose value you want to evaluate to determine if the record should be the template record or if a condition is met and an associated action should be taken.

Field Type

Specifies the type of data in the field. One of the following:

Non-Numeric
Choose this option if the field contains non-numeric data (for example, string data).
Numeric
Choose this option if the field contains numeric data (for example, double, float, and so on).

Operator

Specifies the type of comparison you want to use to evaluate the field. One of the following:

Contains
Determines if the field contains the value specified. For example, "sailboat" contains the value "boat".
Equal
Determines if the field contains the exact value specified.
Greater Than
Determines if the field value is greater than the value specified. This operation only works on numeric fields.
Greater Than Or Equal To
Determines if the field value is greater than or equal to the value specified. This operation only works on numeric fields.
Highest
Compares the field's value for all the records group and determines which record has the highest value in the field. For example, if the fields in the group contain values of 10, 20, 30, and 100, the record with the field value 100 would be selected. This operation only works on numeric fields. If multiple records are tied for the longest value, one record is selected.
Is Empty
Determines if the field contains no value.
Is Not Empty
Determines if the field contains any value.
Less Than
Determines if the field value is less than the value specified. This operation only works on numeric fields.
Less Than Or Equal To
Determines if the field value is less than or equal to the value specified. This operation only works on numeric fields.
Longest
Compares the field's value for all the records group and determines which record has the longest (in bytes) value in the field. For example, if the group contains the values "Mike" and "Michael", the record with the value "Michael" would be selected. If multiple records are tied for the longest value, one record is selected.
Lowest
Compares the field's value for all the records group and determines which record has the lowest value in the field. For example, if the fields in the group contain values of 10, 20, 30, and 100, the record with the field value 10 would be selected. This operation only works on numeric fields. If multiple records are tied for the longest value, one record is selected.
Most Common
Determines if the field value contains the value that occurs most frequently in this field among the records in the group. If two or more values are most common, no action is taken.
Not Equal
Determines if the field value is not the same as the value specified.

Value type

Specifies the type of value you want to compare to the field's value. One of the following:

Note: This option is not available if you select the operator Highest, Lowest, or Longest.
Field
Choose this option if you want to compare another dataflow field's value to the field.
String
Choose this option if you want to compare the field to a specific value.
Value

Specifies the value to compare to the field's value. If you selected Field in the Field type field, select a dataflow field. If you selected String in the Value type field, type the value you want to use in the comparison.

Note: This option is not available if you select the operator Highest, Lowest, or Longest.