Alteryx Designer Desktop Ideas

It would be nice to have the option of reassigning the Tool ID's based on each tool's process order within the workflow.

It is great to see the ability to stage data for bulk loading into Databricks in s3 and ADLS.  Previously this only appeared to allow staging in Databricks DBFS. 

However the current connector included in Designer 2022.1 has a key gap in functionality with ADLS Gen 2 

The only authentication method provided to the ADLS storage is though a shared key. 

Shared keys provide access that is

1. Too broad and allows access to the entire storage
2. Limited or no auditability and traceability to who is using it 

We do not provide users the shared key for the ADLS storage, thus our users cannot take advantage of this new feature. 

The preferred method of authentication to ADLS would be

1. RBAC - Role Based Access Control
2. ACL - Access Control lists

Either of these options can be provided though a service principal with a tenant id, client id and client secret as inputs to the bulk load tool

This request would specifically be to allow the ACL authentication. ACL would help empower our our self service data analysts and data scientists who could have access to a specific container. 

For example

storageAccount/Container/directory

The ACL access in this tool would allow the Alteryx tool to follow the same access patterns where fine grained access was provided at the directory level and not at the storage account or container level.  This would provide self service analysts and data scientists to use Alteryx as they need within their directory without providing higher level access.  

Access control model for Azure Data Lake Storage Gen2 | Microsoft Docs

When you right click on a Macro tool (e.g. Google Analytics) within a workflow, you can choose the version of the tool to use. However, it does not indicate which version of the tool is already in use. 

Why is this an issue for me?

I have a workflow with 15 instances of the Google Analytics tool.  (I needed to use the API for each month fo GA data and then use a join. I built it this way due to the restriction on the number of records.)

So when I update the Google Analytics tool I have to do it 15 times. I'd like to be sure the update is needed before I start. 

Alteryx Support confirm that there is no way to tell which version of the macro is in use. 

As a change to Designer UI in 2021.2, when in the filter box, I used to be able to use my mouse to click a little X in the corner to clear the filter or sort that had been implemented and it would immediately clear the filter.  It's not working as of 2021.2.  Now, I must navigate to the last cascade to get to the word Clear and click on it to clear the filter. 

This feels like another very tiny move in the wrong direction. These small UI changes cause 2 or 3 additional steps and slow the diagnostic/navigation process in moving around the Results Grid in the Browse Tool or at any point in the flow where the Results Grid is used.

Can the X in the top level of the Filter/Sort box in the Results Grid be restored in 2021.2?

Related to submission:

Small fix for the UI in the Results Grid (or Browse Tool)

Small Keyboard fix for the browse tool's filter

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. 

In order to improve processing of HTML data (to use HTML data as a data-source) it would be valuable to convert HTML data to XML. 

There's a few transformations that would be needed:

- special characters like &

- dealing with HTML's imprecision - for example - "img src" tags do not require an explicit close marker.

Example: <img src="/html/assets/alteryx_company_logo.svg?F0F845F3873A74E16B876DC33606AFEA" class="ryx-company-logo"> rather than

<img src="/html/assets/alteryx_company_logo.svg?F0F845F3873A74E16B876DC33606AFEA" class="ryx-company-logo" />

- dealing with multiple class tags on a single div

- footer tags which are balanced off against a </div> tag.

This would enable more efficient processing of HTML data using modern XML capabilities

Hope this is fairly self-explanatory.

I'd like to be able to create presets for Summarize tool.  Instead of having Group By, Sum, Count, Count Non Null, etc on top of the libraries of functions, put them into their own category.  Users could then create a Favorites and the functions that they use the most would be stored in that section (editable by user).

It would be good to replicate some of the key workflow configuration settings as shortcut icons in the main shortcut toolbar.

For instance, I often use 'Disable all tools that write output' and need to toggle it on/off quickly when I'm testing a workflow. It takes too many clicks to deselect a tool, open workflow configuration, open the Runtime tab and select the checkbox. Many end-users I work with also don't even know the option is there because it is so well-hidden.

It would be much simpler and easier If I could toggle it straight from the shortcut bar. Having a keyboard shortcut to do it, like I do with ctrl-R (to run) would be even better.

Having shortcuts would also be good for:

• Disable all browse tools
• Show/Hide connection progress
• Open the Events window

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! 

Currently on the input tool I can only specify if the first row contains data.  It would be great if I could simply specify which row the data starts on, ie. row 4 or row 500, and then specify which row, if at all, contains the headers.

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.

Currently the Filter tool not supporting the multiple variable value check like a = b = c. It would be nice if the filer tool supports multi-variable check in one go.

I've been using the Intelligence Suite to automate building models using assisted modelling, It works great. However If I then output the model to the Python tool I ran into a few issues. The Intelligence Suite relies on the EvalML library so I wanted to use the python tool to use the model created with some of EvalML's other features such as prediction explanations.

What I found was that the intelligence suite for 2021.3.5 uses EvalML version '0.13.2' which is from 2 years ago meaning a lot of the extra features are not available.

It would be great with each new Alteryx intelligence suit the EvalML package also updated. 

I learnt Alteryx for the first time nearly 5 years ago, and I guess I've been spoilt with implicit sorts after tools like joins, where if I want to find the top 10 after joining two datasets, I know that data coming out of the join will be sorted. However with how AMP works this implicit sort cannot be relied upon. The solution to this at the moment is to turn on compatibility mode, however...

1) It's a hidden option in the runtime settings, and it can't be turned on default as it's set only at the workflow level

2) I imagine that compatibility mode runs a bit slower, but I don't need implicit sort after every join, cross-tab etc.

So could the effected tools (Engine Compatibility Mode | Alteryx Help) have a tick box within the tool to allow the user to decide at the tool level instead of the canvas level what behaviour they want, and maybe change the name from compatibility mode to "sort my data"?

This is purely aesthetic but it would be great to have a button to auto format tools positions on the canvas. The idea would be similar to a feature many IDE's come with to auto format code so that the indentation is corrected and duplicate return characters are removed.

We currently have the Align and Distribute capabilities which is great. This could be expanded to the entire workflow so that the canvas could look at which tools connect to which and structure their positioning around that. I think it would be a great clean up feature after finishing a workflow. 

Alternative data sources are key for enriching data. one source is social media.I believe Alteryx lacks in social media analytics.

• I would like to propose a YouTube connector...
  
• Crawl comments and video definitions (useful for text analytics)
  
• Impression and likes/dislikes... (time-series data)
  

If you are into #media, #advertising, #marketing analytics, #influencer analytics please support the idea by seconding...

There is an API called YouTube DATA API

https://developers.google.com/youtube/v3/getting-started

Passing data to the next app running in a chain from the gallery varies from challenging to impossible. An impossible situation I've found is when the same user needs to run multiple instances of the app simultaneously. Very difficult is just allowing two different users to run simultaneously without risk of passed data mixing between the two.

This idea would add the capability to pass values from one app in the chain into user variables in the next app in the chain.

I recently had an error in a module because an expected variable was not present coming into a formula tool.  My variable, "MONDAY" was not present and the formula MONDAY/3 failed.  The workaround was to union all days into the incoming data and things worked fine.  I would have liked to have an Excel formula like this instead:

IF ISERROR([Monday]/3) THEN 0 ELSE [Monday]/3 ENDIF

Thanks