This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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
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.