Alteryx Designer Ideas

When you use Create Points tool - you then almost always need to use a Select tool to rename that point.

Can we please add a single text field to the Create Points tool - which would then allow us to create and name a point in one step?

 

The guide line of Shape File is below. They recommend that you use only letters and numbers.

 

"Spaces and certain characters are not supported in field names. Special characters include hyphens such as in x-coordinate and y-coordinate; parentheses; brackets; and symbols such as $, %, and #. Essentially, eliminate anything that is not alphanumeric or an underscore."

https://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/fundamentals-of-adding-and-deleting-f...

 

But many GIS tools can read and write 2 byte field name at Shape File.

(e.g. QGIS https://qgis.org/en/site/index.html)

And Esri Japan says Shape file can use 2 byte field name.

https://www.esrij.com/gis-guide/esri-dataformat/shapefile/

 

We want to use 2 byte field name at Shape File on Alteryx Designer.

(e.g. UTF-8 , Shift-JIS )

 

 

Thanks,

Kajitani

 

Tableau v2018.3 introduced multiple table extracts. These are particularly useful for fact table to fact table joins and fact table to entitlement table joins for row-level security where the number of rows created by the join and/or size of join results would be prohibitively large. Also they are useful for fact table to spatial joins where we might have multiple spatial objects (for example custom province/district/health facility catchment) for each row of fact table data.

 

So in Alteryx I'd like to be able to specify 2+ tables & their join keys and then write out a .hyper multiple tables extract.

 

Jonathan

 

We now have the ability to output to an ESRI File Geodatabase, which is great, but it only allows you to output it to the WGS84 coordinate system.  I would like to have the same functionality to export it to other projections or coordinate systems similar to the ESRI Shapefile or ESRI Personal Geodatabase output tools (we specifically need NAD83 but I'm sure others would like other options as well).

As mention on this post here I would love the ability to change the map provider to any other map service (Mapbox, google, some other paid option). This could be achieved by adding a "Map Severs" option in the default configuration and where you put in the map server details.

I'm plotting ship's routes on a map by using the Poly-Build tool to create a Sequence Polyline, the source field is a daily snapshot of a ship's position, the sequence is the date. This works well until the ship goes off the map, i.e heading west in the North Pacific to Japan.  Rather than wrapping the line around the world, it draws an ugly line across the map:

 

 

I've seen some super clever WFs on here where people have manipulated coordinates to stop this happening, but rather than me having to do that (and probably getting it wrong), could you make the Poly-Build tool map sensitive?

 

 

I would like to specify two points on a map and have Alteryx create a spatial object that represents the best route from one point to another given some parameters such as quickest route, or shortest route.

I am bringing this over from this post.

 

It would be really cool to have a workflow that you could configure to your server that we could schedule to pull down the new Cass updates and install them. Since they have to be reinstalled every two months, it would help to manage that.

 

I think that the data updates are set up with an FTP site, Cass could be done essentially the same way. Download it there and then use the command module to run the install? I may be over simplifying the process but it seems like this is something that Alteryx could tackle.

Hey Alteryx Community,

 

I think Alteryx uses the Tableau SDK to create tableau data extracts, TDE's. Since Tableau 10.3, there is functionality to connect to spatial files in Tableau (.shp). These shapefiles can be converted to an tableau data extract within Tableau. The tableau SDK has this functionality as well, but Alteryx does not support it yet. The suggestion is to add this functionality. See https://onlinehelp.tableau.com/current/api/sdk/en-us/SDK/tableau_sdk_samples.htm for the SDK link. 

 

Spatial TDE's are way smaller (3gb .shp went to 140mb TDE) and way faster.

 

 

Thanks,

Marco 

Would be nice to have 3 outputs on Spatial Match, same as a standard Join.  Output unmatched objects from the Universe input.

Thanks!

In Designer user settings, you have the option to set a default dataset for the reference base map. This is a fantastic feature when working with spatial objects. My suggestion is that this feature should persist when viewing .yxdb files outside of Designer workflows. 

 

When I'm browsing a folder of .yxdb files that contain spatial objects, clicking on those files opens a viewing/browse window outside of Designer. Unfortunately, the base reference map setting does not currently transfer and must be reelected each time a file is opened. I would like suggest that this setting persist in this situation. 

In order to fully take advantage of Alteryx spatial features it would be great to have the ability of using Openstreetmap extract files natively.

While there are some sources available in SHP format they tend to be heavily cut down in detail, while the native OSM and PBF have the full feature set.

 

As it's an open format licensing shouldn't be an issue and it may pave the way to new features.

 

What do you think?

Let's "Elevate" Alteryx to enter the Euclidean space and add the Z-Coordinates to our spatial tools!

 

We primarily work on tracking people through a store or any physical space and extract shopping trip information such as areas visited, dwell time, etc. This shopper track information consists of a series of X,Y coordinates which are also used to plot heat maps based on density of points in a given area.

 

I have been using a workaround due to the lack of cartesian coordinate support in spatial tools - involving converting cartesian values to Lat., Long. by dividing X,Y values by 10,000. This approach works fine for finding spatial matches between points and polygons. However, when using something like a heat map tool which requires Grid Size and Max Distance in Miles/Kilometers, since there is no support for smaller units of distance, you will not be able to generate a heatmap data file.

 

In addition to adding support for Cartesian coordinates, it would also be helpful to provide an option to load in a Floorplan/Image as Base Map when browsing Spatial tool results.

When calculating distance from a single point (or a list of points) to many other points, it can require a lot of processing time to append the single point into the same table as the multiple points (especially with very large datasets).  Seems it would be more efficient to allow the single point as in input to the distance tool and bypass the timely append step.

I periodically consume data from state governments that is available via an ESRI ArcGIS Server REST endpoint. Specifically, a FeatureServer class.

 

For example: http://staging.geodata.md.gov/appdata/rest/services/ChildCarePrograms/MD_ChildCareHomesAndCenters/Fe...

 

Currently, I have to import the data via ArcMap or ArcCatalog and then export it to a datatype that Alteryx supports.

 

It would be nice to access this data directly from within Alteryx.

 

Thanks!

Please add support to read and write spatial data from a SpatiaLite database.  ESRI and QGIS have supported this format out of the box for quite a while.  We have a mixed use environment Alteryx, ESRI, Mapinfo and QGIS and would like a common file based spatial format.  You already support SQLite, its container, so expanding to the SpatialLite spec should be a no brainer.

 

https://en.wikipedia.org/wiki/SpatiaLite

First: Including mapbox in 2019.4 is GREAT!

 

That said, one of the great features of mapbox is the ability to customize your own map layers. 

 

It would be great if this was an option to use a custom map as the alteryx reference map similar to what is available within tableau. We in our organization have several custom map styles built with mapbox and I'd love to use them as a reference in the report map tool, or any other scenario where maps become useful.

In working through challenge 77 it became apparent that here are a few useful formulae that would help with work like this:

OffsetFromPosition

Input: Point; Bearing; Distance; Units

Output: New point

 

Degrees to DMS:

Input: Degrees as floating point

Output: string with Degrees; minutes & Seconds

 

DMS to Degrees:

Inverse of the above