The Integrator Qual process object qualifies a data flow for certain conditions. Rows that match a certain qualification are allowed to pass through; rows that do not are eliminated. The Qual process object acts like a filter object, but allows boolean expressions within the qualification string. The expressions allowed include ’>’, ’>=’, ’<’, ’<=’, ’=’, ‘!’, ’AND’, ’OR’, and ’BETWEEN’, which is inclusive. The Qual does not make a distinction between numbers and characters.
Qual Attributes
| Attribute | Type | Description |
|---|---|---|
| process_type (required) |
String | Identifies the object as a Qual process object. The value of this string is "qual". |
| input (required) |
String | Defines the object from which the data flow is arriving. |
| qual_str (required) |
String |
Defines the qualification to be used to select rows. NOTE: This attribute is Qual Str in Visual Integrator. |
| case_sensitive | Boolean |
Controls whether comparisons are case sensitive or case insensitive. If the attribute is not given (it is optional), comparisons will be case sensitive. NOTE: This attribute is Case Sensitive in Visual Integrator. |
| trace_before | Sub-object | Traces data flows entering the specified object. This is equivalent to adding a Trace process object immediately before the current object. See Embedded Trace Object for more on using trace sub-objects. |
| trace_after | Sub-object | Traces data flows leaving the specified object. This is equivalent to adding a Trace process object immediately after the current object. See Embedded Trace Object for more on using trace sub-objects. |