Append

Append Node icon

The Clario Append node is used to ‘stack’ two data streams with the same attributes and file layout, resulting in a combined data stream with all rows from both data streams. The node connector can be connected to a variety of nodes, (e.g. Read File, Aggregate, Outliers, Missing, etc.), but requires two valid streams of data with the same attributes, formats, and layout.

Configuration

The Append node has only one configuration tab.

Configuration Tab

Configuration Tab

No user input is required on the Configuration Tab. The Configuration Tab simply shows the attributes coming from the two data streams to append together.

The ‘Top Connector’ list box displays the attributes of the data stream connected to the top input node link connector, and the ‘Bottom Connector’ list box displays the attributes of the data stream connected to the bottom input node link connector. The user should verify that both data streams contain attributes with the same name, same type, and appear in each data stream in the same order. Attributes that do not meet these criteria will be highlighted in red.

Note

The ‘Top Connector’ data stream definition will be used to define the output data stream metadata that is passed on to subsequent nodes.

Results

There are no results for the Append node. It is assumed the Append node will be connected to another node to reduce variables, model, or otherwise analyze the newly expanded dataset.

Output Stream

The new appended dataset is ready for immediate use in various nodes located throughout Clario. The data can be exported using the Write File node and can then be used again by using the Read File node.