Alteryx Designer Desktop Ideas

When selecting a colour for a container I would like to be able to click randomize and let Alteryx pick the colour, however I would like the option to click 'random new colour' so it picks a colour not already used in a container on the current workflow  I should then be able to customize the transparency as per normal.

When I perform data type conversions I sometimes receive conversion errors. There is not a slick way to programmatically handle these that I am aware of. Instead, I have to manage them with half a dozen tools or really unsightly expressions in formula tools. As an example, I have a string field with a value "two" and I want to convert to a decimal or int. I receive a conversion error and the value is either "0.000" or "0". This is clearly wrong and I want to have a NULL value instead. I want to use a function to attempt the conversion in the formula tool so i can nest it inside conditionals in a cleaner fashion.

Here is a reference to the try_cast doc:

https://docs.microsoft.com/en-us/sql/t-sql/functions/try-cast-transact-sql?view=sql-server-2017

Understanding that for some tools / data sets this feature would favor larger displays with more screen real estate, I think it would be helpful to be able to view both the input(s) and output(s) data in the results pane simultaneously via dedicated sub-results panes for each input / output. 

To try to put some form to the picture of it I had in my head, I patched together a few screenshots in SnagIt as a rough idea on what something like this could potentially look like to the end user, using the Join tool as an example (though I think it would be cool for all tools, if that is practical). Not sure how well it will show up in the embedded photo below, so I also also attached it - for reference, the screenshot was taken with Alteryx in full-screen mode on a 3440x1440 monitor.

Not the prettiest - but hopefully you get the idea. A few general features I thought might be helpful include:

• Clean / streamlined GUI elements for each "sub-pane"
• Ability to toggle on / off any of the sub-panes
• Ability to re-sized any of the "sub-panes" as desired
• Ability to customize how many results are included in the results view of each input / output (i.e., either by row count or size)

I'm sure there would be several more neat features a view like this could support, but these are the ones I could think of offhand. To be clear, I wouldn't want this to replace the ability to click any individual tool input / output to only view that data if desired, but rather imagined this "view" could be optionally activated / toggled on and off by double clicking on the body of a tool (or something like that). Not sure whether this is feasible or would just be too much for certain large tools / datasets, but I think it would be the bees knees - am I the only one?

Let me know if anyone has any thoughts or feedback to share!

Josh

In a short workflow, this might not be necessary as the information related to each tool is spelled out in the progress windows.  However, in a complicated and lengthy workflow, tracing such msg can be a tedious task. In addition, using a tool with multiple outputs and only one output is selected while the residual outputs may be used to validate the result in the selected output; for example, joint tool where left or right output should be zero, a visual queue could be a quick way to alert operator on any potential problem.  Certainly, a browse tool can be added but in a big workflow, couple with a large data set, it might be a drain to the system resource. What if there is a tool that would activate a visual alert, like a light bulb, based on a preset condition to tell user that something is wrong and perhaps additional work needs to be done to either remedy or to account for the residual data. As in the case of a joint where 100% match is desired, any unmatched row would require an update to the reference list which maybe an additional adhoc process outside the current process. Certainly, an additional steps can be added to first explore the possibility of unmatched data and to update the reference list accordingly.  The workflow would in hold until 100% match is achieve. This would require additional system resource in order to hold; especially with large set of data and lengthy workflow.  If the unmatched situation rarely occurs, just a lightweight visual queue that 'pop' while allow the process either to break or to go through might be a sensible solution.  Just a thought.

My organization is considering a move to a Microsoft Azure platform but requires support for Bring your Own Encryption (BYOE) or Bring Your Own Key (BYOK). As such, leveraging alteryx on this data lake would require this level of support.

I would like to see Alteryx support this in the future, ensuring that we are able to leverage the power of alteryx designer within this platform.

After the upgrade to Alteryx 2018.4, the publish to tableau server tool no longer has the feature to get the authorization header to make subsequent calls in the workflow.This feature was present in the older versions of the tool i.e Publish to tableau server 1.09,1.08.1 but not in the new version 2.0.0

I think this feature should be present in all the versions of the publish to tableau server tool.

Cheers

Some Alteryx tools, like Select, update when a field name or data type is changed upstream.  Sometimes it causes an error, but often Alteryx can self-adjust and be OK.  However, other tools such as Union and Summarize, don't recognize the change - they don't self-adjust or throw an error until runtime.  It would be great if these other tools (there must be others besides Union and Summarize) could recognize changes at design time.  Even if they just threw an error, it would be better than current state.

Context:

We have several workflows, chained together and orchestrated with CReW runner and conditional runner macros, several of which have run command events.

Each developer on our team, when running these workflows on their local workstation during development and testing, must remember to change or disable certain events in several workflows to prevent unintended shenanigans in production.

