Forum Discussion

kumar25's avatar
kumar25
New Contributor II
2 years ago
Solved

Find unmatched data using join

Hi, I have 2 input streams, i used inner join and fetched the matching data, also to capture the unmatched data i used- Unmatched data to error view option. I am able to find the get the unmatched/...
  • koryknick's avatar
    2 years ago

    kumar25 - I suggest you use Outer join type and use a Router to see which records matched based on missing key values