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.

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. 

Can you add max and min options to the filter tool for date fields. Currently I have to use the sum function and join the max date back to the rest of the data and then filter. seems like an unnecessary amount of steps.

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

Hi

The native email tool is great up to a certain volume, but at high volume it makes more sense to use sendgrid to take advantage of its features like deliverability etc

Would be great if there was a ready-made connector tool for SendGrid

Thanks

We waste a lot of time to search a field to join it in join or to deselect it select or to summarize in summarize. This mainly happens when we have long list of fields.

As search bar to find the field on top of any of these tools will be really helpful. 

Specially, for join tool if we can type the field name while joining would really help. 

Thank you,

Sanju

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.

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).

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

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

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

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

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

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. 

Some say to mato and some say to_mato, but how about:  to/mato?

While working with my new friend, @Cedric we ran across a field in his data that contained a '/' character.  We were building a macro where we updated the value of the field [AB/CD] with another field selected from the incoming data.  Our error message was something akin to:  Field AB was not found.

We worked around the issue, but what remained was the fact that certain characters are permitted in field names within some aspects of Alteryx and not in others.  I don't know if you're aware of this limitation.  

Cheers,

Mark

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. 

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"?