Filtering out Multiple Occurrences

Hello! I am new to Alteryx, and I have a Question.

I have a sample data set attached. I am looking for the best way to accomplish the following.

I am looking to remove data that has multiple occurrences for only name and date like the excel attachment.

If Amy Shows more than 1x for that specific date, then remove else keep. I can't necessarily do the unique tool since the in and out columns have different data.

Please see attachment and thanks in advance.

Alteryx Sample Data.xlsx

Workflow

Help

Accepted answers

FinnCharlton

Hi @CsmithData31,

I don't think it's 100% clear what you are trying to do, but if you are trying to exclude ALL names that occur more than once in a specific day, look into the "Only Unique" CReW Macro:

You can download it here: http://www.chaosreignswithin.com/p/macros.html

All comments

JamesCharnley

@CsmithData31 You can use the multi-row formula tool to look up or down rows. In this instance I can group by name and then check to see if the Date is the same as the row before. If it is, then I'll tag it something different to be filtered out later.

FilterDates.yxzp

Felipe_Ribeir0

Hi @CsmithData31

This formula inside of a filter seems to do the job:

[In] = 1 and [Out] = 1

inout.yxmd

FinnCharlton

Hi @CsmithData31,

I don't think it's 100% clear what you are trying to do, but if you are trying to exclude ALL names that occur more than once in a specific day, look into the "Only Unique" CReW Macro:

You can download it here: http://www.chaosreignswithin.com/p/macros.html

CsmithData31

Hello! Thanks for that! Is it possible to create a new column to identify rows that have multiple occurrences. I want to remove the name Amy all together if that makes sense.

CsmithData31

This is perfect! Thank you for your help

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703