Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Longitude and Latitude data from Excel to Alteryx

maxmd
6 - Meteoroid

Hello!

I have data sets on excel spreadsheets and I need to combine and process the data using Alteryx. I amd using Select tool to specify the columns that I need to combine but not sure what data type to assign to my longitude and Latitude data columns. I need to eventually be able to map my data points using visualization software.

 

Many thanks for any help.

 

4 REPLIES 4
CharlieS
17 - Castor
17 - Castor

Could you attach a sample of your data? That would really help the relevancy of suggestions. 

 

I assume you have  latitude field and a longitude field that you need to map. Use an Input tool to bring the data into Alteryx. A Select tool allow you change the latitude and longitude fields to the necessary numeric format. The Create Points tool in Alteryx accepts floating point (double) fields, or integers (floating points x 1000000), or floating points in other projections. Alteryx can then be used to analyse the points and produce maps/reporting on your spatial data. 

maxmd
6 - Meteoroid

Hi Charlie and Thank you for the quick reply.

In my Data set, there are several columns of different parameters and two columns of longitude and Latitude

Example of Latitude data: 35.51, 40.34, 41.04

Example of Longitude data: -98.59, -97.85, -78.99

In my select tool, I am only selecting selecting the columns that I need for my analysis and in the same time assigning the appropriate data type for each column, e.g., numerical data assigned with Int64 or 32 as necessary. For the Longitude and Latitude columns, I wasn't sure what type of data type to assign for it because originally it was assigned as V_WString. I thought to assign SpatialObj but I am not sure!

 

Is that make it a little clearer? Many thanks for your help

CharlieS
17 - Castor
17 - Castor

That info helps, thanks for following up.

 

The data you have in Excel ("35.51" and "-98.59") appears to be standard floating point values. In the Select tool, change the field type on those fields to Double. Then use a Create Points tool which will create a centroid spatial object for each record. After that, you should be able to use a Browse tool and have your points display on a map after you run the workflow. 

maxmd
6 - Meteoroid

Thank you very much. That was very helpful. I appreciate your time.

Labels