Alteryx Designer Desktop Ideas

Hello all,

It will be great if there is an option to specify sql statement or delete based on condition in write In-DB tool. We have to delete all record even though when we are trying to delete and append only a subset of records. If it allows for "WHERE" statement atleast, it will be very much useful. I have a long post going on about this requirement in http://community.alteryx.com/t5/Data-Preparation-Blending/Is-there-a-way-to-do-a-delete-statement-in... .

Regards,

Jeeva.

I would like a new format option within the Designer function DateTimeFormat such that where a date is held in the database

e.g. 2023-01-01

DateTimeFormat([date],%o)

will return 1st not 1 or 01. 

Workarounds exist, but are fiddly given the different options....1st, 2nd, 3rd, 4th.....

I have tried to search for this Idea but not located one that is same or similar. 

When searching for tools to use rather than having to click in the search bar at the top, it would be nice just to click on a blank part of the canvas and start typing for the tool that you need, then a suggest tool list pops up and you just click on the one you want to it appear. 

Thanks

Dynamic macros that fetch the current version at every run time vs storing a static copy of the macro with the workflow at publish time are challenging to pull off using shared drives. 

This suggestion is to store dynamic macros in the gallery and secure their use with collections.

Right click + "Insert After" and Right click + "Paste After" should behave the same. In the picture below I show the two cases. Currently, the "Insert After" option inserts a tool between the selected tool and the tools after it. The "Paste After" creates a new branch with the pasted tool. I think the "Paste After" should behave the same as the "Insert After": paste the tool on the existing branches. In case we want to create a new branch, we will paste the tool and connect a new branch to it.

Sometimes the field names for an imported file are very unhelpful.  Consider the image below as an example.  Even though the AUTO FIELD tool has been applied to this imported CSV file it is still necessary to inpect the source data before assigning field names and descriptions. 

MY SUGGESTION:  insert a data preview column in the Configuration view between SIZE and RENAME.  This data preview column would show the first row of data but a scroll function would allow the user to advance to the next or previous record within this view.  This feature would enhance the productivity of analysts in the data preparation phase of their work.

Providing access to the Oracle Cloud for OTM would allow users to connect to the API's to deliver data sets from the Cloud and use it for workflow and other data management activities.

Quite often, I would love to be able to use Browse tools already while the workflow is still running, if that specific Browse tool has completed (green box around). This would help to debug and save a lot of time.

In this case, the lower Browse tool would be enabled already now.

I recently began working with chained analytic applications.  One of the things that I wanted to do was to take the values selected by the end user at each stage of the app and pass them further down in the application.  I was able to do this by dumping the selected values to Alteryx databases and then using drop downs to pull the data into subsequent apps.  However, I was wondering if there would be a better way of accomplishing this.  One reason is that, with my approach, I wind up with several additional drop downs in my interface--which I really don't want.  If there's a way around this, I'd love to hear it.  Alternately, if Alteryx could potentially support doing something like this in the future, I think it would be really helpful.

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

Dear Alteryx Team !

When running an app the actual Analytic App Progress window is not very informative and can not help to know where do we stand in the process.

In order to improve that issue, it would be very nice to give the hand to developers to let them choosing which message should be display in the progress window.

Minimal need :

• At each macro step : A view of which macro is actually running with their corresponding iteration counter

Optimal need :

• Allowing to completely design and name the messages to display at each macro steps and iterations (free text + iteration counter + time estimation ...)

Many thanks

Arno

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. 

My Team Heavily rely on Dremio. 

It would be great for Alteryx team to add Dremio as a dedicated data source Input for Alteryx, it would be so much easier for us to configure and run things in the future. 

Thanks! 

Being able to specify a name for the FileName field in the Input Tool configuration would be helpful for cases where a field named FileName is already present in the input data and has a different purpose than the newly added FileName field. Instead of having to use Field Info and other tools to rename the last field into something else (i.e. AYX_FileName), this would be an easier approach.

The C API for e1 is included in the Designer Desktop installation. The new AMP engine must have a C API as well, but it has not been released publicly.

Let tool and SDK makers create custom tools that plug into the AMP engine by releasing the specifications of the AMP C API.

After you've saved a file from the Browse tool, a popup window appears to confirm the file saved.  That popup window contains an image off text that you can't copy/paste.

I recommend turning that text into a hyperlink so users can just double-click on the popup window to open the file they just created.  Or add another button to "Open File" next to the "OK" button.  This would eliminate the need to go find the file you just created.  

Thanks for your consideration

The Explorer Box is great for embedding help documentation into workflows. That being said, there are several text-based file types that cannot be accepted into the Explorer Box such as .sql or .log. Since these are essentially text files, I'm suggesting that the Explorer Box should be less strict regarding file extensions and allow all text-based file types to be viewable.

The "idea" here is, for any tool utilized in a macro project, to allow any configuration setting for that tool, if desired, to be exposed to the outside world, so that when the macro is utilized in a parent workflow, the embedded tool's configuration setting is directly available to the parent workflow.

A benefit here would be the ability for users to more easily build custom tools based on the existing tools: e.g. send all inputs and outputs through a validation phase of arbitrary complexity, while leaving the "integration layer" of the encapsulated tool untouched.

Sometimes when creating a workflow, or a chained application I create fields or parameters in a formula tool and need to be able to quickly copy and paste the entire formula output column into another formula tool across a different part of the workflow / entirely different workflow.

This most often happens when standardizing fields across different data streams. We have the ability to save expressions, but if you save too many that can quickly get messy. We also have the ability to copy and paste a formula within a formula output column...so why not extended the functionality slightly to copy/paste the entire formula output column?

In this proposed enhancement a user could right click on the 3 lines at the top left of the formula section and copy/cut a formula output column between formula tools: