Countifs to Alterxy Solution

[ewassell]

I need a filter for Employee names and any transaction associated with them if they have a Bonus transaction in the file. See attached sample.

Jones, Tyler has many lines of transactions one of them being Bonus.  I want to see all of Jones, Tyler transactions then.  I don't want to see Smith, Elina because she has no transactions with Bonus in it. 

I have included the Countifs (first column) that I use in Excel. I can't figure out how to do this in Alteryz.

The output of the file should only include the lines that have a 1 in the first column. 

[NMangera · Accepted solution]

Révélation

The last tool (select) is strictly not necessary as it is being used to 'tidy' the final output.

[ewassell]

Thank you so much! This worked beautifully!