Alteryx Designer Desktop Ideas

When scoring data if you have values in predictor fields not seen in the data that was used to build the model the score tool will not score the record.  Makes sense but it would be nice to know how impactful the issue is.  Please provide a count of records not scored for these reasons as well as a count of records not scored because of exceeding the limit in the configuration tab of the score tool. and a count for any other reason a record is not scored so we have a clear understanding of how many were scored and how many were not and why.


 

I haven’t found a common spatial file format to use between Alteryx, MapInfo Pro and ArcMap.  The one file/db type that all 3 software packages have the ability to use is SQLite.  Problem is that each of these GIS packages stores data differently in SQLite. 
I propose the following…  Alteryx should have 2 new SQLite options to save output (and read from) in SQLite-ESRI and SQLite-MapInfo.  This does not get us to the holy grail of one common file format but does get us down to 2.  (If you guys could figure out 1 common format that would be better)

Having these new SQLite formats would fix a common issue shared by the Alteryx supported ESRI and MapInfo formats, namely 2G file limits, multiple files per dataset and short field names.  Currently, to save an output for ESRI and Mapinfo, I take a single yxdb and save multiple shape or tab files.  The conversion back is an aggregation of individual files into an yxdb.  SQLite, as a database, has the ability to store many tables which further reduces files (much like a file geodatabase).

Finally, I have been begging for Alteryx to have the ability to read and write to an ESRI file geodatabase, which seems to never come to fruition.  This SQLite solution would eliminate my need to write out to file geodatabases.
 

One of those small little annoyances that can add some extra time to development is how when you browse for a file (either with the Input Tool or Output Tool) it always defaults to the most recent location of where you either picked up a file or output a file.

Many times I have existing Input Tools or Output Tools that I simply need to repoint (meaning they already have a file location mapped to either read or write to.)  For these, it would be great if, when the user clicked to File Browse, the initial folder location displayed was the same folder where the current file is mapped to. 

Perhaps displaying the most recent folder in the file browse interface may be best suited for when a file has not been mapped yet.

We have a number of clients now using Exasol databases and they would like to connect Alteryx to this data source.  There is currently some difficulty connecting using Alteryx and so it would be good if this could be fully tested please.

I have several regular outputs I use that are in both Excel and PDF (depending on who I am sending them to).

The format of these is always:

For Excel, create a summary sheet and set as the first tab, then create detailed sheets as additional tabs in the same .xlsx file.
The summary sheet always has the same fields, but the fields may reference different detail tabs day to day.

After the output, I can manually open Excel and change the field to a formula that references the other tabs (hyperlink function).
It would be great if I could just type the hyperlink formula in Alteryx and have that embedded into the Excel output.

The same goes for PDFs, except I would reference other pages (or if using PDF portfolio I would reference other PDFs in the same portfolio).

We would like to have the ability to overwrite sheets in macro-enabled Excel workbooks.  Several of our scorecarding templates leverage macros for Excel events, protection, and interaction, and the ability to directly overwrite data in these workbooks would be a huge benefit of  using Alteryx.

While trying to debug data parsing, I end up with browse tools all over the place and it makes the pallet a mess and time consuming to organize.

It would be much nicer to just have a little corner of all icons to have a sub icon or something I can click on to see output.  Multi output could be a little more tricky ... so better yet, maybe have small browse icons on the connectors you can click on for results of that feed?

Then have a menu option to turn all off/on.

Posting on behalf of Door To Door Organics:

Canvases can get pretty huge and it's an unintuitive pain to have to scroll and shift+scroll across a large canvas, and an even bigger pain to rely on the sliders at the edges of the canvas. It would be REALLY nice if we could navigate the canvas by dragging the canvas around, much like a touch interface, in the same way that Photoshop's "Hand Tool" works. 
 
As an added plus, the same hotkey that Photoshop uses (the spacebar) should also be usable in Designer, since, I'm pretty sure it's not used for anything else at the moment, as a hotkey. The functionality would look like this: hold down the spacebar (which changes the mouse cursor to a hand tool) and then, while the space bar is still held down, you'd be able to "grab" the canvas and drag it around in your view port in order to traverse it in a much more intuitive way. Bonus points if you could manage to implement some inertial scrolling with this as well. 😃

Geohash is a latitude/longitude geocode system (public domain). It is a hierarchical spatial data structure which subdivides space into buckets of grid shape.

Geohashes offer properties like arbitrary precision and the possibility of gradually removing characters from the end of the code to reduce its size (and gradually lose precision).

