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?
Solved! Go to 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