Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: mmarinelliNode Name: Deep X-Ref
Node Category: Correlation
Use Case: Use this node to determine whether all fields match within two data sets
Tested on Release: 4.5.0
External Dependencies: None
Practical Usage Example: An example use of this node has been provided in the prototype examples graph which is released in conjunction with the prototype library. Please see that graph for a executable use case.
Node Documentation:
Functional Description:
Extends X-Ref node to not only compare the key columns, but to compare each individualfield within matched data set. Produces the left and right orphan populations, the "full" matches (all columns match),and a list of the "partial" matches (keys match, but some other columns do not). This partial match outputyields one row per unmatched column within the source data.
Parameters:
Known Limitations: None