Alteryx Designer Desktop Ideas

Please consider adding the ability in the Power BI Output Tool to create/modify multiple tables per dataset - having to work with only single table datasets in Power BI is very limiting.

When numerous formulae exist within a single formula object, being able to "Expand All / Collapse All" would be most welcomed.  :-)

Also - the ability to Disable/Enable a single formula in the formula object - also very nice to have.

When you enter a search term in the results window, it would be great if it highlighted that term in the data results window. Otherwise, it still takes work to find where your search term is located in each row.

The desginer autosave feature is fantastic when you need it. However, it's pretty annoying when you don't need it as it seems like it:

• Autosaves blank workflows
• Autosaves workflows that are saved and haven't had any changes made to them

Hopefully all of the above can be filtered out from Autosave: 

The only workflow from the screenshot above that I'd want Autosaved would be the Parse Directory workflow as this is the only one which I made changes to:

- New Workflow1 - Completely blank

- PureGym Log In - Saved and no changes made

- New Workflow2 - Completely blank (however, I had dragged a tool onto canvas and deleted it, so something had changed)

However, Alteryx brings up all of the workflows:

I love the new right click and duplicate workflow feature, but I think the duplicated workflow that opens, should open next to the original workflow and not at the end of all of your already open workflow tabs...

cc: @jpoz @jeffv 

I would like to suggest 2 small changes to make working with Interface tools easier:

1) Let a user change the name of Question Constants from the workflow tab. For example, I would love the ability to change the names of my list boxes below. Currently, I can click in the name box and write new names in, but it doesn't stick.

2) Let the user add the value on the Interface tools under the Annotation tab. Currently, I drop an interface tool on, change the name on the annotation tab, and then have to go the the workflow tab to setup a value. It would be easier if the value box was also on the annotation tab:

Hello,

In my company, we have our personal account (let's say myorganization\saubert) and, if we have the right to, a LOCAL admin account (eg : .\adminsaubert) to make install of sofware, etc...

So, the license is on my personal account

Now, I want to access the System settings :

And then  I have this very friendly message :

If i click on "OK", it opens the License manager.
If I click on "Cancel", it closes the windows and I'm unable to change my system settings.

I think changing these system settings shouldn't require a license.

Best regards,

Simon

Hello!
I like to annotate my workflows when finished, and it can be a bit of a pain to add more and more comment tools by searching for them, or going through the current right-click menu:

What would be nice is the option to right click anywhere on the canvas, and have the option of 'add comment', similar to how we have the option for 'add container' when selecting tools on the canvas.

Cheers!

I would to suggest to add a configuration in the Block Until Done tool, which allow the user to prioritize the release of a data stream through multiple Block Until Done tools in the same module. 

In the example below, the objective is to update multiple sheets in a single Excel workbook. Each sheet is a different data stream, that cannot be unioned together, therefore making the filtering of a single stream feeding into multiple Block Until Done from that filter solution impossible.

What I would like to be able to do is have a configuration, where Block Until Done #2 will not allow the data stream to pass through until Block Until Done #1 is complete, Then Block Until Done #3 will not pass through the data stream until Block Until Done #2 is complete, and so forth through the all the Block Until Done instances. 

The Undo button in Alteryx has saved me many times! Unfortunately, I never know what all was "undone" when I click the button. It would be nice to update the Undo process in 2 ways:

• Replicate the Excel undo drop down (which includes a brief description of what will be undone and allows you to undo multiple actions at once).

• Move your location on the canvas to the area affected by the Undo-ing. Currently your location on the canvas doesn't change when you press Undo, even if the change being undone was off screen.

There is a need when visualizing in-Database workflows to be able to visualize sorted data. This sorting could be done 1 of 2 ways: In a browse tool, or as a stand-alone Sort tool. Either would address the need. Without such a tool being present, the only way to sort the data is to "Data Stream Out" and then visualize the data in Alteryx. However, this process violates the premise of the usefulness of the in-DB toolkit, which is to keep your data in-DB and process using the DB engine. Streaming out big data in order to add a sort is not efficient.

Granted, the in-DB processing doesn't care whether data is sorted or not. However, when attempting to find extreme values after an aggregation, or when trying to identify something as simple as whether null values are present in a field, then a sort becomes extremely useful, and a necessary tool for human consumption of data (regardless of the database's processing needs).

Thanks very much for hearing my idea!

Hi,

I would like to be able to modify my connection string in the Alias Manager.

Connection string is greyed out :

If I want to change my connection string, I have to create a new alias.

When I proceed with this command in a python tool:

from ayx import Package

Package.installPackages(package='pandas',install_type='install --upgrade')

in Alteryx it only updates to 0.25, but the Latest version is 1.1.2.

When I would like to upgrade from the Python side i get the following:

ERROR: ayx 1.0.54 has requirement pandas<0.25.0,>=0.24.2, but you'll have pandas 1.1.2 which is incompatible.

Can you please make sure we can upgrade to the latest version of pandas without any compatibility issue?

This is important because of json_normalize. Really useful tool, available from pandas 1.0.3!

The default (option 7 below) often causes problems with imports and is difficult for new users to find and I see no reason for the option to be so low. Can it be set higher to aid parsing of larger text fields e.g. parsing HTML files as text.

Hello!

This is along the same lines as my other thread:
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Allow-For-Drag-and-Drop-in-The-Interface-Des...

I love building Analytic Apps, and i wish it was just a little bit quicker to do.

Currently when adding an element from the dropdown to the interface designer:

it will always be added to the bottom of the interface:

And requires moving manually. It would be great if depending on where you have selected on the interface, the element is created. For instance, i would like to select one of my elements:

Hit add - Label:

And the label be created under my element:

Thanks,
TheOC

We have a need to be able to trace the lineage of fields being processed through Alteryx - and it has to be done at a field level to satisfy our regulator.   In essence, we have to be able to show exactly where a particular field came from, and demonstrate that we can trust this field.   NOTE: If we could do this - then we could also use this information to make EVERY canvas faster, by checking for unused fields and making suggestions to remove these unused fields early in the flow.

In order to do this - it would be great if there were an option to force explicit field names in the Alteryx XML so that we can trace a specific field.

• Alteryx currently only makes a note of a field name if it is changing that field which is very economical - but it makes tracing fields impossible.
• Desire is for every tool to write the field list to the XML definition for every field that it knows about (just like it looks in the UI)

cc: @AdamR_AYX @jpoz @Claje 

Example:

Here's a simple canvas:

- 3 fields coming in from an input

- Select tool with these 3

- output of three fields into a file

These three fields are not mentioned anywhere in the XML

It would be nice to have a tool that automatically normalized data, or calculated percentages.  This could be overall or in groups. 

For example, maybe I have a dataset with 2 columns: US State and Number of amusement parks.  So I know the count of amusement parks by state.  But maybe I want a distribution so I can see which percentage are in what state.  What I want is (# of parks in a state) / (total across all states).  Currently you need at least 3 tools to do this calculation (summarize, then join or append fields, then formula).  This is a very common operation, and often I want counts and percentages next to each other in a table.

Such a tool could be called "normalize" or "rescale" or "scale".  It could be more general - maybe not just normalizing so values add to 1 (or 100%), but to other magnitudes, recentering the data, or doing a "standard normal" (z score) transormation as suggested here:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-do-Feature-Normalization-in-Alt...