Alteryx Designer Desktop Ideas

Many times; ideas for new ways to use Alteryx come to me while I'm not at work.

Most of the time that happens, I can use RDP via VPN to get to my work desktop.

But sometimes it isn't easy to do that.  Like when I'm driving, outside for a run, in the shower.. you get the idea.

My point is that there should be a mobile app for Designer (iPads and Android tablets).  The mobile app wouldn't necessarily need to be connected to the actual sources live (maybe require a template used for input for ODBC; but allow connections to HTTP/FTP/local sources). 

The user would design the workflow, and then have the option to email the schema to themselves (or others) so that once back at work, one could pick up where they left off.

Although I would prefer to use it on an iPad, it could technically be used on an iPhone as well.

For an example of how that could look, see the iOS app "Workflow".  That, in combination with the now defunct "Schemes" was a great way to do visual programming similar to what we do in Alteryx.

Currently the only encoding method supported by Alteryx Avro format is deflate.  Please consider improving this to include google snappy approach.

This codec method is referenced in the Avro documentation for supported codex.

https://avro.apache.org/docs/1.7.6/spec.html#Required+Codecs

it would  particularly interesting to develop a WMS support in Alteryx.
To include other Maps like bing, google, HERE instead of CloudMade to display geo informations.

Mathias

In order to perform audit-trail logging - it would be valuable to have 2 new capabilities

a) environment variables which show the workflow name; filepath; version; run start date and time; etc.   For any worklows we build, we need to have a solid audit trail to be SOX compliant, so having this detail available as a data field to write and manipulate is essential

b) A logging component.   What would be great is a component that you can drop on a workflow, not connected to anything, which is able to trap the start; end; runtime; version; etc of a workflow; and commit this to any output data format (CSV or ODBC etc).   This logging tool would need to be able to capture the full runtime, so it would need to be the last thing that runs (which means it may need to exist in parallel to the main workflow in some way).    This is not currently possible with a complex workflow with outputs, because it's not possible to identify when the entire workflow ended; or the runtime (since output tools don't have an onward connector to pass flow-of-control to catch the final end-time)

Again, both of these are necessary to meet audit requirements for workflows and prodcution-quality ETLs for BI data warehouses.

It would be great to have an outbound connector on output tools for 2 reasons:

a) if this outbound connector can carry key results of the output process, this can be saved in an audit log.  For example - rowcounts; success/failure.   This kind of capabiltiy (to generate a log, or to be able to check the rowcount of rows committed to a database) is important for any large BI ETL process

b) this woudl also allow the process to continue after the output process and also act as a flow of control.   For example:

- First output the product dimension

- once done - then connect (using the outbound connector) to the next macro which then updates the Sales fact table using this product dimension (foreign key dependancy)

In Dec I had an issue where I could not uninstall or upgrade Alteryx. As part of troubleshooting and the eventual solution I had to manually delete any registry key related to Alteryx. As these were hundreds of entries this took a long time. It would be handy if Alteryx could provide a tool that cleaned the registry of all Alteryx related entries. Related: "Case 00088264: Unable to uninstall Alteryx"

I've been using Events a fair bit recently to run batches through cmd.exe and to call Alteryx modules.

Unfortunately, the default is that the events are named by when the action occurs and what is entered in the Command line.

When you've got multiple events, this can become a problem -- see below:

Events tab with all events called the same thing

It would be great if there was the ability to assign custom names to each event.

It looks like I should be able do this by directly editing the YXMD -- there's a <Description> tag for each event -- but it doesn't seem to work.

I know there is an idea for Dynamic Summarize, however I think with only small change to Summarize tool this could be achieved. 

If we set the Summarize to Group by all our dimensions but then use ListBox + Action to control which dimensions we want to select - wouldn't it be nice (ahh Beach Boys comes to mind) to be able to tell Summarize tool that if the dimension in group by is not found just ignore it? At the moment it throws an error. I just think such small configuration would achieve this, right? 

Please let me know what you think

Please asses the value of having hdf5 as data input. A possible workflow could be:

HDF5 => | Processing tasks |  => export to Tableau (.tde) or Qlik (.qnx) => vizualisation workflows

Thank you.

Regards,

Cristian.

I would like to suggest to add a widget which encapsulate an R script able to perform outlier detection, something similar like netflix did:

• RAD - Outlier Detection on Big Data
• Tracking down the Villains: Outlier Detection at Netflix

Thank you.

Regards,

Cristian

Please evaluate the opportunity to export Alteryx workflows as xml based GraphML format in order to be able to import them in yED, the free graph editor. (https://www.yworks.com/products/yed)

Thank you.

Regards,
Cristian

I recently did some extensive work on using the download tool to invoke Restful Web Services. A lot of the initial effort was around ensuring that the data being passed in the header and body for the request was as the service required. Following review of experiences on the community I used a tool called Fiddler to directly view what was being sent to identify the problems in my transformations of the data going into the Download tool. The idea is that the raw HTTP request and reply messages are available directly in Alteryx in the Results window when running a workflow, preventing the need to use another tool.

Visio is our organization's most common method of communicating business processes and workflows. Being able to export an Alteryx workflow to Visio would help us communicate the tool's functionality to process owners.

It would be useful when building apps to be able to put interface tools in containers and disable them.  This would allow an app developer to show users multiple ways of having the app styled without having to have multiple app versions saved.  

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)

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

Wouldn't it be nice to be able to CTRL+Scroll-Up and have the font size of the browse contents EXPAND?

In-database enables large performance benefits on big datasets, it would be great to incorporate multirow and multifield formulas for use within the in-database funcions for redshift

Hi,

I've been working on reporting for a while now and figure out that creatitng sub total wasn't part of any tool. 

Any chance this could be implemented in next versions or any macro available?

Thanks

Simon