VI Qual Process Object

The Visual Integrator (VI) Qual process object sets qualification conditions on a data flow. Rows that match the qualification conditions pass through the data flow. Rows that do not match the qualification conditions are eliminated.

Icon for the VI Qual process object

The Qual process object acts like a Filter process object, but supports Boolean expressions within the qualification string. The Qual object does not make a distinction between numbers and characters.

The Qual process object has Closedthree panes where you set attributes.

Example showing all panes for the Qual process object

You set attributes for the Qual process object in the Closedobject attributes pane.

Example of the VI Qual object attributes pane

Attribute Description
Input

Defines the object from which the data flow arrives. Use one of the following methods to attach the Qual object to an input data flow object:

  • Right-click the input data flow object, and click New Object after this > Process > Qual.

  • Place the Qual object on the task flow, and click its Input attribute's browse button. Move the pointer to the task flow, and note that a dotted-line connector is attached to the Qual object. Attach this connector to the input data flow object.

    NOTE: The Qual object's Input attribute is now populated with the name of the input data flow object.
Case_Sensitive

Controls whether comparisons are case-sensitive.

  • true—Comparisons are case-sensitive.
  • false (default)—Comparisons are case-insensitive.
Qual_Str

Defines the qualifications string (required).

Supported operations include: >, >=, <, <=, =, !, AND, OR, and BETWEEN, which is inclusive.

For example:

Names>"C"

Returns all names that start with the letter C or beyond but eliminate names that start with A or B.

Each object has an area where you can enter comments.

It is a DI best practice to enter a note for every object in a VI script. You can set a VI preference to give a warning for each object without a note. For more information, see Visual Integrator Preferences.

ClosedQual process object with comments

Example of comments for VI Qual object

The ClosedQual column grid displays the input flow columns.

Example of VI Qual object column grid

Attribute Description
Input Column Displays the name of each input column. This attribute is read-only.

NOTE: You can double-click an input column name to enter it into the Qual_Str attribute.
Source Object

Displays the name and object type of the source object. Double-click the Source Object for a column to change the task flow focus to that object.