Alteryx Designer Ideas

It would be useful to be able to select a single container (containing a data input) or multiple containers using Shift, and run those and only those.

When building a new element to a larger workflow, I often enter a new Input in a new container, the ability to run just that container without having to turn off all my other containers would be really useful in speeding up the start of joining things together.

Hope that makes sense.

Thanks,

Doug 

Alteryx does not currently have to email tool that is configurable to use SMTP Authentication for Microsoft Office 365 or any server requiring authentication.  Our office printer can authenticate over SMTP and with TLS enabled why not my Alteryx mail tool - 'mic drop!'. 

Further explained, Alteryx is a tool that needs to live within abide by the policies and security standards in the organization not vice versa.  Therefore, it shouldn't be a big surprise, or a big ask for that matter, that a mail client should have the ability to authenticate prior to sending email of SMTP.   I'm very surprised this tool is so arcane.  Please implement quickly.  Thank you

Hey all,

I would love to be able to have an interface tool that allows a user to search through drop down values (when there are more than 100 or so) similar to autocomplete. It would be helpful as a multiselect or single select drop down. I have inserted a very poorly mocked up picture below. It would essentially be a modified version of the drop down as all the values would be in the tool, but the user could type to find what they are looking for.

When I use the Comment Tool its difficult to select the tools inside it, but when I use the Container Tool the Container Text doesn't support Font Sizes, and doesn't support multiple lines of text so I end up moving the Comment into the Container, but still have problems selecting a group of tools.

So a combined Comment and Container Tools would be wonderful!

Bonus: If the Comment Tool could support Multiple Font Sizes.

There's often a need to do a cascade of filters which would normally be handled in a programming language by a Case or a Switch statement.

For example:

- if it's a cat then go left, otherwise go right 

      - if it's a dog then go left otherwise carry on right

             if it's a fish then go left otherwise carry on right

                   otherwise do xxxx

This could be handled more elegantly by a conditional split tool that allowed you to specify multiple conditions like a case statement, and which then generated multiple output nodes; with the last one for any leftovers.

I've seen this question before and have run into it myself.  I'd like to see a new tool that would allow a developer (of a workflow) to choose a path of logic based upon criteria known only during the execution of a module.

If LEFT INPUT Count of records < 10,000 THEN Path1 (e.g. use a calgary join)

ELSE Path 2 (e.g. use a standard join)

endif

Thanks,

Mark

Disabled Containers throw errors if it contains any interface tools. It should not throw any error as the user is intentionally disabling the container.  

Unsupervised learning method to detect topics in a text document.

Helpful for users interested in text mining.

I constantly find my using pre and post SQL Commands in the Output tool to run SQL when I don't actually have any data to output.

One example is when I load data into S3 and want to load it into Redshift. I have SQL code to run but no data to Output - I end up running a dummy row into a temp table.

So can we have an SQL tool that simply acts the same as a Pre-SQL command without the associated data output. Once the command is run we should be able to continue the workflow, so the tool should have an option input and output, like the Run Command tool.

While In-db tools are very helpful and cut down the time needed to write complex SQL , there are some steps that are faster by directly writing SQL like window functions- OVER (PARTITION BY .....). In Alteryx, we need to create multiple joins and summaries to perform a window function. It would be immensely helpful if there was a SQL editor tool for in-db workflows where we can edit the SQL code at any point in the workflow, or even better, if they can add an "edit" function to every in-db tool where we can customize the SQL code generated and then send to the next tool.

This will cut down the time immensely and streamline the workflow to make Alteryx a true contender for the ETL solution space.

The introduction fo a rank tool would be hugely beneficial. Whilst there are currently means to rank using a combination of other tools formula/running total/multirow etc... a specific "Rank Tool" would be provide a seemless and smoother way to rank your data either for further analysis or purely to output this field.

This tool should include a sort by and group by functionaility as well as options for ranking (such as dense ranking or unique ranking) and in addition multi levels of ranking (ie. Rank by "Field A" Then By "Field B" etc...).

DELETE from Source_Data Where ID in

SELECT ID from My_Temp_Table where FLAG = 'Y'

.... 

Essentially, I want to update a DB table with either an update or with the deletion of rows.  I can't delete all of the data.  My work around will be to create/insert into a table the keys that i want to delete and try to use a input/output tool with SQL that performs the delete.  Any other suggestions are welcome, but a tool is best.

Thanks,

Mark

I think this is fairly self-explanatory and is a very common use case.

Would like to have a tool that can natively support DateTimeAdd functionality where you can define working days of the week for inclusion and holidays for exclusion.

Must be able to handle both adding and subtracting.

Problem.

My Workflow poll incoming data directory for new files. When there are no files, I want Workflow processing to be stop without any error.

1. Workflow has an email event - send email on error. This is to notify owner that workflow has failed.

2. If I fail workflow on my given condition using Message Tool - error and stop further processing, then event in step 1 triggers and send email which is undesirable.

I want event in step 1 triggers on workflow errors excluding user initiated error as in step 2.

Proposal:

1. Can have a tool or config for controlling Events dynamically? Say, on a given condition I want to disable a Workflow Event?

2. Message Tool : Can have another Message Type options like:

          - Stop Workflow Processing without Error

          - Stop Workflow Processing with Warning

XGboost regression is now the benchmark for every Kaggle competition and seems to consistently outperform random forest, spline regression, and all of the more basic models. For those of us using predictive modeling on a regular basis in our actual work, this tool would allow for a quick improvement in our model accuracy. And I think, from a marketing standpoint, having a core group of users competing in Kaggle using Alteryx would be a great way to show off Alteryx's power.

It is readily available as an R package: https://cran.r-project.org/web/packages/xgboost/index.html

Designer should support statistical testing tools that ignore data distribution and support Statistical Learning methods.

Alteryx already supports resampling for predictive modeling with Cross-Validation.

Resampling tools for bootstrap and permutation tests (supporting with or without replacement) should be tools for analysts and data scientists alike that assess random variability in a statistic without needing to worry about the restrictions of the data's distribution, as is the case with many parametric tests, most commonly supported by the t-test Tool in Alteryx. With modern computing power the need for hundred-year-old statistical sampling testing is fading: the power to sample a data set thousands of times to compare results to random chance is much easier today.

The tool's results could include, like R, outputs of not only the results histogram but the associated Q-Q plot that visualizes the distribution of the data for the analyst. This would duplicate the Distribution Analysis tool somewhat, but the Q-Q plot is, to me, a major missing element in the simplest visualization of data. This tool could be very valuable in terms of feeding the A/B Test tools.

Here's a twist on the iterative macro.  Suppose, like a generate rows tool, you could initialize a container to iterate on it's internal processes without having to construct a macro?  The container could include anchors for iterations and for output and allow the user to DoWhile inside of the container.

Just a thought....

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.