This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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
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.