Fuzzy Address Match

[Madhur12]

Hello! I am new to Alteryx.

I have address columns in this excel file. I wan to combine these columns and make it one combined address column. After that I want to run a fuzzy match to check for any duplicate address existing. Would be great if anyone can help me with this. Thanks! Attaching my file.

[Raj]

Just use the formula tool to concatenate and then use data cleansing tool to remove any extra spaces>

Also refer to the sample attached to the fuzzy match tool.
you will get an idea

else i will share the workflow once i get back to my device.
please let us know if you were able to solve.

[Madhur12]

Thanks, Raj! I used concatenate and could combine the addresses. Where I am stuck is when I try to run fuzzy match between the rows. I want to get the rows which fuzzy match one after the other but I am not getting the desired result. 

[CoG]

I'm not exactly sure what output you're looking for. I chose to output unique list of "duplicated" addresses based on 80% threshold fuzzy match, but you can change as needed to obtain desired result.

[CoG · Accepted solution]

Here is an updated workflow that sorts, based on your reply to Raj.

[Madhur12]

Thank you so much, Andrew! It worked. 

[bpompi]

Placekey is a really great solution to this sort of problem. Also have a super generous free tier!