VI Process Objects Overview

You use the Visual Integrator (VI) process objects to manipulate and transform data in the workflow. The table below describes each process object, and links to a reference topic that details the attributes for each object type.

Visual Integrator Process Objects

Process Object	Description
Alias	Renames columns. See VI Alias Process Object.
Break	Identifies break levels in the input flow. See VI Break Process Object.
Calc	Performs various calculations on data. See VI Calc Process Object.
Chop	Chops input into tokens. See VI Chop Process Object.
Concat	Concatenates multiple input flows. See VI Concat Process Object.
Execute	Runs system commands. See VI Execute Process Object.
Expand	Expands a single row into multiple rows. See VI Expand Process Object.
Filter	Filters rows in a data flow that match specified criteria. See VI Filter Process Object.
Join	Performs SQL-style joins. See VI Join Process Object.
Lookup	Combines two input flows to form a single output flow. See VI Lookup Process Object.
Multiply	Generates additional records from a subset of records resulting in all possible binary combinations of the input rows. See VI Multiply Process Object.
Qual	Qualifies a data flow based on specified conditions. See VI Qual Process Object.
Rank	Defines new calculated columns based on the entire set of input rows. See VI Rank Process Object.
Rotate	Rotates information from multiple columns into multiple rows. See VI Rotate Process Object.
Sort	Sorts the data flow based on a set of columns, and changes the order in which the data appears in subsequent objects later in the data flow. See VI Sort Process Object.
SQL	Allows SQL statements to be run against an ODBC-accessible database. See VI SQL Process Object.
Squash	Combines rows that are identical for a set of dimension columns, and optionally summarizes number columns. See VI Squash Process Object.
Timeseries	Simplifies the creation of time period columns based on a set of rows. See VI Timeseries Process Object.
Trace	Helps to debug scripts. See VI Trace Process Object.
Unrotate	Converts a single column into multiple columns. See VI Unrotate Process Object.