Longitude and Latitude data from Excel to Alteryx

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.

Help

Accepted answers

CharlieS

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.

All comments

CharlieS

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703