Since we collaborate on- and version our workflows in Git with a branching model and automated deployment to production, each developer must also remember to revert their changes to- or re-enable these events, before pushing their changes to our shared origin.

This is a cumbersome and annoying part of our local development workflow, and a potential risk (forgetting to disable or re-enable these events could be disastrous).

Suggestion:

Allow developers to define logical conditions for triggering run command events.

This would allow us to dynamically enable run command events, based on the environment in which the workflows are run.

There exists a separate feature request for environment variables, which would be super powerful in combination with this feature request, for obvious reasons.

I collaborate with a team using Git. We commit all of our work automatically with the exception of the Alteryx Alias file. It must be moved manually into the repository and then other teammates must move it out of the repository manually into their local folder and overwrite the old file. This is not an enterprise-friendly solution. If we could configure the location of the Alias file in Designer, we could set it to live in the repository. That way, everyone could automatically have the latest file with tracked changes. Please create this functionality. Thank you.

A suggestion for the designer product...

When one right clicks on tab showing a workflow, an option should come up to duplicate workflow/macro/etc.

Hi,

I am working on a macro that has multiple listboxes and xml tree controls in it and the listbox controls have a feature in the top right to select all or none, effectively allowing you to clear any entries you had made and start fresh.  In the tree control, there is no such feature but it would be nice to have instead of having to remember and go through and find all the entries you had made to start fresh.

To the point of the macro interface, when developing and testing using the interface designer, you are able to 'reset' the interface using a button at the top of the left pane.  It would be nice if that was available in the macro interface at run time. And that would solve the issue with the tree control in one step.

Thanks,

Dan

Our company got Alteryx server a few months ago, and we were surprised to find out that (at current setup) the members of my team can not collaborate on workflows published on our Server. 

What we would like to see  (How we envision being able to share workflows). 

With any published workflow on the server, be able to publish a workflow to a shared space and/or share owner permissions with or edit abilities to with another user. 

And

Allow another authorized user to download, edit, and update those workflows - keeping them current in someone's absence (Vacation or leave for a new job). 

Please build this functionality so we can get back to using Server instead of a shared folder on the network.

Thanks,

Randy

Need to allow Aliases to work with the Google Sheets Input / Output tools, so that I can input API keys in one place to service multiple tools.  I know I can do this via Macros, but I also know it's best practice to avoid nesting macros.

I think the scheduler should include another frequency otpion of every other week.  Let's say I want a workflow to run every other Monday, there is currently no simple way to do this.  There are some workarounds but they are not ideal and include some additional manual work which defeats the purpose of having the scheduler. 

Hi,

Can we have a functionality to see total number of rows without adding a browse or any other tool?

PFA (output from Alteryx 10.0)

Thanks,

Rajesh Chandak

Data Analyst - Walmart

When a workflow has run it has it's final message.

 Alteryx Product Ideas

It would be great to have a datetime stamp included in the file message. When running multiple jobs and editing multiple workflows it would be great to be able to check the last runtime so you know when each job had finished. As I often flip between multiple workflows during development and can working on up to 10 or more at any one time 

Hello Team,

I have been using Alteryx for sometime now. The final output of any kind be it analytics or simple Excel outputs is expected to have some basic formatting.

A minimum of 3 Tools and humongous effort is need to format even basic headers and Cells with a border and color.

Using Table followed by Render and then column level setting for having borders for the set of data is little time consuming considering it has 0 impact on the actual data output.

Additionally Render tool to Excel will be in number format regardless of the data type. Same is the case for date fields.

Also the Render tool Layout changes impact the data as well as the column lengths adversely.

Can we have some simple option of overwriting a file where the formatted excel is merely overwritten with data without changing the datatype or format out the excel sheet.

It would be huge win if this is easily do-able wither via a new tool or as an option in the output tool.

Hello All,

During my trial of assisted modelling, I've enjoyed how well guided the process is, however, I've come across one area for improvement that would help those (including myself) overcome any hurdles when getting started.

When I ran my first model, I was presented with an error stating that certain fields had classes in the validation dataset that were not present in the Training dataset.

Upon investigation (and the Alteryx Community!) I discovered that this was due to a step in the One Hot Encoding tool.

Basically, the Default setting is for all fields to be set to error under the step for dealing with values not present in the training dataset, but there is an option to ignore these scenarios.

My suggestion:

Add an additional step to Assisted Modelling that gives the user the option to Ignore / Error as they see fit.

If this were to be implemented then it would remove the only barrier I could find in Assisted Modelling.

Hope this is useful and happy to provide further context / details if needed.

I find myself constantly in a situation where I am building a workflow and need to add a browse tool or branch out from the main path to test some ideas or check something and it is very annoying having to run the whole process again, I know that there is the option to cache but it the criteria is very impractical because you can't cache at different points in the workflow easily.

It should be possible to add some tools like browse or output to a file without having to re-run the whole workflow again.