Preventing Duplicate Counties with the Join Tool

I created a workflow to show where we earned our revenue down to the street address. I am trying to populate a "county" column by using the join tool to match the zipcode from my revenue document to a zipcode database. However whenever one zipcode exists in two different counties it creates duplicate values (see screenshot) Is there a way to tell Alteryx to take the first county that has been applied to a zipcode and apply it to the rest of those zipcodes?

Any help is greatly appreciated.

Workflow

Output

Help

Join

Accepted answers

amazz24

Find and replace could also be used in this instance instead of using the join tool.

In order to use the Join tool, you will need to have a unique list of zipcodes, otherwise multiple results will populate in the output, which a Summarize will do, as identified by @echuong1

All comments

echuong1

I'd use a summarize tool with a group by on zip code and then use the first county. This will give you a unique list of zip codes and the first country associated in your list.

Use this as your reference table within your join.

amazz24

Find and replace could also be used in this instance instead of using the join tool.

In order to use the Join tool, you will need to have a unique list of zipcodes, otherwise multiple results will populate in the output, which a Summarize will do, as identified by @echuong1

TommyParker

This worked, thanks for your help!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335