Filter Data from 1 stream using field from another

[hellyars]

I want to compare a set of Actual results to the Expected results for a given year.  

The Expected results table includes multiple years.   What is the most efficient way to filter the Expected results using the year (Field 1) from the Actual results stream?  I used a Join tool to filter the data, but it creates duplicates.  Is there a better way?

[AngelosPachis · Accepted solution]

Hi @hellyars,

In your join tool, can you try joining on Field 2 as well? That should remove the duplication as it will increase the constraints of your join.

Cheers,

Angelos