Alteryx Designer Desktop Ideas

Hi all,

Currently, only the Sharepoint list tool (deprecated) is working with DCM, it would be amazing to add the Sharepoint files input/output to also work with DCM.

Thank you,

Fernando Vizcaino

There is an extensive need from customers to be able to create emails but not send them (right away at least).

I'm in the banking sector and I have been seeing many banks using Alteryx and Alteryx server in their routines. Also, when it comes to sending automatic e-mails in this sector, its very risky. We need a "four eyes check" when dealing with clients information. Currently there is no workaround that could be applied to e-mail tool when used in Alteryx server as well.

My idea is to simply create a button "Save in draft" in e-mail tool to create an .eml format as output. This .eml can be read by outlook and thus, it creates a draft.

This also should be taken into account when dealing with drafts in alteryx server, so that any user can run the workflow and get the desired draft.

Thanks

For in-DB use, please provide a Data Cleansing Tool.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/BigQuery-Input-Error/td-p/440641

The BigQuery Input Tool utilizes the TableData.List JSON API method to pull data from Google Big Query. Per Google here:

• You cannot use the TableDataList JSON API method to retrieve data from a view. For more information, see Tabledata: list.

This is not a current supported functionality of the tool. You can post this on our product ideas page to see if it can be implemented in future product. For now, I would recommend pulling the data from the original table itself in BigQuery. 

I need to be able query tables and views.  Not sure I know how to use tableDataList JSON API.

Hello Alteryx folks!

I think it would be awesome to be able to dynamically rename headers right in the Table tool so that the headers can stay in their intended position. For instance, if you use a Dynamic Rename tool, the Table tool will put the new "unknown" column at the end of the output. We have the ability to rename and add formulas to the fields, but we cannot do the same with the headers.

Thanks!

When loading multiple sheets from and Excel with either the Input Data tool or the Dynamic Input Tool, I usually want a field to identify which Sheet the data came from. Currently I have to import the Full Path and then remove everything except the SheetName.

It would be great if there was an option to output she SheetName as a field.

When opening an Alteryx workflow that has been saved in a newer version, a warning message is shown, but you are still able to open the workflow, provided that it doesn't contain tools that don't exist in your current Alteryx version.

This does not work for packaged workflows that contain macros, for instance. You have to manually edit the xml of the extracted package file.

It would be great if we could have the same ability with packaged workflows that exists for normal workflows, i.e. the ability to extract and execute them with a warning.

Hello all,

I try to use Alteryx and MonetDB, a very cool column store database in Open Source.
 
When I use the Visual Query Builder, I get this :

The fields names are totally absent.



The reason is Alteryx does not use the standard ODBC SQLColums() function at all but send some query (here "select * from demo.exemplecomparetable.fruit1 a where 0=1" ) to get a sample of data. In the same time, Monetdb sends the error "SELECT: only a schema and table name expected" (not shown to user, totally silent)

I think this should be implemented like that :
1/use of SQLColums() function which is a standard for ODBC and should work most of the time
2/if SQLColums() does not work, send the current queries.

It's widely discussed here with the MonetDB team.

https://github.com/MonetDB/MonetDB/issues/7313

Best regards,

Simon

A workflow of one of our Alteryx business users ended with a timeout, and only part of the data was written in the output. This leads to wrong data for the reports. 

The goal should be: 

It is not allowed that output data is only partially written the output. Either the output is written completely or no output will be created. Would it be possible to achieve this?

This behavior ( Either the output is written completely or no output will be created) is already available in Qlikview and expects the same to be available in Alteryx as well. 

Database systems, and seemingly Quickview, have the ability to create "transactions" that will either write all data or no data.  They can do this because the database has full control over the database.  

Alteryx Designer is writing to different file types and doesn't have this ability because it's not in total charge of the files or databases.  For example, if it's updating 1 million records in a database, it's not saving the previous values of the field being updated, so it would have to way to undo those updates if the workflow experienced an error later in its processing.

Alteryx product team should consider this and implement it in the future to solve many problems. 

