Alteryx Designer Desktop Ideas

Is it possible to have a feature for Left / Right Outer Joins within the existing (out of DB) Join tool? At the moment, let's say I want to do a Left Outer Join, I have to do a Union of the Left segment & of the Inner Join. This is a little inconvenient. Any way we can give users a choice about Left / Right Outer Join and Left / Right Inner Join?

In the Result window, user can expand the Column Width but not the Row Height, and cannot Wrap the text.

It's a kind of necessary user friendly feature to view the entire text easily.

Sometimes, if text is too large in each field, then expanding the column width for all the fields and scrolling left/right is really annoying.

Rapid Mouseless Development Step forward!  We're so close -

Please:

1.  Add a hotkey to bring the cursor to Global Search and/or engage global search whenever you start typing in a contextless location (whitespace)

2.  Enable arrow key navigation of the elements of global search

3.  Hitting Enter key from global search would insert the selected tool after the last touched tool on a workflow or in the workflow at a logical point (bottom rightmost bound etc), focus would not be transferred to the inserted tool, but should either remain context-less or stay in Global search

4.  Hitting the TAB key from global search would insert the selected tool, just like Enter but take you to the first element of the inserted tool's configuration.

Take your development speed to new levels by reducing the keyboard to mouse to keyboard back and forth.

There are three places that provides the log information:

1) Regular results window:

Pro: In the process sequence so the user can understand the order of the process.

Con: Doesn't have info on how long each tool takes to process.

2) Workflow -> Runtime -> Enable Performance Profiling

Pro: Processes are sorted in the processing duration descending order which helps to identify the ones that took long to run.

Con: Doesn't show the process sequence.

3) Actual Alteryx log file:

Pro: There are timestamps for each process so the duration can be calculated.

Con: Not ready accessible and not user friendly to be seen from the interface. Not clickable to see more details in the workflow.

I think it will be SUPER HELPFUL to integrate all three together to show in the process order along with the running time.

I know we have the capability to copy a Tool, and paste it into a Connection. This step requires having to right click on the connection to select the option Paste In Connection. I don't know how many times I've tried to copy tool, click on connection, and do Ctrl + V to paste just remember that it does work that way. It sure would be nice if it did.

The unique tool is great for removing duplicate items.

However, if wanting to identify and extract all items that have related duplicates (i.e. the unique item and the associated duplicates), I currently need to use a summarise tool with count, a filter tool to identify the duplicate items and join tool to link back to the original data set. It sometimes takes a few times to get the right combinations, and additional summarise and join tools are sometimes needed.

It would be great if there was a duplicates tool which worked like the unique tool (i.e. you can select the field to duplicate on) and pulled out the unique item together with the associated duplicates.

It could be useful to keep track of changes to workflows by adding changelog notes to the Meta Info in workflow configuration

Maybe I am a newbie, but it is really galling that the drop down tool in the interface palette wont show the values in a connected tool unless they are spun up as headers in a cross tab using a record ID ruse. Alteryx really needs to provide this very common use case. This functionality is so easy to implement and is a fundamental part of any UI. Take a field and show its values as a drop down. Please tell me I am missing something and that this is really easy. I know we can save it as a name value pair in a yxdb and then input that, but I should not have to do so many things for what is an essential function.

I'd like to be able to quickly  see how many records were read from my inputs and written to my output so the Files choice in the result window is handy:

However it also shows all the Browses which if you have a large workflow can make you scroll to find the actual files. In the above example 10 of the 54 are files, the rest Browses.

I would prefer the Files button show JUST the Inputs and Output and not the browses. Either ditch the browses or add a separate button for that.

Cheers,

Bob

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!

It would be extremely helpful if you could add more parameters to the string functions to make them more powerful and useful. For example, adding a parameter into the get Word Function to match whole word only would be really nice in situations where you want to match the term VA, and not valley. Otherwise, you would end up building a regular expression to find what you are interested in when that may be overkill for the problem at hand.

We all love the Directory tool as it allows us to read in a list of files in a given folder location and sub-folder location, but wouldn't it be nice if we could use the tool to connect to a database and read in a list of table names? This would allow us to easily build batch macros to allow us to loop through all tables within a datasource as we can with flat files.

This would be a great help in data migration, as I could then build a single tool where I could just input the connection string to the source from which I am extracting and the destination connection and migrate the data automatically.

Would be nice.

M.

Instead or in addition to be able to manually enter additional stop words, it would be great if you could have an optional input connection where you could point to a file with additional stop words in it.  Very manual to type the additional stop words in...

Every workflow I write, I want it to avoid having references to my C: drive.  Every time I enter a tool, I have to remember to reset the Workflow Dependencies to All Relative. 

If the setting for Workflow Dependencies could be a persistent environment variable, I could flip the flag, and every tool added after that would use relative references.

Hi!

I just installed 2020.2 & I LOVE this update within the Formula tool:

• When you double-click a column name inside of an expression, the brackets around the column name are also selected.

Are there any plans to bring this ability to the Filter tool as well, where I can double click on my column name & have it grab the brackets as well?

Not going to lie, love that you added the Open/Save/Undo buttons back to the top toolbar too! Latest version looks great, thank you!

Model evaluation (including feature importance) is only available in assisted modelling within the machine learning tools.

It would be great if there was a tool to do this when using the expert mode so that you could see some standard performance metrics for your model(s) and view the feature importance.

I want to check out which things downstream are receiving data from the true and false branches of this filter.

I could step through them one by one.

It would be much easier if I could simply select the tool and see directly which tools are connected to which output by colour, or line style.

Could the Input connector have capability to load data from an ODS / OpenDocument Spreadsheet?

Currently file with an ODS has to be opened using Microsoft Excel. Save file as xls or xlsx extension.

Also an ODS file with 373 columns/fields required to have fewer columns /fields to use the Alteryx Input connector.

Submitting this idea, after initially logging on the community board.

Hi team,

There are some things that we would like to do with the download tool that currently are not possible:

1. use client side certificates to sign requests. This is a requirement for us in a project where we are interacting with the API of our customer's financial system. They provide us with a certificate and it is used to sign our requests, along with other authentication.Currently we have to use the external command tool to execute a powershell script using invoke-restmethod to do this interaction. I would much prefer to not have more tools in the chain.

Client certificates are described in the TLS 1.0 specification: https://tools.ietf.org/html/rfc2246 (page 43), and I believe them to be supported by cURL.

2. Multipart form-data. We have a number of workflows where we need to send multipart form data as part of a POST request. As this is not supported by the Download Tool, we have again used the external command tool to execute invoke-restmethod or invoke-webrequest in powershell. I don't know if modification of the Download Tool would be the best thing here, vs having either a dedicated tool for multipart form data, or having an HTTP POST specific tool that was able to handle multipart form data. What I envisage is something like the formula tool, with the ability to add an arbitrary number of cells, where we could use formula to either directly output a value from a column, synthesise a new value, or directly enter a static value). The tool would then compose this with boundaries between the parts, and calculate the content-size to add to the http request.