As a consequence of the gradual precision degradation, nearby places will often (but not always) present similar prefixes. The longer a shared prefix is, the closer the two places are.

http://en.wikipedia.org/wiki/Geohash

https://github.com/sharonjl/geohash-net

https://github.com/simplegeo/libgeohash/blob/master/geohash.c

It would be nice if we could use our gallery with a mobile app. We like to run demographics on site and have to pull up on the ipad.

Also, if instead of typing in an address, we could use the iphones "current location" option. 

I have a user who has a batch macro set up for processing customer records as they relate to stores. The macro loops based on the storeID. In some cases, some stores do not have customers and the user would like to have an "Exit" button so that the rest of the tools downstream won't run if no records are present and the batch macro will start over automatically with the next store.

I have the Show Properties Window selected, but it is not showing up on my screen. At first I thought it was just hidden and that I could just pull it back from being hidden, but I can't find it anywhere. 

Thanks! 

Hello All,

Can you add the flexibility to access fields based on its position or index like a[1], a[2],... a[n]. a[1] being the first column. Also an option to get max[a] can give the last column and min[a] give the first column. In this way, we can easily subset the dataset. Most cases, we are handling survey data which has 1000s of columns and when we need to select certain columns, we have to manually select the column checkbox and its painful to select 100s of columns. It will be nice if there is an option to select based on ID or index. It will also be useful while doing multi-field formula with more number of fields, because currently there is no option to write formulaes based on field Name column in it. 

Regards,
Jeeva.

Can you add an ExceptionHandler to the Tile Tool? The tool crashed on a large dataset.  I got an Error: Tile (1): No values found before GetMean() on the tile tool. I selected Smart Tile option on the ‘unique_zips_count’ field and grouped by ‘ID’.
To track the problem down, I had to use the sample tool to grab x number of recs and see if it would run through the Tile tool. I had to keep skipping and selecting first N recs until I narrowed the problem down to 20 records. As it turned out. all values were 0 in a specific group. I found a workaround by pulling all recs per group with a value of 0 and bypassing these with the Tile tool. Instead of doing that - could you add an ExceptionHandler and specify which RecNo it crashed on?

Can you also add option to use 1, 2, or 3 std dev in addition to smart? This way all my groups will be uniform.
  

I think there should be a tool that allows you to produce grand totals for any numeric field you want. In the tool, you should be able to check off the fields you wish to be totaled at the bottom. I prefer this over having to use the summary tool and then using the union tool to produce totals at the bottom of my output. 

Pretty simple but could be helpful when troubleshooting and reviewing.  Allow a user to have rows be banded in a different color, allow the user to select how to do the grouping to band.  For example, a large browse tool has several thousand rows, sorted by product name.  Each product has between 5 and 50 rows each.  If a user could set color banding by product,.. they could easily find the "breaks" between product rows.  This could be somewhat similar to the Excel table formatting option for banded rows,.. you could simply alternate bands,.. but would be nice to be able to group the bands by some column attribute in the data.

This may be a little easier than constantly opening new browse windows with the selected records,. or to use filters or other tools to group the data for review / troubleshoooting purposes.

Idea:   I think the Interface Designer's "Test View" window should allow control parameters to act like "Text Boxes" and allow the designer to manually edit, or type a control parameter for use in a debug module.
 
When designing batch macros, there currently is not an easy, built-in way to test or debug their functionality.  There are two reasons to build a batch macro:
1) to reconfigure the macro at run time, just as if they were the answers to questions in the macro GUI;
2) to group the records going in the macro inputs into batches.
If I am designing a macro to perform the 1st function -- reconfigure the macro at run time -- I need to be able to test its functionality in a debug module.
 
The Interface Designer's "Test view" window should provide this ability by allowing you to type an example control parameter value.  However, the Test View window only allows you to "dropdown" to a value via a dropdown box.  This dropdown box is always empty, thus never allowing you to enter a test control parameter.  I think the Interface Designer's "Test View" window should allow control parameters to act like "Text Boxes" and allow the designer to manually edit a control parameter for a debug module.
 
I've attached a screenshot of a simple, two control parameter batch macro.  As you can see, in the Interface Designer, I don't have a way of inputting a value in either control parameter field to open a debug module.
 
 

 

It would be great if we could select default settings for containers, so that when they are added they could be automatically set to narrow margins and gray background (or whatever). (PS I'm going to add another idea regarding idea categories, because "tools" and "designer" aren't available categories, but that seems like the best place for this idea).

Many files I use are in .xlsb format.