Alteryx Designer Desktop Ideas

Within the select tool when you have hilighted a set of rows it would be NICE to be able to RIGHT-CLICK for OPTIONS rather than have to move the cursor up to the options to get to choices.

 

Thanks,

Mark

I've come to realize that the JOIN tool is case-sensitive by design but it would be helpful if you could turn that behavior on/off (via checkbox?) within the JOIN tool.  For those of us that work predominantly in database environments that are not case-sensitive, this default behavior has caused me problems many times.  Having to force the case to either upper or lower upstream of the JOIN on both flows in order to ensure a successful join is an extra step that would not be necessary if you could disable case-sensitive with a checkbox.

I find it very difficult to read Warnings in the Messages palette because the text is a light yellow against a white backgroud.

 

I'd love to be able to change either the text color, the background color of the palette, or both.

I think it would be great to add metadata to a yxdb. For example, I was back tracking and trying to figure out which module/app I used to create an old yxdb. Now I use Notepad++ and do a "Find In Files" Search. Wouldn't it be great it the module path would be available when you look at the properties of a yxdb in Alteryx?

Currently there is no option to edit an existing macro search path from Options-> User Settings -> Macros. Only options are Add / Delete. Ideally we need the Edit option as well.

 

Existing Category needs to be deleted and created again with the correct path, if search path is changed from one location to another.

 

 

Idea:

A tool for encryption/decription of a column with multiple encrypiton options is the idea.

Both one way and two way encription should be possible.

 

Rationale:

Clients are in need of encrypting customers' personal identification data

before sharing it with a third party like consultants and analytics service providers etc.

When insights are provided back the data owner needs to quickly decrypt the ID field and get results or decide actions.

 

Clients:

This is especially an important case for banks, non bank financial institutions and telecom companies in EU countries and similar (Turkey has similar strict rules)

 

Best

As with Output Data tool, it would be very helpful to have this option within the Calgary Loader tool.  I have a series of ordered analytic apps and if I could name the Calgary database using the "Take File/Table Name from Field" option I would be able to chain the apps and be much more efficient.

 

Thanks.

I recently had an error in a module because an expected variable was not present coming into a formula tool.  My variable, "MONDAY" was not present and the formula MONDAY/3 failed.  The workaround was to union all days into the incoming data and things worked fine.  I would have liked to have an Excel formula like this instead:

 

IF ISERROR([Monday]/3) THEN 0 ELSE [Monday]/3 ENDIF

 

Thanks

Sometimes I get conversion error messages or warnings that really don't matter, and it would be great if there was a function similar to spell check or grammer check where I could say "Don't show me this again", so that once I've read the message I can choose whether or that particular message pops up again.

default file path in "File Browser" interface app would be a nice to have feature. Similar to what we have in Numeric, Text etc. interface app.

Currently we are limited to chossing one of two layout direction options, vertical or horizontal.  Why not make the direction assignable at the tool icon instead of as a module level control.  I could right click the tool and have layout direction as an option which would activate a visual handle which could either allow infinite rotation control or rotation control in 45 degree increments.  You can use Viso as an example of rotational control for a shape.  In Visio the shape rotates, in our case since we are really looking to change the flow direction the icon could remain in the same orientation as it does now but the conenctor point(s) would rotate around the compass in say 45% increments base on the drag of the rotation handle that appears

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.
 

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).

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

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.

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.

I think it would be great, especially if you have browse tools at multiple phases in workflow, to be able to view Browse results while module is running, rather than having to wait until it's done. I think it would help with being able to head off problems sooner.

Here is a thought I posted about on my Alteryxuser blog: http://alteryxuser.blogspot.com/2015/02/alteryx-and-github-place-for-sharing.html. I interested in hearing your comments!

Would be nice to have the option of disabling the append of the "action" to the variable in the summarize tool.  Sometimes it's useful to leave the variable name as is when making tweeks to your module.