Excel Countif function in Alteryx

[MochaMatchaMeow]

Hi, I hope someone in the community can help me with the problem here.

My data is a set of finished good product and its components.

I'm trying to remove duplicates records from level 1 if it appears in level2.

I was able to do it in excel by using countif function (created column E to H to accomplish), but couldn't figure out how do to this in Alteryx.

thanks.

[apathetichell]

summarize/group-by/count -> filter -> if count >1 -> join. the records joined are the ones with duplicates.

to undupe you can - use summarize tool in group by (and select the fields you'll use downstream)

unique tool (if you must)

[MochaMatchaMeow]

Can you share the work flow? I tried to do it follow your steps, but all the count is 1. Am I missing something? Please see my screenshot attached.

[binuacs]

@MochaMatchaMeow one way of doing this