So my data looks like this:
group_id | address
2324252 | 4410 Henderson Blvd SE
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 | 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?
@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-Parse...
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 : )