Process objects ('PROC') manipulate the data flow by controlling and filtering the data before it passes to an output object. The filters to control the data that passes through include functions such as lookup tables that expand data columns, joins that merge multiple data objects together, sorts that reorder data, and calculations that transform data. Multiple process objects are allowed. Use process objects to:
- Rename columns using the Alias Process Object.
- Identify break levels in the input flow using the Break Process Object.
- Perform various calculations using the Calc Process Object.
- Parse fields into tokens and multiple rows using the Chop Process Object.
- Concatenate multiple input flows together using the Concat Process Object.
- Execute system commands using the Execute Process Object.
- Expand a single row into multiple rows using the Expand Process Object.
- Filter rows in a data flow that match specified criterion using the Filter Process Object.
- Perform SQL-style joins using the Join Process Object.
- Combine two input flows to form a single output flow using the Lookup Process Object.
- Generate additional records from a subset of records resulting in all possible binary combinations of the input rows using the Multiply Process Object.
- Qualify a data flow based on specified conditions using the Qual Process Object.
- Define new calculated columns based on the entire set of input rows using the Rank Process Object.
- Rotate information from multiple columns into multiple row using the Rotate Process Object.
- Sort the data flow based on a set of columns and change the order in which the data appears in subsequent objects in the data flow using the Sort Process Object.
- Allow SQL statements to be run against an ODBC accessible database using the SQL Process Object (Windows and UNIX).
- Combine rows that are identical for a set of Dimension columns, and optionally summarize numeric columns using the Squash Process Object.
- Simplify the creation of time period columns based on a set of rows using the Timeseries Process Object.
- Debug scripts using the Trace Process Object.
- Convert a single column into multiple columns using the Unrotate Process Object.