Join(1) Manual Page

Input

1. Stream of arbitrary records.

2. Record set as generated by the lookup tools.

Output

The input stream with fields from the record set appended.

Join a record from a set and a record of a stream if the value of a single user defined field en each, match.

A typical example would be to join bandwidth measurements generated by the Bandwidth Measurement Tool with the output of the HTTP Parser Tool. In this case it would be natural to match ip_address of the bandwidth set and client_ip of the HTTP output. The resulting records would contain all information supplied by the HTTP Parser, and in addition a measurement of the requesting client's bandwidth usage.

Stream Join Field

Name of the stream field that should be matched against the Set Join Field.

Set Join Field

Name of the set field that should be matched against the Stream Join Field. The Set Join Field is removed from the output. All other fields from the set are appended to the output stream, and filled with the values of the matched record.

Outer join

If no record is found in the record set and Outer Join is clicked, then the record set field is added with the value NULL. If Outer Join is set to False, the records without match in the set are discarded.