Matching Two Columns

[Kevin_Coyle]

Any ideas on how I might accomplish the screenshot? Having trouble understanding the best way to architect like

if A matches X and Z
and B only matches X

Then go with A and discard B.

[yscias]

Could you give a bit more explanation? Your post and your image seems to conflict each other’s information, so im not exactly sure what you would want.

[Kevin_Coyle]

Thanks @yscias - apologies on the typo. Use case is to get an understanding of tool that have overlapping capabilities.

If Tool A has the Capability of X and Y. And Tool B has the Capability of Y, then I’d like to return Tool B so that we can consider removing since its capabilities are already covered by A.