When scheduled or manual Alteryx workflows try to overwrite or append the Tableau hyper extract file, it fails(File is locked by another process). This is because a Tableau workbook is using the hyper extract file. We know the behavior is expected as the file is opened by another user/process so Alteryx won't be able to modify it until the file is closed. Alteryx product team should consider this and implement it in the future to solve many problems. 

The look of the canvas is important. Being able to toggle between viewing classic icons (as seen throughout this video: https://www.youtube.com/watch?v=DJwgYYP_xlA), to the extent available, and current icons would provide users with more variety. As a secondary benefit (when toggled to show the classic icons), users would be able to differentiate between the tools that are not classic (i.e., the newer tools that don't have an older design) and the classic tools.

Thank you very much.

Hello all,

HDFS (Hadoop Distributed File System) connection is widely used to load data efficiently on Hadoop, for Hive, Spark or Impala. However, it's not compatible with the new DCM.


Best regards,

Simon

Hello all,

OLEDB is usually way faster than ODBC so that the way to connect we promote. However, the new DCM only works for ODBC connection, which is quite strange.

Best regards,

Simon

Hello all,

I really love the DCM feature present in the last two releases. However, I have noticed the Generic ODBC Connection is missing :

Classic Connection Manager :

Data Connection Manager :

Best regards,

Simon

CI / CD is critical to any production level process, especially when multiple authors are contributing new features to the same workflow. Currently, multi-author editing of workflows is extremely difficult, and something that would be aided greatly by using git to control different branches of ongoing work. Luckily, that's something we can already do today! However, the ability to test before merging a pull request is critical to modern CI / CD pipelines. For this, it we need to be able to run a headless workflow from a CI / CD environment. Also, having the ability to pass in parameters to the workflow would allow for robust integration testing - something that isn't straightforward today without running on production environments. 

Hello Alteryx,

It seems that the Endpoint parameter for the Amazon S3 Upload tool only support "Path Like" URL. It would be great if the Endpoint parameter could also take into account "Virual Hosted" URL.

When we enter a "Virtual Hosted" URL, the "Bucket Name" and "Object Name" parameters don't respond correctly.

The three dots option for the "Bucket Name" parameter returns the bucket name and the object name at the same time. And the three dots option for the "Object Name" parameter doesn't suggest any object name.

We can enter those manually but we lose some of the Alteryx functionnality. 

It would be a great improvement that the Endpoint parameter takes into account "Virtual Hosted" URL so we keep "Bucket Name" and "Object Name" suggestions once the Endpoint is registered.

Is it in the roadmap?

François

Hi,

The imputation tool allows exchange of numbers. It would be great if we are given the option to impute string values and NULL value too

I always get a chuckle out of seeing PowerPoint presentations which, through numerous tables and illustrations show the "health" of "x" - where "x" is a customer, a market, business division, etc. - where the author spent hours creating graphical indicators such as arrows to render trends.

Recalling being provided such a deck from a senior leader who was touting how precisely the deck drew attention to areas of needed action.  The deck, in this case, was a 6 figure investment from a consulting firm. My unwelcomed response was, "Pretty pictures, nice illustrations.  What happens when business shifts tomorrow and we need to see this updated?"  There was no response.

In a different past life, I had the opportunity to create a similar deck, but utilized PowerPoint's ability to link to Excel, and VBA that made the tables graphs - and trending arrows all dynamic based on the data.  

This feature request, however, is not about me.  The dynamic slide deck solution was a windfall.  Alteryx workflows can certainly push dynamic data into .xlsm files to lighten the burden on the .xslm by eliminating the data pull.

BUT - not many organizations care for having production .xlsm files in use, and they're difficult to governance control.

Would be GREAT if one of Alteryx's output options was:  A PowerPoint

Give the developer the same ability to render "pages" as one would to populate Worksheets in a Workbook.

Have to believe would be a game changer for the product.

Hello,

Please add UI-related Themes to choose from such as a Dark Theme, so that all aspects of the UI changes accordingly.

Without a Dark Theme, it is very difficult to work in Designer for a long time.

Add these themes under User Settings --> Themes tab

Thanks!