Creating households

[Nsantana]

What would be the best way to create households?

I have a list of customer ids and addresses but the addresses can vary a bit. 

How can I group customers with almost identical addresses into a household?

[BS_THE_ANALYST]

@Nsantana Have you got some sample data?

[Nsantana]

Please see attached. The HH column is the desired output.

[Nsantana]

Please see attached. The HH column is the desired output. 

[danilang · Accepted solution]

Hi @Nsantana 

Here's one way you can do it.

Use a formula tool to build the complete address without the zip code.  Perform a Fuzzy Match on address and zip and then use a Make Groups tool to extract the chains of connected items in the fuzzy match output.  Join to the original data and add in the HH# calculated using the Summarize and Record ID tools.

I added an extra row to add a second resident to the group 2.

Dan  

[Nsantana]

This is perfect! Thank you!!