community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Parsing an Address or Geographic Location from a stream of Data

Alteryx Partner

Hello Community Members,

 

Recently I have been working with a file that has only one column of Data containing all the details required. For example: name, job role, company name, location and along with these, a lot of dirty data that I do not require in my final output so I have filtered it out.

While cleaning my data and putting it in the format I need, I came across with a field that is a geographic location in US, say, field with only 'Greater New York Area' as data and there are other locations as well but all pertaining to USA only. I want parse these fields only which have some kind of location in to USA only.

CASS option is there but I have not used it till now.

Any Method to do so would be appreciated.

Thanks!

 

 @SeanAdams @MarqueeCrew Would love to hear from you guys. :)

Alteryx Certified Partner
Alteryx Certified Partner
You might want to use the google api and send the data to them. Their output is a parsed set of data.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx Partner

Thanks @MarqueeCrew for suggesting me the 'API' method. I will definitely give it a try.

But before trying it, i would like to elaborate my problem a bit.

 

 

I have Census data that I downloaded from Legacy Downloads Section.

Kindly have a look at below Data.

this is the data that I have gotten from Linked in and all of the data is in single column.

I want to identify those rows which have some kind of location (in US only.) For Example, Greater New York City Area here.

I wanted to use CASS or US Street Geo-coder tool but I am Getting an error saying, CASS Data-set not installed on this machine or No Geo-coder Data-sets Available.

Could you please guide me on how to get it sorted.

I thought Data-sets referred in above mentioned errors are Census ones.

LinkedIn Prob Snapshot.png

Alteryx Partner

UPDATE: 

please refer to below thread if you have similar problem:

Clarification on the topic TravisR and refinement by PeterGoldey

 

For now, I am going to try the method recommended by @MarqueeCrew

I will keep this thread updated with results.

Thanks!

 

Labels