Street address to building/store name

[Divi]

I have a bunch of data with just the street addresses. I have to transform these addresses to the exact building/store names. I DO NOT want longitude/latitude values, just the building name.

Is there any tool for this other than the Address tools? How can I proceed further?

For example, My input data is as below;

raw_store

769 DONALD LYNCH BLVD MARLBOROUGH MA 01752 USA

7677 E BROADWAY TUCSON AZ 8571

I want the output to be:

raw_store	clean_Store
769 DONALD LYNCH BLVD MARLBOROUGH MA 01752 USA	BEST BUY
7677 E BROADWAY TUCSON AZ 8571	THE HOME DEPOT

How can I link GOOGLE API for the address lookup? Or is there any other easy way to handle this?

Thanks.

[AmeliaG · Accepted solution]

Hi @Divi,

Thanks for your question! There could be a few different approaches:

1. License Dunn and Bradstreet data from Alteryx - as part of this data package you will have access to a 'Business Match' tool which will use address data in order to link your addresses with the corresponding firmographic data which includes the business name and much more!

2. Build an API connection to pull data from Google. This is a bit more involved, but the steps for making an API connector are outlined in this community article series. 

Hope this helps!

Amelia