Alteryx Designer Desktop Ideas

Hi 

In a toold like select it would be nice to place curser in Field - and type the first letter of the fields you want to browse through.:
By pressing F here I would just across fields that starts with F.

Sometimes you want to preserve the field order from the sorce, and if you have many fields it takes a while.

Or beeing able to filter - just like in excel:

Same goes for formula box:

Beeing able to click D as an example and click though coloumns starting with D.

Hello Alteryx Dev Gurus - 

We are migrating and some workflows that used to successfully update a datasource are now giving a useless error message, "An unknown error occurred".  

Back in my coding days, we could configure the ORM to be highly verbose at database interaction time to the point where you could tell it to give you every sql statement it was trying to execute, and this was extremely useful at debug time.  Somewhere down the pipe Alteryx is generating a sql statement to perform an update, so why not have something on the Runtime tab that says, 'Show all SQL statements for Output tools'?  Or allow it on an Output tool by Output tool basis?  If this was possible by changing a log4j properties file 15 years ago, I'm pretty sure it can be done today.  

Thank you for attending my TED talk on how allowing for detailed sql statements to bubble back up to the user would be a useful feature improvement.  

Hello,

The release notes quality is not exactly at its best nowadays The 2022.1 releases notes available here https://help.alteryx.com/release-notes/designer/designer-20221-release-notes don't mention at least two cool new features :
-DCM for in-database connection.
-distinction between greenplum and postgresql, which is important for me as I post this as an idea : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Separate-entry-in-in-db-configuration-for-Po...

Note that the corresponding idea aren't also up to date.

It's cool to have new features, it's way better if you gives the full list.

Best regards,

Simon

i investigate a super messy and huge workflow, i have a hard time to trace back the data stream.

it only have around 5 wireless connection, some is easy to find, but some are connect to union..

if have a button to turn all connection back to wire, and better if have option for just solid for temp to show as solid line. it will helps alot.

When we rename a field in canvas it breaks a lot of formulas or config on tools like select tool or unique tool or summarize tool. If designer can automatically update these new field names in all the further tools if will save us a lot of time.

Thanks,

Sanju

Please introduce functionality whereby users can pull up a listing of all input data connections leveraging database queries. This would be exceedingly useful in instances where users can either individually or bulk edit various connection configurations, such as:

1. change connection query
2. change data connection source 
   • for example, if a connection configuration has changed via a new setup

This would be far more useful than scanning through the canvas looking for all of the input tools. Especially if the workflow is highly complex leveraging multiple inputs to various data sources. You could also incorporate a link for users to click on to take them to the point in the canvas where the input tool is located.

I annotate every single tool, every single time. I treat a workflow like documentation. It would be helpful to use markdown in the annotations.

Often (like, a surprising amount of the time), we will be on a working session with a customer and I'll notice they will break a data stream connection in order to prevent downstream tools from running.  Of course, I always coach them to add a tool container to the downstream tools, then disable it but they continue to choose not to.  

I'd love to see a feature where we can right-click on a data stream, then select "disable downstream tools", which then auto adds (and disables) a tool container. 

Gif of current behavior I too often see below, thank you!

Hi Team,

This is very helpful if you add the run and stop option in scheduled workflow for Alteryx designer desktop automation. There is no option of pausing the workflow. this idea should be implemented that will make life easy who are running n- number of workflows.

Thanks,

Kaustubh

Olá, não sei se classifiquei a ideia na caixa correta, mas eu gostaria de ver uma ferramenta, provavelmente na aba "Transformar", e que traria o subtotal e total de um conjunto de linhas, sem ter que construir um fluxo somente para isso. Acredito que com uma ferramenta, apenas, o problema possa ser resolvido, como no exemplo anexo, o que é bem fácil de fazer no Excel, por exemplo.

FILE==>Open Recent==>

(add the ability to Pin Favorite Workflows)

The Pinned workflows will persist at the top of your recent files each time you open your Alteryx Designer Application.

See this community link for context:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/There-is-no-option-to-clear-the-In-...

tl;dr: 

An option to clear the In-DB File History is not available in the Designer's GUI. If this feature is required, it's recommended to open an Idea on the Alteryx Community to submit an enhancement request.

Please implement this as an idea; I need to clear some In-DB connections that are no longer valid and in a managed environment, accessing the registry is laughable.

Thank you!

Hi,

