Alteryx Designer Desktop Ideas

Would be great if we could right click on an input and in addition to having "convert to macro input" there was an option for "convert to dynamic input".

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.

It appears that the Marketo Input tool only is focused aroudn getting Lead oriented Objects, however since Marketo is a Marketing Automation tool, it has many more objects such as email performance, landing page performance, web activity, program performance, revenue explorer, etc. 

I'd like to vote up this idea of having marketo input connector having access to extrac data from other objects outside leads. 

Here is the latest Marketo Analytics resources that are available.  Anybody else encounter this bottleneck when trying to source the data out of Alteryx? 

I often have up to ten or more workflows open at a time, several are named and are active workflows that I want to save, and the rest are just scratch workflows where I'm trying something out. When I close Alteryx it asks if I want to save changes to workflows, with the list of all the workflows. If I don't want to save the scratch workflows, I have to cancel, close each one individually, then exit Alteryx again, saving the ones I want to save.

 

It would be great if there was a check box next to the workflows in the list where you could check the ones you want to save, and it would drop the rest.

I'm using .sv file format for compressing large files and using them in Alteryx.  .sv is call a Alteryx Spatial Zip file.  This format seems to offer the highest level of compression of all the Alteryx file format types.  Is this suitable for text also?  Is it usable in real time vs uncompressing first then using in a workflow?  If not, I think a compressed real time file format would be a nice addition.

I love the new Basic Filter option and it makes writing filters easy/self-expanatory for new users and helps with functions like isnull(). However, I'm almost always writing what are now called 'Custom Filters' and it takes two clicks to do this.

From a User Experience perspective it would be great if you could click in the expression box to write the filter rather than having to check the customer filter check box, or start by creating a basic filter and then make it more complex using the custom filter box without having to check the tick box.

Following on from this and something that is probably a lot harder to implement - But with the new basic filter, it would be great to have a list of available fields populate the options to filter by - Similar to the option that you get in Calgary. E.g Country == and then the drop down list would contain whatever is available in the data (e.g. Spain, UK, USA, Etc...)

Can an interactive mapping tool be added as an output tool? 

When reports, files, or tables are generated, it would help to be able to view them on an interactive map.  Currently I am trying to show where high population growth is located for large areas, ie-entire US, entire State(s), etc., so the user needs to view where these areas are on a map.  Ideally, it would be nice to have additional layers seen on the map as well, for example, our current locations, competitor locations, etc.

Currently there are bulk loaders within alteryx for Teradata, Oracle and SQL Server.
It would be great to have a bulk loader for AWS Redshift in order to fully industrialize the workflow instead of using AWS S3 and then use a separate AWS Datapipeline for scheduling

In the Overview pane - can you please show which tools have completed the current run, when viewing this pane during a canvas run?   That would allow for a progress check at a glance.

It would be good if in the date format option for the Parse tools etc, if there was an option for the 1900 date format used sometimes in Excel/SQL. This is where the date is represented as the number of days from 1/1/1900. If this support was added then the same support for time be represented as a decimal {0,1} would be good as well. Besides this being a nice addition to the software, it would also help with any workarounds stemming from an excel file being open when imported causing the format to come through differently. (Currently if the Excel input file is open in the background which can happen on network available files, the time comes in to Alteryx asa decimal and the date appears as 1900 format).

For the purpose of debugging a workflow, I often filter just one customerID or any other ID to analyse the workflow.

 

With the Browse tool (ctrl-shift-B) you can just double click a cell and copy the value of it. This is not possible in the result tool, it would be nice if that would become possible.

 

Thanks,

 

Hans

 

It would helpful if you have a tool which will help us to filter out the data using CASS results column in a meaningful way. On the other day, I CASS'ed 2MM customers and ended up with 1500 combination of CASS result codes. I don't think we would have time to sit walk through all the 1500 combination to find out which I should call it as correct addresses and not the right ones. If you have one already that I didn't know of, please guide me.

Thanks
Arun

I'm a long time user of Photoshop and it would be great to get some similar zooming and panning functionality into Alteryx.  Such as:

- hold down the "space bar" see a hand and pan across the canvas.
- hold down "CTRL" or "ALT and zoom on the canvas
- use the mouse scroll to zoom on the canvas

While Alteryx is processing it displays information in the module with record/file infromatoin.  Once processing is complete this information is gone, except for in the output window.  Could you add a key combination or button toggle to redisplay this info from the prior run.  It would be very helpful for debugging.

When I save records out of a browser tool, an info window appears when the file is finished saving. Please add a hyperlink to that window that will open the newly saved file. This should work the same way as the hyperlink in the Output message window.

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.

Currently In tools like the select and join you have the ability to sort the field order by ‘Field’. As I understand if this sorts the fields by ASCII order from the smallest to the largest character that you can display.
 
The English-language ASCII sequence is consistent with the order shown in the following:
blank ! " # $ % & ' ( ) * + , - . /0 1 2 3 4 5 6 7 8 9 : ; < = > ? @
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z[ ] ˆ_
a b c d e f g h i j k l m n o p q r s t u v w x y z { } ~
 
I would find it very useful to have the ability to use a dictionary sort in these tools.

When building out a large workflow, I'd say one of the bigger challenges I come across is being able to quickly navigate the canvas to a certain spot. In these types of workflows, my personal way of keeping things organized is creating sections of my workflow in different Tool Containers and naming them with a short description.

 

Here is what I picture helping out a great deal in navigation. Create a drowdown somewhere in the ribbon on top (would not want another sidebar or floating window that takes up needed space) that simply lists out every tool container in my workflow by name. When a tool container name is selected, the view jumps to that tool container in the window pane. Another option in terms of the interface might be to add a keyboard short that gives a popup "tool container search" window. Begin typing a tool container name, and it would jump to the first result it sees as a match. Then just hit escape or click outside the popup to continue your work. 

 

I think this would help immensely in being able to jump to a particular spot in the workflow without having to drag the overview or scroll around until you are able to find it. I included mock-ups for each version I mentioned.

 

 

 

 

 

I have found out a minor usability bug from v 11.0.5.26351.

 

Feature occurs if I output data from Join tool so that some or all left outputs are unselected:

 

 

 

 

 

 

 

 

 

 

 

 

 

Now when using the output of the left stream in another join there occurs a small bug affecting workflow:

In the rightmost join tool Alteryx does not recognize right away that there should be multiple columns, A, B and C coming from the left output. This can be solved by going out of the tool and getting back, but this has a minor impact on the workflow.