Alteryx Designer Desktop Ideas

If there can be a way that we can filter the output in the result window or output of browse window so that we can check the output without going to update the workflow.

Add an option to read directly from a zip file.

If you have a complex SQL query with a number of dynamic substitutions (e.g. Update WHERE Clause, Replace a Specific String), it would be nice to be able to optionally ouput the SQL that is being executed. This would be particuarly useful for debugging.

Hello,

I've seen som complaints about the user constants. Specifically the fact that they are hidden away and that there is no way to edit them without user interaction. Wouldn't it be much more beneficial to just have a Constant input tool.

This way the user can import the constants with any file, or just with the text input tool. 

Looping constants would maybe become a problem though...

MySQL released version 8 for general availability in April 2018. It would be nice when Alteryx installed LUA scripts for MySQL 8 by default. Now only LUA scripts for MySQL 5 are installed.

Our organization uses Sharepoint Online store and collaborate on several excel files.  These excel files will serve as an input to our workflows.  Please create an input tool that can save save credentials for sharepoint, then an excel file from sharepoint.

It would be extremely useful if most Alteryx tools had the option to output error records seaparetly. This functionality is already present in most other ETL packages, even freeware ones like Pentaho - Kettle. From its wiki: http://wiki.pentaho.com/display/EAI/.09+Transformation+Steps

http://wiki.pentaho.com/display/EAI/.09+Transformation+Steps

Step error handling allows you to configure a step so that instead of halting a transformation when an error occurs, the rows that caused an error are passed to a different step.

This might be an edge case, but it would be nice to be able to parse a file using a Regex in the Text to Columns Tool, or specifying a delimiter as a Regex:

Consider the following pandas code where one can easily pull in a file with a bad delimiter

In Alteryx, you would be forced to read in the file with no delimiter, and set the field length to be extremely long, and parse out the contents manually.

filename = "http://daniels-pull.universityofdenv.netdna-cdn.com/assets/GeneralOccurrencesAll.csv"

df = pd.read_csv(filename, sep=r',(?!\s)')

I have recently been building some reports and have some suggestions for later releases of Alteryx.
 
1.       Map tool – have option to put border around map within the properties window.  Currently, I have to use a layout tool to put a border on a map.
2.       Map tool – Same thing with legend (especially when legend is output as a separate field
3.       All tools – be able to put a browse tool after the tool using the Properties window.  I was thinking right above the “Apply” button (check mark bottom left corner)
 
Just some thoughts that would make life better.

Generate an output to a database store.  Tell it you want to have a custom mapping.  You cannot resize the box.  If you have verbose column names, you wind up scrolling a lot.  I've done all of this super amazing work to aggregate data from N datasets, work I never would have thought to try to code, and at the last inch am resorting to scrolling back and forth like a chump!  

This is an easy, easy, easy fix.  

/endrant

I paste data into text input tool, then i have two choices 1) rename each field manually according to my data source 2) add the dynamic rename to take the headers from the first row.

The first way is time consuming and prone to mistakes.

The second way breaks the downstream configurations (workflow needs to be run first), and affects how the text input tool auto-detects the field types (all strings)

Text input would be improved with a button that automatically takes the first row and turns them into headers, as if i typed them in myself.

Thanks!

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.

Or ability to batch change the connection string from A --> B for all tools using A.

Or ability to set a default "saved connection" for a workflow and if you change it cascade the change to all tools.

Case:  you have numerous connections in a workflow to a database.  You then either:

a) move your data somewhere else and need to replace all the connecitons

b) OR have a standard process for working against DEV, Staging, etc. and want to switch the workflow to use a different saved connection

For Snowflake Bulk loading only AWS S3 is supported.  ODBC works but has slower performance.  Adding the Google Cloud Storage option would allow more customers to use this feature.

I love this option in the Input Tool and use it extensively. It would be really handy to have the ability to set this option 'globally' for all Inputs in a module. I don't mean to remove it as an individual option, but to add ability to make the setting for everything. In my mind I imagine it being a Module/Runtime property that overrides the individual Input tool settings (like the Record Limit option).
 

Can you please add a setting to the Dynamic Input tool where the developer can choose to treat different schemas as either Errors, Conv Errors or a Warning?

Depending on which of these issues are flagged during a workflow run my management of it differs. I tend to ignore warnings, yet pay attention to Errors and Conv Errors.

I appreciate being able to write to an ESRI File GeoDatabase. It would be even better if in the process of writing to an ESRI File GeoDatabase I could identify fields to index and have them indexed when writing to the File GeoDatabse. Currently I have to add the index in ArcGIS after the fact. Writing to an ESRI File GeoDatabase currently adds a spatial index automatically, but I'm talking about an attribute index here.

Hello gurus - 

Pretty much every coding framework supports this.  If we really want Alteryx to embrace no-code, we've got to have some ability to control commit / rollbacks across transactions.  As it stands currently, it is pretty easy to write out parent records, fail to be able to write out children, and wind up with a database state that makes the end users very sad.  

Thanks!

brian