Alteryx Designer Desktop Ideas

The SQL compiler within the Input Tool places a space between operators causing a SQL syntax error.

Eg.

SELECT * FROM [DataSource] WHERE [Dimension] != 'abc'

Becomes

SELECT * FROM [DataSource] WHERE [Dimension] ! = 'abc'

The compiler should not add a space in this instance as it violates the syntax rules and triggers an error.

With all the talk of #TeamVertical and #TeamHorizonal an idea emerged for diagonal orientation. Now, it's a funny idea at first glance, but actually having the ability to control the general organization of a workflow could be very helpful. Imagine if there was a dot or arrow like in word that would enable us to tilt the canvas to fit our screens better. Like below, but leaving the text horizontal.

This solves the problem with the Left Join anchors moving to the top and instead allows anyone to rotate their workflow to what fits the case.

Thanks!!

#Team45Degrees

Issue:

Oftentimes when a workflow has an error, the error message is very long and is difficult to read in the results window. Currently, if you hover over the error message in the results window, the error message will popout but only for a couple seconds. Reading the error messages is a crucial step in troubleshooting the issue with a workflow, however, with the current experience it becomes very difficult to read the entire error message prior to the popout expiring.

Solution:

Simply double clicking any message, especially an error message, in the results window should have a permanent popout window presented to the user. This message window will allow the user to scroll down to read the entire message (if lengthy), popout the window further, minimize the window, and exit the window entirely. 

All,

I'd like to be able to disable the notification to update Alteryx toward the top of the screen.  The longest choice is only one year...I'd like to turn it off forever, since we control versions used internally and it is driven by the server version.

Folks are updating their software when they shouldn't and causing issues for each other.

Thanks for any advice.

File has a different Schema than the first file in the set- This is error received in Dynamic Input Tool, when there is change in data type any column in the file.  My File has a column Which comes in " V String" Data type but suddenly it comes in " Double" then this error will come.

Tool should ignore this error and consider incoming data in a data type defined while in configuration, so request to provide feature to configure data type in Dynamic Input Tool.

Hello Alteryx,

Would it be possible to extend the "Cache and Run" functionality also to tools with multiple outputs? Our clients use the R and Python tools very frequently and the runtimes tend to be pretty long. For the development purposes, it would be great to have the caching possibilities also on these tools.

Thank you very much for considering this idea.

Regards,

Jan Laznicka

Hello,

It's nice to have this OpenAI Connector but it seems it must be the default OpenAI URL. In my company, we use OpenAI on an Azure instance and I'm unable to connect to it.

(by the way, I know pre-sales teams have developed lot of connectors for fireworks, mistral, etc.. it would be very cool to have it available).

Best regards,

Simon

Hello,

I think I have neer wrotten an easier idea : the tooltip for the run workflow button should indicate the keyboard shortcut (ctrl+R). So simple, so intuitive..



Best regards,

Simon

Add Unicode category to the cleansing tool

Sometimes, Control Containers produce error messages even if they are deactivated by feeding an empty table into their input connection.

(Note that this is a made up example of something which can happen if input tables might be from different sources and have different columns so that they need separated treatment.)

According to the product team, this is expected behaviour since a selection does not allow zero columns selected. This might be true (which I doubt a bit), but it is at least counter-intuitive. If this behaviour cannot be avoided in total, I have a proposal which would improve the user experience without changing the entire workflow validation logic.

(The support engineer understands the point and has raised a defect.)

Instead of writing messages inside Control Containers directly to the log output (on screen, in logfile) and to mark the workflow as erroneous, I propose to introduce a message (message, warning, error) stack for tools inside Control Containers:

1. When the configuration validation is executed:
1. Messages (messages, warnings, errors) produced outside of Control Containers are output to the screen log and to the log files (as today).
2. Messages (messages, warning, errors) produced inside of Control Containers are not yet output but stored in a message stack.
2. At the moment when it is decided whether a Control container is activated or deactivated:
1. If Control Container activated: Write the previously stored message stack for this Control Container to the screen and to the log output, and increase error and warning counts accordingly.
2. If Control Container deactivated: Delete the message stack for this Control Container (w/o reporting anything to the log and w/o increasing error and warning count).

This would result in a different sequence of messages than today (because everything inside activated Control Containers would be reported later than today). Since there’s no logical order of messages anyways, this would not matter. And it would avoid the apparently illogical case that deactivated Control Containers produce errors.

Currently when debug mode is entered in analytic apps and macros, the direct inputs to the app/macro when the error occurred are hardcoded into a workflow in debug mode, so that errors can be more easily detected.

