Alteryx Designer Desktop Ideas

When a macro that is not "installed" is inserted to a workflow (from a folder), its dependency can also be modified (including the macro inputs, if there are any) from the Workflow Dependencies settings.

I would like to suggest that the macro tools and the relevant files have separate buttons for dependency configurations.

One use case for this would be when a user saves a workflow in a specific location after configuring the paths as All Relative and moving the workflow to an entirely different folder afterwards, making it difficult to find the original location of the macro used in the workflow, also introducing the chance of breaking the workflow when opened and saved with the undefined (question mark sign) macro tool if the underlying workflow XML is not examined by a text editor.

There are currently many encoding options (see also: Input Tool Has Limited Varieties of Code Pages) that are available for use with Alteryx Designer (https://help.alteryx.com/2018.2/CodePages.htm), however only a certain number of them can be directly accessed from the interface. Providing the user an option to enable all possible encoding options (from User Settings) for the applicable tools could eliminate the need for building an analytic app just to pass the output encoding parameter to i.e. the Input/Output/Run Command tools.

One case this could be useful is when there are file/folder names with non-English characters and a Run Command tool is used to execute an operation regarding moving something from/to the folder, where the only option is to use an OEM encoding to be able to correctly pass the file/folder name information, otherwise the characters are not read correctly by CMD.

Hello all,

As of now, you have two very distinct kinds of connection :

-in memory alias

-in database alias

It happens than every single time I use a in-database alias I have to create the same for in memory since some operations cannot be realized in in-database (such as pre-sql or interface tools)

What does that mean for us :

-more complex settings operations/training/tests

-unefficient worflows that have to deal with two kinds of alias.

What I propose :
-a single "connection alias", that can be used either for in-db either for in-memory,

-one place to configure

-the in-db or in-memory being dependant on the tools you use

Best regards,

Simon

Not sure I'd call this a user setting, but I couldn't figure out the right heading this belongs to. 

When opening files, there are often times a couple of files at that aren't run on any kind of schedule or set time frame but you come back to when you need to run them.  

There should be a way to set "FAVORITES" for a handful of files that you find yourself referring to on a repeated basis, but too far back to be on the 'recents' list because you open too many other files. 

1.  I would like the tab color/contrast of the active tab to be more prominent / discernible.  It does not really stand out. 

2.  I would like the ability to set default colors for different open workflow types -- standard workflow, macro, analytical app, so I can use color to quickly distinguish between tab dependencies or simply what is what.

3.  I would like the ability to change the color of any tab at any time (similar to Tableau Desktop, but with greater color choice).

Allow for setting universal DATA SIZE configuration.  ESPECIALLY on V_WString!!   If you want all your V_WString to be 5096, you can set it. If you want all your fixed decimal values to be 12.4 you can set that.  You can set your own values for a workflow or under advanced setting perhaps you set up your own default values that will be used across all work flows. 

At MINIMUM, change the 1,073,741,823 on V_WString to something semi reasonable. That size won't even fit in a Snowflake table. 

Currently, when a new version of Alteryx Designer is released, you get a banner at the top of your Designer to upgrade. You can manually select to disable this for up to 30 days. 

However, this is really causing issues with Server compatibility. Users get notified to upgrade, thinking it's from the Server owners and upgrade then is no longer compatible with Server. Alternatively, it causes differences between users, etc. 

It would be ideal that it would be disabled in general but also controlled when software is pushed to machines through IT policies.

User settings currently only allow for setting a default fill color for containers. Would like to be able to set default text and border colors as well. Thanks!

I could not find any helpful document to connect to Azure Databricks to read data directly as an input. I was able to configure it and sharing it for others with the screenshots 

Hello all,

As of today, you must set which database (e.g. : Snowflake, Vertica...) you connect to in your in db connection alias. This is fine but I think we should be able to also define the version, the release of the database. There are a lot of new features in database that Alteryx could use, improving User Experience, performance and security. (e.g. : in Hive 3.0, there is a catalog that could be used in Visual Query Builder instead of querying slowly each schema)

I think of a menu with the following choices :
-default (legacy) and precision of the Alteryx default version for the db
-autodetect (with a query launched every time you run the workflow when it's possible). if upper than last supported version, warning message and run with the last supported version settings.
-manual setting a release (to avoid to launch the version query every time). The choices would be every supported alteryx version.

Best regards,

Simon

Issue

Users are not able to change keyboard shortcuts. Because some Windows keys take precedent, the Alteryx keyboard shortcut will not work. 

For example, I would like speed up performance by selecting Disable Auto Configure in User Settings, and rely on using manual canvas refreshes (F5). However, Windows is reserving F5 for the Snippet tool. As such, F5 does not work for me. And in this case, there is no button or drop down for manual refreshes. Corporate IT security prevents me from remapping my keys. 

Proposal

In user settings, allow a user to modify the full list of keyboard shortcuts.

I would like to Alteyx making a New Warning（Int type）

If a decimal point occurs during division of Int type data, the digits are truncated.

example
1/3 = 0.333333, but
If it is of type Int, it will be displayed as 0.

I know that the Int type is defined as an integer, but
I would like to Alteryx making a warning if the operation does not result in an integer.

Then we should be able to detect errors.

Thanks！

Hey Designer Gurus + @NicoleJ ,

Here's a picture of my canvas (running):

I'd like to be able to see COUNTS and PERCENT completion as the workflow is running.  In my case, the numbers are BIG and  they are prioritized as BACK compared with the lines.  In the case of % complete, they  obfuscate (fancy term for block) the progress of the tool.

Currently, if I want to watch the water boil, paint dry or the workflow crawl/walk/run I must change the workflow before saving it to maximize the distance between the tools.  I'd like to be able to see both the COUNTS and % complete without the added effort.  My idea is to have someone at Alteryx figure out an enhancement to this without engaging the likes of @Hollingsworth who'll devise some evil keyboard shortcut.

Cheers,

Mark

Hi Team,

Hope you are well. I am currently tasked with downloading the contracts from SAP for my analysis.

Is it possible to develop an app or automation which can go to SAP asks for user/Pwd and download the contracts/PDFs to a specific folder?

Please let me know your thoughts,

Thanks,

Sri

I am working with complex workflows which use multiple files as input, located on network drives. Input tools are Input Data, Directory, Wildcard Input, Wildcard XLSX Input (from CReW macros).

Regularly, I experience very slow Designer when working on the workflows (Window freezes for quite some time), especially when working from home. Switching off Auto Configure did not really help because I the column list sometimes does not converge even after pressing F5 multiple times, and when actively working on workflows, I have to press F5 all the time...

To improve this issue, I would like to propose a "Disable Auto Configure of File Inputs" which would not watch the loaded files but still would update the configurations downstream. This could include to not check automatically whether Macro files on network drives have changed. F5 could be used to update all configurations manually.

Salesforce Connector:

I just want to see what credentials I have used. I do not want to change them. A link to "view the data" and not only "Change Credentials"  would be helpful.

Also, when replacing connectors (due to a version change), it makes sense not to reassign the objects and fields and keep the old settings.

Create social and holiday themes for icons and set the canvas to an appropriate color.  Here's a world mental health day example:

If you need help, ask me how I did it.

Cheers,

Mark

P.S.  I realize that 2023 is next year.  Please don't wait that long :)

Most databases treat null as "unknown" and as a result, null fails all comparisons in SQL.    For example, null does not match to null in a join, null will fail any > or < tests etc.    This is an ANSI and ISO standard behaviour.

Alteryx treats null differently - if you have 2 data sets going into a join, then a row with value null will match to a row with value null.

We've seen this creating confusion with our users who are becoming more fluent with SQL and who are using inDB tools - where the query layer treats null differently than the Alteryx layer.

Could we add a setting flag to Alteryx so that users can turn on ISO / ANSI standard processing of Null so that data works the same at all levels of the query stack?

Many thanks

Sean

Working with larger and larger workflows becomes difficult to navigate. I have been using the Right Click on Blank Canvas>Zoom to container recently, but the order in which the containers show doesn't seem to be intuitive. (Not by tool ID, rather the order they are in the XML.)

This has been asked in the past but I couldn't find an idea post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-I-set-the-order-in-which-container...

It would be useful to have the ability to change the list to be in alphabetical or tool ID order please.