Alteryx tool

Hi,

I am trying to get some help. Please see the attached snapshot. There are cases where same IDs have the same addresses(ID:10) and there are also cases where same IDs have different addresses(ID:30). I am trying to filter out the same IDs that have different addresses like ID:30. Is there a way to do it in Alteryx? Thank you in advance!

Question.docx

Expression

Accepted answers

TerryT

Ah, I misunderstood.

Perhaps this configuration will help:

aparna0208.yxmd

BrandonB

Take a look at this workflow. It splits into two populations, one that shows IDs with multiple addresses and one that shows the records with the same addresses.

Address check.png

address check workflow.yxmd

All comments

TerryT

Hi @aparna0208

I think you want the Unique Tool:

Cheers!

aparna0208.yxmd

BrandonB

When you say filter out the same IDs that have different addresses, what would your desired outcome be? Would you like both of the rows for ID 30 removed from the dataset?

aparna0208

Not really! Just kind of some indication that addresses are different for the IDs so that I can focus on the ones that have same addresses

aparna0208

Thanks for your inputs! I already tried this method but the problem is if I use this, I am not sure as to which IDs had different addresses. I just want one result set indicating IDs that have same and different addresses

aparna0208

The thing is it's not duplicates that I am trying to remove. ID is indicating a contact ID and that contact has two different registrations and in some cases one registration. When contact is registered twice then there are cases where it has same address and also in some cases two different cases. So I am just trying to look for the ID which is same but address is different.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335