Alteryx Designer Desktop Ideas

Would be nice to select a bunch of consecutive fields, and cut them and paste them to a different area.  Currently, the only options are to Move to Top or Move to Bottom.  If you want to move somewhere in between, you have to scroll through the whole list.

Pre-v10, I could set a default tool for each tool palatte.  For example, for the Summarize tool pallate, I could make the Summarize tool the default (that already was the default, but you get the point).  I could then simply drag the tool palatte icon onto the canvas and the Summarize tool would be there.  Now, I have to navigate to the tool pallate and drag my tool on the canvas.  Yes, I know I could add it to my favorites, but screen real estate goes quickly after adding just a few favorites to the already defaulted favorites.  It would've been nice if this functionality wasn't removed with v10. 

I think it would be extremely helpful to have an in-DB Detour so that you could filter a user's information without having to pull it out of DB and then put it back in for more processing.  A time where this would be useful is if you have a large dataset and don't want to pull the entire dataset out of the DB because it will take a long time to pull it.  This would be applicable for filtering a large dataset by a specific state chosen by the user or possibly a region.  The Detour in the developer tools actually seems like it would do the job necessary, it just needs to connect to the In-DB tools.  

The excel driver (.xlsx) converts these values to 0.  If you use the legacy excel driver (.xlsx) it brings in the #N/A values.  This issue was reported in the community and I am forwarding it to the New Idea as a problem that needs to be addressed on behalf of @JohnDoe.

Hello! Almost all statistical softwares allow for the analyst to use either a pairwise or a listwise option when applying clustering techinques. This option affects only how the inner distance matrix is built, and after that whichever algorithm you choose is peformed. However in Alteryx [K-Centroids] by default does listwise, classifying only those records where the selected variables have no nulls.

Please consider adding this option!

PS: the difference is pairwise will build the distance between 2 variables depending on those records that have no nulls on both variables, while listwise will run the distance matrix after it has checked for complete non null records in all variables of interest (not one at a time distance calculation).

I often find myself combining data from different sources. It is external data I have no control of. One of the main problems I face is that columns are often named differently: 'this is a comment' in table1 is called 'a comment this is' in table 2 and 'comment' in table3.

The union tool is convenient for tables with few columns only: when the columns are many, moving them left and right is confusing and time-consuming.

I currently list and associate the column names in Excel, then use this as the basis to rename columns in Alteryx with a select tool, then do a union in Alteryx.

It would be extremely convenient and efficient if Alteryx had some kind of drop-down box to do this association. I have tehse steps in mind:

1) Alteryx tries to guess associations by column names (if two columns have the same name in two tables, they are associated to each other)

2) for the ones with no associations, rather than scrolling left and right as is now the case with the union tool, the suer would be able to choose from a drop-down list. This would make it evident that 'this is a comment' matches 'a comment this is', etc

The Listbox (interface macro) is currently populated statically when sourcing values through a Connected tool. Whatever, I configure in the macro is retained. When I use the macro in a workflow the LIstbox values are not updated when the fields in the connected tool are changed. This practically limits my capabilities to build a truely dynamic macro/app.

The Listbox should be able to show dynamically the fields coming in through the connected app.

Add in-database tools for SAP HANA.

Please star that idea so we can prioritize this request accordingly

It would be very useful to be able to search the field by typing the name instead of scrolling up and down looking for it among a few hundred fields.

For the Charting tool, specify descending/reverse order for a Bar Chart type, so that it puts the largest value at the top.

I would like to be able to draw a box around some tools, them maybe right mouse click to add them to a container

Hello,

when parsing XML data, Alteryx does not recognise <![CDATA as being data. This type of XML file is not very common yet is still used today (by me anyway!). Their role is similar to commenting your code in some regards (for those who code).

Could it be possible to add a functionality to alteryx so that we can have it consider the data between these "tags" to be data? 

Regards,

Julien

There are a number of requests for bulk loaders to DBs and Im adding MySQL to the list.

Really every DB connection (on prem and cloud) need some bulk loader capabilities to be added (if they don't have it already)

Hi,

Can we have a functionality to see total number of rows without adding a browse or any other tool?

PFA (output from Alteryx 10.0)

Thanks,

Rajesh Chandak

Data Analyst - Walmart

In a future release, I'd love to see the whole concept of browsing for and installing new macros/apps brought into Designer itself.  It's always great finding new macros, but the expereince is inconsistent- sometimes you have to run an installer file, sometimes run a package, sometimes just put the file in a directory and add a 'watched macro' directory to your preferences.

I'd like to see a cleaner expereince where you can choose to 'Add Tools', browse the gallery, check the thing i want, and click the tools group I want to put it under, then have Alteryx take care of the rest.  There would also be the need for a 'Manage tools' screen where could could uncheck and remove them later if you no longer need them.

For inspiration, check out the way MS handles 'Adding Apps' via their catalog to build out your Sharepoint 2013+ site

It would be a nice time-saver to allow for multiple fields to be selected and / or deselected at the same time in the Transpose tool...the Select tool and Summarize tool already allow for this.

Very wide survey files in particular would benefit from this kind of feature.

Alteryx crashed when I attempted to use a custom OTF font in Report Text. I thought it was supported because font options was not greyed out and preview window looked correct and I was able to resize. I clicked 'Apply' and Alteryx popup window appeared saying "only TTF font is supported". Then Alteryx crashed.

Please add OTF font support. Tableau and other packages already support it.

I'm not sure if this is the right forum for a bug report, but I just solved one that has been bugging me for ages. Of the six key commands to hide and reveal the various panels, only five work, and now I know why.

Apparently the 'Results' panel used to be the 'Output' panel? I found some outdated docs that mentioned Crtl + Alt + O to open/hide the Output panel. Sure enough, the reason Ctrl + Alt + R doesn't work in the current version is that, in spite of what the menu text says, it's O that is still mapped to that panel, and not R.

I only discovered this after making sure none of my other installed apps were stealing that key combination. Thank you, process of elimination.

If progress bar or overall process completion percentage can be displayed somewhere, adds great value for the users running complex processes (with multiple databases/ files as input and complex queries especially spatial queries).