Alteryx Designer Desktop Ideas

I am on a forecasting project where we convert one vector of forecasts into another vector of forecasts by multiplying by a conversion matrix. This is very clumsy and fragile to do in Alteryx meaning we have to drop out to Excel. The ability to do very simple matrix multiplication in Alteryx would be very useful here and in other use cases. I realise you can probably exit to R and do the job, but for something so basic that shouldn't be required.

 

The relational representation of an mxp matrix is a three column table of cardinality mxp with columns { I , J , A }, where I labels the first index set with index i, J labels the second index set with index j, and A labels the numeric values with value a(i,j).  Given a second pxn  matrix { J, K, B } in relational form we should be able to multiply them to get a mxn matrix { I, K, C} in relational form where of course c(i,k) = sum over j in J of a(i,j)*b(j,k).

 

Vectors can of course be represented as 1x and x1 matrices. If you really wanted to go to town this could be generalised to array processing ala APL2.

Hi all,

 

When testing a macro with interface tools in use - the value that is used if running in normal execution (hit the big play button) is 0 or blank, irrespective of the value set for default on the component.

e.g.

• put an up-down component on a canvas with a default value of 200
• Then hook it up to a formula box
• Then output the value 
• The value which is output is 0

 

Please can you change this so that the value passed through the interface tools in testing mode is the specified & configured default value?

 

Thank you

Sean 

It's not uncommon to start out with an InputData control, and then 2/3 of the way through you realise that you need to change this to a dynamic input.

Could we add the capability to right-click on an inputData; and convert to Dynamic Input (just like you can on a TextInput to change it to a Macro Input)?

 

That has bugged me for years.

The dynamic input tool allows some fairly complex transformations to the underlying query - but it's not always easy to debug this when it doesn't behave as expected.

Could we add the ability to inspect the resulting query (just like you can on the InDB queries using the dynamic output component?)

 

It is currently possible to see this in the results / messages pane, but I can't find a way to get this into a data-stream to persist it or manipulate it.

It would be great if Alteryx allowed users to copy and paste data directly from excel into the workflow canvas as a text input. Sometimes I create quick mapping tables in excel that I do not want to save on my desktop or shared drive as it is a quick fix or solution. Tableau allows users to copy and paste data sets directly into a sheet for use. Can we make this happen??

 

Yours Truly,

 

Trevor

 

Would like to see the Directory tool output results for folders that are empty.

 

My particular use case is requiring me to join a dataset with a file system directory and identify each dataset record's corresponding folder in a file directory. Each folder in that directory has subfolders that require a document to be located inside, and I'd like to be able to use the Directory tool to identify which subfolders are empty for which records.

It would be really great to have Dynamic Detour tool where you could specify the detour direction as an input to the tool rather than an imbedded control.

 

This would allow workflow branching.

 

Using a filter for this passes a dataset with no rows in it which causes dynamic in-db or dynamic input tools to error.

Please add option to right-click a module tab to rename the yxmd file.  This would be easy to do, for you, and quite handy.

On the “Multi-Field Formula” tool, the default is to “copy output fields and Add….”  I think the default should NOT copy. I’m using this tool to trim all of the blank spaces, and change the case in text fields. I often forget to uncheck it and end up with all these additional fields at the end. With regard to the tool container, I think the default margin should be small. I build huge workflows, and putting each section in a tool container. I have to go in and change each one to small margins to condense the workspace. Perhaps in the user settings, under document, there could be a default margin option, just as there is a container color option.

Hi

 

The native email tool is great up to a certain volume, but at high volume it makes more sense to use sendgrid to take advantage of its features like deliverability etc

 

Would be great if there was a ready-made connector tool for SendGrid

 

Thanks

Rather than giving the users a big list of different date formats to choose from, allow the user to construct their own format with syntax of the incoming date that they are dealing with.

Currently I need to do a string function moving dates around to match a predefined syntax...

I often search for a tool on the canvas using control find and the tool number. If the tool is already in the visible pane, Alteryx highlights the tool with a faint dotted box. The problem is that I often have hundreds of tools that are visible and I have to constantly hunt around the canvas to locate the highlighted tool. Please update the control find settings so that when you use control find, Alteryx centers the current view on that exact tool. That way your eye can scan the middle of the canvas and locate the tool every time without this wasted effort searching for the tool outline. 

 

 

 

 

The option to "Disable all tools that Write Output" is great during testing but I often need to toggle back and forth and its location on the Runtime tab of the Workflow Config is inconvenient.

 

I think it would be great to have a button for that on the toolbar with the added feature that it would visually display whether the feature is on or off (so you don't need to see an Output Data tool to determine the current status)

Sometimes we may have polygons, such as county boundaries, and need to split the polygons into smaller areas using polylines, such as roads. Please consider adding a polygon split by lines tool. I imagine it could be like the Poly-Split tool, but accept two inputs of a polygon field and a polyline field.

It would be AWESOME if Alteryx had a feature to export logic that is within the workflow into a Visio, PDF, or Excel document to support documentation. Documentation isn't 'fun', but it is important/necessary.

We waste a lot of time to search a field to join it in join or to deselect it select or to summarize in summarize. This mainly happens when we have long list of fields.

 

As search bar to find the field on top of any of these tools will be really helpful. 

 

Specially, for join tool if we can type the field name while joining would really help. 

 

Thank you,

Sanju

 

 

Hi Team,

 

If you can please work on the idea of auto arranging the tools on Alteryx Designer. This would save a lot of tedious efforts, when we create a very big flow then it becomes very tough for us to arrange the tools properly and it becomes confusing sometimes.

 

Thanks

I would like to raise the idea of creating a feature that resolves the repetitive authentication problem between Alteryx and Snowflake

 

This is the same issue that was raised in the community forum on 11/6/18: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/ODBC-Connection-with-ExternalB...

 

Can a feature be added to store the authentication during the session and eliminate the popup browser?  The proposed solution eliminates the prompt for credentials; however, it does not eliminate the browser pops up. For the Input/Output function, this opens four new browser windows, one for each time Alteryx tests the connection.