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.
