3 Tips to make spatial data in Alteryx easy(er)

by Anna Noble

New kinds of data brings a whole new set of tools and tips into the Alteryx work space.  And new trainers for those of us at the Data School. (Thanks goes to Phil and Andre this time!) After giving you some tips to make extracting and cleaning data easier in a previous post, here’s one dedicated to the world of maps, distance, and coordinates.

1. Rename your fields!

When using the spatial tools you will often be creating new columns so make sure you use the select tool to rename them to something that makes sense.  Every time Alteryx creates a map point it automatically calls it a Centroid.  So if you are joining spatial data from multiple data sources you are going to have more than one Centroid column which is a pretty meaningless field name to begin with,  but even more so when you have two of them to confuse you!

rename1 rename2

select-tool-rename

2. Set up a default map to use in the Map Input tool

The Map Input tool allows you to input points on a map directly into Alteryx.  However when you intially open up the tool and place a point, there is no map in the visual.   You will need to select a base map form the options at the bottom of the configuration screen.   You can make sure you never have to do this steps again using this simple method.

Go to the options tool – select User Settings >Edit User Settings.

usersettings2

 

On the Dataset Defaults tab you can select a Reference Map Base as ‘Maps Powered by CloudMade’ or ‘CloudMade – Most Recent Vintage@

You can even set a location, if you know you are largely going to working with datasets from a specific country.

This will give you the same map view every time you use the tool in Alteryx.

defaultbasemap

For more on how to use the Map Input tool check out Bethany’s blog.

3. Right click quick fixes

Right click a tool and….

  • Add Browse after to view your data
  • Delete & connect around to remove a tool but maintain the connections with the tools immediately before and after it.

Right click a connection to…

  • change it’s origin or destination 

 

 

Week 2 Roundup: Tableau tips, James Eiloart and viz makeovers

1 mins read

Sun 04 Mar 2018

Week 1 roundup: Alteryx and an intro to Tableau Server

1 mins read

Thu 01 Mar 2018

3 Reasons you should follow The Data School blogs

2 mins read

Tue 27 Feb 2018

Workout Wednesday week 5: LoD defeat but I figured out the legend!

4 mins read

Mon 06 Feb 2017