Excel Countif function in Alteryx

Question

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.

image.png

IgnoreDuplicateRecord.yxmd

binu_acs · Answer

@MochaMatchaMeow one way of doing this

IgnoreDuplicateRecord.yxmd

MochaMatchaMeow · Answer

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.

image.png

apathetichell · Answer

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)