Alteryx Designer Desktop Ideas

The current Azure Data Lake tool appears to lack the ability to connect if fine grained access is enabled within ADLS using Access Control Lists (ACL)

It does work when Role Based Access Control (RBAC) is used by ACL provides more fine grained control to the enviroment

For example using any of the current auth types: End-User Basic, End-User (advanced) or Service-to-Service if the user has RBAC to ADLS the connector would work

In that scenario though the user would be granted to an entire container which isn't ideal

• azureStorageAccount/Container/Directory
  • Example: azureStorageAccount/Bronze/selfService1 or azureStorageAccount/Bronze/selfService2
  • In RBAC the user is granted to the container level and everything below so you cannot set different permissions on selfService 1 or selfService2 which may have different use cases

The ideal authentication would be to the directory level to best control and enable self service data analytic teams to use Alteryx

• In this access pattern the user would only be granted to the directory level (e.g. selfService1 or selfService2 from above)

The existing tool appears to be limited where if don't have access at the container level but only at the directory level then the tool cannot complete the authentication request.  This would require the input for the tool to be able to select a container (aka file system name) from the drop down that included the container+ the directory

• Screenshot example A below shows how the file system name would need to be input
• Screenshot example B below shows what happens if you have ACL access to ADLS at the directory level and not at the container level

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

Example A

Example B

i using dynamic input tool a lot. when reading list of sheet. i will simply put a.xlsx|||Sheet1 (as random file name)

However, when it run in the workflow. it will verify the existing file (A.xslx) instead. it will stop due to error (old file not found)

suggestion:

1. verifying new path (file) and not old path (file) , or

2. option to ignore error

This is not exactly a new feature but I didn't know where else to send it.
I just received an email from Alteryx and I noticed that the footer is an image and not dynamic.

And there you see that the year is still 2021. A good idea would be to insert a code that would grab the year automatically from the actual date.

Prezados, boa tarde. Espero que estejam todos bem.

A sugestão acredito eu pode ser aplicada tanto na ferramenta de entrada de dados, quanto na ferramenta de texto para colunas.

Existem colunas com campos de texto aberto e que são cadastrados por áreas internas aqui da empresa. Já tentamos alinhar para que esses caracteres, que muitas das vezes são usadas como delimitadores, não sejam usados nesses campos. Porém achei melhor buscar uma solução nesse sentido, para evitar qualquer erro nesse sentido.

A proposta é ser possível isolar essa coluna que existem esses caracteres especiais, para que não sejam interpretadas como delimitadores pelo alteryx, fazendo pular colunas e desalinhando o relatório todo.

Obrigado e abraços

Thiago Tanaka

Prezados boa tarde. Espero que estejam bem.

Minha ideia/sugestão vem para aprimoramento da ferramenta "Texto para Colunas"  (Parse), onde podemos delimitar colunas com caracteres de delimitação.

Atualmente, a delimitação não ocorre pro cabeçalho, tendo que ser necessário outros meios para considerar o cabeçalho como uma linha comum, para depois torná-lo como cabelho, ou tratar somente o cabeçalho de forma separada.

Seria interessante que a propria ferramenta de texto para coluna já desse a opção de delimitar a coluna de cabeçalho da mesma forma.

Obrigado e abraços

Thiago Tanaka

Prezados espero que estejam bem.

Gostaria de sugerir um aprimoramento para os erros comuns de conhecimento do Alteryx.

Quando rodamos o fluxo de trabalho e ao final algum erro é sinalizado no histórico, normalmente, não é possível entender ao certo o que precisa ser corrigido para sanar o problema.

A susgestão está em transformar o erro que é sinalizado no histórico, em link para que a pessoa clique no erro e seja direcionado para alguma documentação dentro do forum ou documentação, e que facilite a solução do problema para o usuário. Algo parecido com o que ocorre com os exemplos que existem da possibilidade de uso das ferramentas.

Obrigado e abraços

Thiago Tanaka

The Basic Data Profile tool cannot handle files larger than about 40 MB and 33 fields.  When I add the 34th field, and the file size stays at 40 MB (Browse tool rounding), it breaks.

