Work Nodes

The Append Node. This node allows you to append two input data streams into one output data stream. The append will combine both input streams such that the Input1 rows will be written out followed by Input2 rows given that both input streams contain matching column types.

The Derive Node. This node allows you to derive new output column data. You can perform simple mathematical expressions based on the input columns data. The resulting data is processed on a row-per-row basis.

The Distinct Node. This node allows you to filter out rows that have common data values for the chosen columns. The output data from this node will contain distinct rows.

The ExecCmd Node. This node allows you to run external applications after a OutputFile node has executed. It can be used to run an external application to further process the output data file or just trigger another application.

The Filler Node. This node allows you to fill in missing data contained in the input data. You replace the ? value with a supplied value or on the Min,Max or Average value of valid data in the specified columns.

The Filter Node. This node allows you to filter the input data and pass the remaining data to the output. The filtering is based on selecting which columns you wish to pass to the output.

The Merge Node. This node allows you to merge two input data streams into one output data stream. The merge is performed on a row-per-row basis or by key merge performing a left-outer-join. The method is determined on what input columns are fed into the merge node.

The Sample Node. This node allows you to sample the input rows and pass them out to the output. You have several options on how the sampling is performed.

The SelectRow Node. This node allows you to select which rows of data you wish to pass through to the output. This is done by setting up logical expressions based on what the data values in given columns are.

The Sort Node. This node allows you to sort the input data (row wise) based on selecting a input column. You also have a choice of sort methods.

The VBScript Node. This node allows you to process data by creating your own Visual Basic Script code. The Visual Basic Script code is executed for every row inputed into the node. You can specify new output data by defining your own columns.