Comparing values of address by group ID with multi-row formula

Question

So my data looks like this:

group_id | address

2324252 | 4410 Henderson Blvd SE

2324252 | 4410 Henderson Boulevard SE

1909094 | 1050 N Mills Ave

1909094 | 1050 N Mills Avenue

1909094 | 1050 N Mills Ave

3425261 | 150 Broadway

3425261 | 122 Broadway

I want to compare the address values by group_id and have it flag as "Yes" if there are any different addresses per group_id. I'm stuck on implementing this in a multi-row formula but I know that's the right tool. Any help?

atcodedog05 · Answer

Hi @The_Alternator

I tried fuzzy match on yours. But

3425261 | 150 Broadway

3425261 | 122 Broadway

are treated as same since its a small change.

Hope this helps : )

address match.yxmd

rkapoor · Answer

@The_Alternator I have attached the sample workflow with your data using the Multi-Row Formula tool and applying the formula on a group_id grouping.  Take a look and see if this is what you wanted to do.

I have further used the Unique to provide you with the group_id and flag so you can identify which group_id values have the Flag set to Yes or No

You may want to use the Fuzzy Match to match the addresses that should be the same but are slightly different. Have a look at this link to help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Address-Fuzzy-Match-Issues/td-p/37309
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Selections-for-Fuzzy-Matching-on-Parsed-Address/td-p/522564

alternator.yxmd