I know that @MarqueeCrew had an idea for Auto-UNC which was "Not Planned" last year, https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Auto-UNC-when-saving/idi-p/194681, but what about a simple flag/pop-up to let users know when they hit "save" or "save as" that there are relative paths being used in the workflow (Perhaps even indicate any/all tools that they appear) and closes out the upload without closing out the workflow.

I don't see a solution out there for this, but if it exists and I am just a bonehead, please feel free to delete this thread.  🙂

Thanks

Dan

I've recently developed a complex Standard Macro which gets called from a workflow. It has multiple input tools and output tools where the output tools create an excel file on a drive location.

Every time I try making changes to my macro, I want to test certain aspects of the macro and would not want any output file generated. The way I am doing that now is by placing each output tool in a separate container and manually disabling each container. This involves unnecessary extra containers, is quite time consuming and I risk missing disabling an output causing an unwanted file creation.

It would be nice if I could have an option to disable all Output tools in one go - perhaps an extra setting can be offered in the Canvas to do this. A "debug" mode could also be explored where, much like VBA and possibly other coding languages, Alteryx runs a workflow / macro from Point A to Point B only, or runs the entire workflow and skips the output portion unless specified.

This may be a bit of a pipe dream but having an interface that would automatically and efficiently implement quantum computing functionality against different back ends would position Alteryx to be a user friendly interface to the quantum computing realm. My feeling is that, at the end of the day, most people will know quantum programming about as well as they currently know GPU programming, which is to say not at all. They'll need an easy-to-use tool to translate their wants to some form of quantum speed-up. Q#, Qiskit, Cirq and Bra-ket are neat, but suppose Alteryx had a "quantum solver" tool that would handle a lot of the dirty work of setting up, say, a quantum Grover Search, where the user just describes what they need.

I know some of the heavy hitters are already trying to simplify the interface to the quantum realm (e.g. as of 1/1/2021: Google Cirq, Microsoft Q#, IBM Aqua, AWS Braket all moving beyond basic enablement into realms of user friendliness.)

Just a thought!

Hello,

For those unfamiliar, static type checking in Python is a process that analyses your code without executing it, highlighting any potential errors such as type mismatches. An example of this is MyPy (https://github.com/python/mypy), this tool allows developers to easily address issues before runtime - which is a personal gripe of Python (and why I love Alteryx so much).

I believe that integrating static type checking, such as MyPy, into Alteryx Designer could vastly improve the users experience. A user of Alteryx Designer expects intuitive feedback - generally through the error red exclamation marks or messages, and this change should align the Python tool to the expected functionality.

Data Connections and Workflow Credentials are key part of migration process for workflows to Gallery.

They are provisioned for each user upon request.

When a developer leaves the organization, there is no easy way to identify all the Data Connections and Workflow Credentials assigned to that user.

Current options in the Gallery is for the Admin to browse through each Data Connection and Workflow Credential, navigate the Users tab and identify the list users. 

For a large organization with many Data Connections and Workflow Credentials it will hard to manage this since.

1. If the workflows change ownership, the new owner has to be given access to the Data Connections and Workflow Credentials.

2. Remove user access to the Data Connections and Workflow Credentials.

A Gallery page in Admin should include all Assets a user owns/has access to which includes the following. By selecting a user, the list should populate.

1. Workflows
2. Schedules
3. Collections
4. Data Connections
5. Workflow Credentials

We have implemented a solution to capture this information by getting the details from MongoDB. Also an automated process where the list goes to the manager when a developer leaves the organization so that he can manage the assets by identifying a new owner for the assets.

In the new version, we have an easy way to change ownership of a workflow in Gallery. In the same manner other Assets also should be taken care.

Most tools do not result in record changes: Select Tool, Data Cleansing, Record ID, Formula, Auto Field, Multi Field/Row, etc.  It would be nice to be able to tell Alteryx which tools to display the Connection Progress; specifically the Record Counts.  It would reduce the clutter/noise and allow the Record Counts to only display for the tools that matter to the analyst/user.  Right now it displays for all tools regardless of whether the records changed or not.  My hope would be to tell Alteryx to only display the Record Counts for tools like: Input, Output, Filter, Join, Summarize, Crosstab, Unique, etc. and ignore all other tools.

I would like the ability to configure a default naming convention for yxdb files created through the "Cache and Run Workflow" feature.  For example, the naming convention could be <YXMD filename>-<ToolID>-<CreatedDateTime>.yxdb.

This would make it easier and faster to identify and re-use yxdbs.