Alteryx Designer Desktop Ideas

Hello all,

MonetDB is a very light, fast, open-source database available here :
https://www.monetdb.org/

Really enjoy it, works pretty well with Tableau and it's a good introduction to column-store concepts and analytics with SQL.

It has also gained a lot of popularity these last years :
https://db-engines.com/en/ranking_trend/system/MonetDB

Sadly, Alteryx does not support it yet.

Best regards

Hello,

I would like to suggest the ability to manage our virtual environment for Python modules within Alteryx. Some current workflows I am building would be far easier and more secure if I had access to the virtual environment that the Python code would run in.

Uses for modifying the virtual environment:

     1) Setting environment variables in order to hide API Keys/DB credentials/etc.

     2) Installing private GitHub repository packages into the environment.

     3) Creating repeatable and easily maintainable ways to manage dependencies. 

It would be important that these virtual environments have a way to persist onto Alteryx Gallery, so that workflows behave identically on local machines as they would on the server. This could potentially be done though a requirements.txt file or some other environment initializer, but I'll leave the implementation to the experts. My preference would be for each workflow to contain their own virtual environment (as is best practice when developing Python scripts). 

Thank you,

Syntax Highlighting Idea:

Similar to the Formula Tool, allow the Multi-Field Formula tool (and other similar tools) to have Syntax Highlighting to allow user to easily determine if the formula being input doesn't have any errors.

Variable Autofill Idea:

Similar to the Formula Tool and how it provide a list of columns as you begin to type them, allow the Multi-Field Formula tool (and other similar tools) to have the ability to autofill variables such as [_CurrentField_] or [_CurentFiledName_] as you begin to type them.

Idea:

Similar to the Formula Tool how it shows an example based on the first record. Could the Filter Tool have a example based on the first record showing how the formula in the filter would handle that record? It would either show in an example field for the true sample or false sample based on the criteria. I feel this would be very useful for more complex formulas such as AND/OR.

Ex.

Filter Formula: [Count] <= 1

True Sample: [Blank]

False Sample: 4 (Value of first record which was filtered from [Count])

When using the unknown field in a select, you can either select or deselect the fields which will appear afterwards.

I would love to have an option or different to specify elements for fields to appear for instance having :

• *unknown text where you could set the metadata type (for instance vwstring) and maximal length
• *unknown numeric where you could set the type, double or fixed decimal

and for dates too

it would set a default behaviour for incoming text fields or numeric fields allowing for more precise deselction too.

I was working on the file and there are multiple sheets need to be pulled from one excel file. I was not sure how we can give one source of information and pull multiple sheet from one source as per the requirement. So wanted to submit this idea to create a toll which can pull any sheet(s) from one input tool as per requirement.

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!

In the 'Select' tool, you have the ability to output the select configuration.  At this time that configuration file doesn't include the information (which you do in the check box of the select tool) on if it is a field that is output. Not a big deal if there are only a couple fields, but quickly becomes an inconvenience if there are a lot of fields and you have to compare going down the list to make sure you're accurately identifying which fields from the original select tool, are actually output.  That info should be part of the .yxft file that's output for the config file. 

Since we can use Snowflake udfs in Alteryx, when do you think Snowflake stored procedures will be available.

Actually not sure if to flag it as feature request or bug.

As per Conditional Functions | Alteryx Help the Switch function only works with "=" cases.

Trouble is, a typical case function might be a variant of different if [x]<[y] then "a" in a similar way to the "manual" setting of the tile tool.

If used in that way, the switch function will happily run but return wrong results, as it happened to me in a recent customer training session.

IMHO either the switch function should support everything an IF does or throw an error when it doesn't and the documentation should be updated.

What do you think?

When you import a csv file,  I sometimes use a "TAB" as delimiter. In section 5 Delimiters I want that as an option.

I have learned that it is possible to wright "\t" but a normal choice would bed nice.

We have the brows icon witch connect at on output at a time. But to be more efficient I would like a browser tool witch connect to 2 or 3 outputs at one icon. Connect to True false at the filter or L J R at the join record.

I can't even count how often I looked at an Excel, CSV or even YXDB file, where I KNEW that it was generated by Alteryx, but I couldn't remember the workflow. Currently, I have to simply go through all workflows I ever build and see if I can find it.

Theoretically, I could use a text-search across all workflows and see if I can find the output names - problem here: Most of my output filenames are generated dynamically on the run.

It would be amazing if Alteryx could simply write the Workflow name (maybe even path) into the metadata of a file.

(Screenshot from Google, as my os is set to German) 

How about, we write "This file was created with by "Create Controlling Reports.yxmd on 2023-02-06 with Alteryx Designer 2021.4.298434" in the field 'Comments'?

This would make it extremely easy to find what workflow the file generated. I think it would be an option to talk about "filepath" instead of filename, but the filepath could include the local machine name, which might include GDPR information.

@Community: Is there any additional information that you'd like to see in the metadata?

Best

Alex

Hi All,

I always use a colour standard within my workflows.

I suggest two small features:
(a) RGB Colour Picker from the screen
(b) Copy and Paste function -> so I can paste the whole path (R=203, G=222, B=245) in the specific field.

Thanks! 

Hi:

I believe the ability for Alteryx Designer to read from/write to parquet files will enhance its capability to serve the DSML community better. Potentially someone can design this connector as part of the App community but given the importance parquet file formats have gained as a columnar storage format (as opposed to something like Avro - which is a row storage format), Alteryx supplying native connectors to such files would be awesome. 

Thank you,

Shiva Badruswamy

Principal Architect - DSML

Stratascale

In the current expression editor, XOR(exclusive logical sum) is not supported as an operator while AND & OR already exist, so I'd like to request to add XOR to an operator in expression editor.

Without XOR operator, when we want to use XOR conditional expression, it is like below expression; it looks a bit complicated so it's hard to tell condition is XOR at once.

As a workaround, I defined custom function XOR by myself, but this should not be permanent solution since when sharing workflow to others it doesn't make sense unless they also have custom function XML file in their computers as well.

I believe addition of XOR would help to have much readable code for tools with expression editor(e.g. formula, filter, etc).

Hello all,

As of today, you can populate the Drop Down tool in the interface category with a query launched from a in-memory connection. I would really appreciate the ability to use instead an in-db connection.

Why ?
It means managing two connections instead of one, and finding ways to manage it on server for both of them, etc etc.. Simplicity is key.

Best regards,

Simon

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