Takes two inputs and performs a cross-reference against the metadata of the inputs, to find the common fields and types of the two inputs.
This node takes two inputs (Left and Right), and performs a cross-reference against the metadata of the inputs, to find the common fields and types of the two inputs. It segregates each of the fields into one of three outputs. The first (Left Orphans) is for fields that only exist in the first input, and the third (Right Orphans) for fields that only exist in the second. The middle output (Matches) will contain a record for all fields that exist in both inputs. For each field on the inputs, the record will contain FieldName, LeftFieldType, RightFieldType, and TypeMatched, where FieldName is the matched name, the types are from each respective input, and TypeMatched is a Boolean that will be true if the two match.
Inputs and outputs
Inputs: Left Input, Right Input
Outputs: Left Orphans, Matches, Right Orphans.