Picking only one outcome from multiple outcomes after a join

[asanjuan]

Hi, I run calculations on materials where I join them to multiple file references that can result in more than one outcome. When this happens I get a result where the material inadvertently appears multiple times (cartesian join?) in my final report. The unique rows (Cust Item #) need to stay as is, those rows are done. The highlighted rows, in this example at least, would need to output only the rows that say "Review" and "Check source vendor". Any help would be appreciated?  Thanks!

[mceleavey]

Hi @asanjuan ,

if you could provide the data we can help.

M

[asanjuan]

Here you go. Thank you so much!