I'm trying to get the count of non-nulls for the  "Empl Current" field.  Adding the 34th field drops the non-null count down from the correct 25,894 to 26, and if I add more fields, the count of non-nulls drops to zero.

The Basic Data Profile tool is configured with a 10 million limit on exact count and 100,000 limit on unique values.

The whole point of the BDP tool is to get one's hands around large data files that are too big to manually inspect, so this tiny limit is really a problem.

I often have to cache my workflow at certain points to do further development/analysis since the run time is so long. I can't express how frustrating it is when i need to edit a formula tool that's like 2 tools behind the cache but the whole entire cache is lost when i have to edit it. why can't the cache be kept up until the tool that was edited??

Performance profiles work at the tool level. When I want to evaluate the performance of a group of tools, I have to click on them one at a time, log the performance, and calculate manually. I want to be able to click on a container full of tools or lasso some myself and view the granular and subtotaled performance profile.

ARIMA, ETS, TS Forecast, TS Covariate Forecast are difficult to differentiate, more distinct icons would improve differentiation on the canvas. 

The tool currently does not write a complete XLSX spec file. Excel files created via Alteryx do not support Windows File Explorer search content capabilities. The sharedStrings.xml section of the XLSX file is empty or omitted. This section includes all unique strings within the file and thereby makes search for content fast.

This upgrade seems possible by non-Microsoft 3rd parties as other tools can save Excel XLSX files in the proper format (e.g. Tableau Prep, Google Sheets).

Love the new Sharepoint Files Input tool. Significant improvement over previous options! 

A suggestion that could improve the impact of the tool:

File Download Only

Current state: The tool performs two actions simultaneously: 1) downloading the file (csv/xlsx/yxdb) AND 2) reads the file into the data stream. When processing the supported file types, this is very convenient! However, the beauty of Alteryx is being able to read in raw data from almost any file type (pdf/zip/doc/xml/txt/json/etc) and process the data myself. Being limited to only officially sanctioned file types greatly diminishes the impact of the tool. 

Suggestion: Allow the user to 1) specify a filepath, 2) download the selected file(s) to that destination, and 3) optionally use a dynamic input tool to process the file. 

Don't know if someone else already flagged this... however if you click on a tool link in the result window, while the workflow is running, the window doesn't go back to the "main view" until the workflow stops.

It's fine if the workflow takes a few minutes to run, but if you are trying to debug a heavy workflow and you click by mistake on a tool link halfway through... it's a bit annoying that you can't see the output messages until the end

i would like to have a tool to verify whether the columns are exist or not.

if all exist then pass

else return error and indicate the filename and column missing in error message.

it happen when we using server. the user come back with the missing variable.

but do not know what file are missing that columns.

so if possible, we may have error message like, column "Status" not exist in "Data.xlsx|||Sheet1".

Suggestion Config:  similar to rename tool, but express is error message

So this is a minor thing, but could we get an option to name log files output to something aside from 'Alteryx_Log_TUVXXYZ_1'? It would be really useful to have the name of the workflow appended onto the log instead of having to sift through them manually or clear the destination folder every time I want to check one specific workflow. I know there's probably ways around this, but having something in the interface would be an elegant solution if possible.

Thanks! Love y'alls software to death!

Allow the Macro input tool to answer a question for other interface tools. Example if I want to open and run a container I cannot automate this. It can only be done with a human interface tool. Interface tools are not able to be updated dynamically. This issue hinders full automation with Alteryx server. Yes there are workarounds which lead to a big Ol Mess and creating errors leads to missed true errors. This option would remove many issues with automation.

There have been requests for "parts of this request" - but not all in one task.  Would like to have a "Deploy", "Cleanse", "Align", or "Scrub" tool. 

When added to a workflow it would remove all fields that were developer remnants from changing source objects, joins, etc.  Any field that is no longer is the source objects feeding it - would be deleted.

-Ken

Please add undo or the option delete an added field when adding a file that has fixed width columns. If I select one position wrong, I have to start from scratch. This is not ideal. 

Either as part of the Alteryx Easter Eggs (found in  Help>About) or as part of the canvas,  we should have an ability to enter the Konami code and see magic on the screen.  The workflow moves, Space bends, something creative.

Cheers,

Mark