However, inputs into analytic apps also create global variables which can be used in the more code-heavy aspects of Alteryx such as the Formula Tool. These are not updated in the same way which can cause workflows to break in debug mode - it would be really helpful if global variables could be updated in the same way as the inputs into tools are.

Would be nice to have a way to cache-uncache all inputs or a selected group of tools.  Caching and Uncaching workflows with many input tools or slow data-read tools gets to be a bit cumbersome.  Would be a nice QoL improvement :)

I looked around for something like this but didn't see a solution, so thought I'd recommend.  Please let me know if something like this exists already natively in designer desktop.

Hi there,

When you connect to a DB using a connection string or an alias - this shows up in the Workflow Dependancies in a way that is very useful to allow you to identify impacts if a DB is moved or migrated.

However - in 2023.1, if you use DCM then the database dependancies just show up as .\ which makes dependancy management much more difficult.

Please could you add the capability to view the DCM dependancies correctly in the dependancy window?

BTW - this workflow Dependancy Window would be a great place to build a simple process to move existing DB connections to a DCM connection!

CC: @wesley-siu @_PavelP 

Hi there,

When connecting to data sources using DCM - could we please add the ability to make JDBC connections?

see:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Add-the-ability-to-connect-to-data-s...

https://community.alteryx.com/t5/Engine-Works/JDBC-Connections-in-Alteryx/ba-p/968782

As mentioned in these threads - JDBC is very common in large enterprises - and in many cases is better supported by the technology teams / developer community and so is much easier to make a connection.    Added to this - there are many databases (e.g. DB2) where JDBC connections are just much easier 

Please could you add JDBC connections to the DCM tooling?

Thank you

Sean

cc: @wesley-siu @_PavelP 

Alteryx is not able to read generated Excel sheets which have the prefix "x:" within it's XML tags.  Often this occurs when an xlsx file is created from a bot or rpa process.  Example file attached.

Hi there,

When creating a database connection - Alteryx's default behaviour is to create an ODBC DSN-linked connection.

However DSN-linked connections do not work on a large server env - because this would require administrators to create these DSNs on every worker node and on every disaster recovery node, and update them all every time a canvas changes.

they are also not fully safe becuase part of the configuration of your canvas is held in the DSN - and so you cannot just rely on the code that's under version control.

So:

Could we add a feature to Alteryx Designer that allows a user to expand a DSN into a fully-declared conneciton string?

In other words - if the connection string is listed as 

- odbc:DSN=DSNSnowFlakeTest;UID=Username;PWD=__EncPwd1__|||NEWTESTDB.PUBLIC.MYTESTTABLE

Then offer the user the ability to expand this out by interrogating the ODBC Connection manager to instead have the fully described connection string like this:
odbc:DRIVER={SnowflakeDSIIDriver};UID=Username;pwd=__EncPwd1__;authenticator=Snowflake;WAREHOUSE=compute_wh;SERVER=xnb27844.us-east-1.snowflakecomputing.com;SCHEMA=PUBLIC;DATABASE=NewTestDB;Staging=local;Method=user

NOTE: This is exactly what users need to do manually today anyway to get to a DSN-less conneciton string - they have to craete a file DSN to figure out all the attributes (by opening it up in Notepad) and then paste these into the connection string manually.

Thanks all 

Sean

Hello!
Currently when you share a workflow that contains a Directory tool, it will instantly fail if you do not setup the directory tool to point at a similar folder structure. This is expected, but can make it painful to share workflows between multiple users, especially when a shared network drive and dynamic paths cannot be used. 

What I propose as an addition to Alteryx Designer would be the option to 'convert to yxdb' / 'cache and replace' any tools that are at the start of a workflow, similar to the cache and run workflow option:

What i expect this to do is to containerise the tools previously used, and create a new file within a temporary location, and replace the containerised tool connection with a new data input to that file:

Why this would be fantastic, is that it would allow me to now export the workflow, including the file that has been created:

and I could then share that with a colleague.

Kind Regards,

Owen

Hello All,

I am not sure whether my idea makes sense or not. 

In today's advanced analytics world, we used RPA for various automation, process simplification, etc. There are CO-BOTs that are designed to run the Alteryx flow as well. Through RPA we are able to log in to the system and tools like Cognos, Oracle, TM1, and so on.

So, I am thinking, if Alteryx developed RPA as a tool in the Alteryx Designer like other tools such as Join, Transform, ML, Computer Vision, Interface, etc. 

I believe the implementation of RPA in Alteryx will prove an Asset, and make Alteryx.com more powerful.

Thanks,

Mayank