Alteryx Designer Desktop Ideas

I am currently using alteryx to generate pdf reports and noticed there is no option to have multiple row headers. In my line of work i cant skip this as the end users insist on having it like they have always had it.

I definitely think this should be available as many of us like replicate canned reports which are otherwise in excel and hence see the need for such an option.

The following might give an example of the multi row header,

Also the ability to merge certain columns to create the above effect should be available.

Experts - 

During development it would be helpful to be able to do the following in both Formula and Filter tools (and perhaps any other tool that uses custom code):

1) Highlight a line or block of code

2) Right click

3) Comment/Uncomment

Easier than manually typing or deleting "//" at every line.  

Thanks in advance!

Instead of using the arrows, I think it would be nice to be able to drag and drop the questions to rearrange them in the Interface Designer. This would go more hand in hand with the drag and drop experience of Alteryx.

Additionally, when a lot of interface tools are on the canvas, Designer really slows down if you need to rearrange the order of the tools in the Interface Designer. I would like to see if there is any way that this can be sped up.

Thanks!

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

The Transpose In-db stands in the "Laboraty" for years now. I understand Alteryx invested some time and money to develop that but sadly we still can't use that tool for sensitive workflows. Did you get some bugs on it? Can you please correct it and make this tool an "official" tool?

Thanks

The Alteryx.Flexnetoperations.com  license management site needs major work.

On the View Licenses page it shows all licenses going back several years. A basic need is to show only licenses which haven't expired, but that is not an option.You cannot even sort on the expiration column while you can sort on most others columns.

The most simple need is to see a list of my current active license users - but I do't see a way to do that.

I tried an "Advanced Search" and chose  expiration date after 2019-10-29 and none of my licenses which expire in 2020 appear - I get a blank list.

Similarly on the administer machines page you cannot filter to hide expired licenses or even on the licenses column (which doesn't sort either).

The help link on the page doesn't bring you to help specific to that page but the general activation help front page. After several clicks I found this page:

https://help.alteryx.com/licensing/current/Administer/AdministerMachines.htm?tocpath=Administer%7C__...

But  the help is incomplete (doesn't list Machine types or the difference between Active and Inactive)

Also, there is no export capability - copy and pasting into Excel is a formatting headache as it brings in check-boxes.

Lots of room for improvement here.

Cheers,

Bob

P.S. I understand that work is being done on this, but an ETA would be greatly appreciated.

In order to debug a call to a REST API - it is often necessary to take the web call, and pop this into a web browser. Can you add a second output to a RestAPI tool (a derivative of the Download tool) that has a second output that provides the full web call that was made, including the full parameterised URL. This would make it MUCH easier to debug rest API calls.

cc: @TashaA

Similar to this idea https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Download-tool-Request-and-Response-details/i...

except my preference would be to pull Rest API calls into a more specific tool and give a second output for the responses

When developing and/or troubleshooting workflows, I frequently disable the outputs using the checkbox in the Runtime configuration settings to speed up the workflow and prevent sending emails and/or overwriting data in the output sources... however, 9/10 times I forget to turn off this checkbox when I save my workflow back up to the Gallery. This results in countless emails from users to the tune of "I ran the workflow successfully, but there was no output?" 🙂

Would love love love to see some sort of warning notification (similar to the ones that already shown for data sources etc.) when saving to the Gallery if the "Disable All Tools that Write Output" option is selected in the Runtime settings.

Thank you!!

NJ

Hello, 

Please can we have some drawing tools, so we can add another dimension to our workflows.  I would like to draw arrows and lines across my workflow, so I can show the different stages of the workflow. I could use containers as an alternative, but feel lines would be better.

Also, is their a grid-line option, and a space equally (to spread tools evenly across work page), and an auto straighten!

Also, when you FIND, it would be nice if the Find box is allowed to stay on screen, whilst you work on the tool that has just been found; and if the founded tool can be highlighted more clearly so it can be seen. 

Also, a timer, so we can see how long the workflow runs for.

That's it for now. 

Thanks

Highlighted in this post: Solved: DateDiff question - Alteryx Community The DateDiff function under certain conditions does not work as you would expect and I suspect most people would not notice the inaccuracy.

Here is the formula for the Results Column below:

DateTimeDiff("2022-11-30",[Date],"months")

We have Alteryx running in AWS which seems to be a common setup.Our AWS instances are set-up with IAM roles which has been one of the security measures applied in order to finally allow our enterprise company to allow some development in the cloud. IT will not allow the sharing of Access keys to connect to S3.

• Would like to use the AWS S3 Tools from the connectors palette as the AWS CLI has limited ability to handle/report exceptions or issues with any detail. At the moment, we are limited on what goes into production as we are using CLI for what we can.
• Ideally, an option would be to add to the S3 Tools allowing the user to select IAM Roles rather than Key Access. Refer the screen attached.

While Alteryx allows for a proxy username and password in the settings, these are not passed properly to an NTLM proxy. Support for NTLM authentication would be incredibly useful for a number of corporations who utilize this firewall setup.

We currently have to either download via Python or cURL through batch commands called by Alteryx. Since Alteryx uses a cURL back-end, this should be a fairly simple addition to the existing download tool by allowing a selection of proxy server, port, and authentication method in addition to the proxy username and password. This could be done either in the tool itself or in User Settings.

Hello!
A quite minor, pedantic issue from me today. 

Currently, the Oversample Field Tool's naming and configuration suggest that the tool can over sample data:

However, I would argue the tool under samples data instead.

Here are a few sources that explain this much better than I can:

• Towards Data Science
• Wikipedia
• Medium

And an image is taken from Medium:

Effectively either step is to create a similar (or same) number of records between each class. Under sampling is the process of taking samples from the majority class, and ending up with a smaller dataset than started with. Over sampling is the process of duplicating records within the minority class, and creates a larger dataset.

When using the Oversample tool within Alteryx, using the example workflow for reference:

When summarizing the input:

And the output:

It's clear that the data has actually been under sampled, in that random samples have been taken from the majority class to match the minority, rather than creating duplicate minority records. 

I would suggest a quick renaming of the tool to "Undersample Field Tool", and documentation to not cause confusion to new users of the platform.

Kind Regards,

TheOC

Could we please change the Interactive Chart tool, to:

• recognize when upstream types have changed and reconfigure (in the case of numerical types marked as string)
• For line charts - sort the values in order of the X value

Sample Flow - derivation of challenge 201:

Issue 1:

- The first interactive chart on this flow has no sorting at all performed by the charting tool - this may be due to the fact that the X & Y axes are in string fields.   Generally line charts would attempt to sort both the axes and the values (where the values should order according to the X axis).   Please can you add a default sort anyway?

Issue 2:

- If you then change the data types on these fields to be numeric - the charting tool still does not sort them until you reconfigure the tool manually
- REquest: please can you get the tool to remember the data types, so that it can prompt you; or even better just reconfigure?

(image looks identical after retyping the fields)

Issue 3:

- When you do a manual reconfigure of the tool after changing the types - the axes are sorted, but the values are not - so you end up with a chart that crosses back and forth.   Generally line charts are ordered in the order of the X Axis for the values

- Request: Please sort values on the line chart automatically in order of the X value?

NOTE: Finally got the outcome needed by forcing the sort before the interactive chart tool

TIBCO Data Virtualization is a Data Virtualization product focused on creating a virtual data store consolidating data from throughout the enterprise.  It can be accessed via a SQL query engine, and has a variety of supported connectors, including an ODBC driver.

This data source can be connected to via ODBC in Alteryx today, but error messaging is unclear/unhelpful, and attempting to use the Visual Query Builder causes Alteryx to crash.

Adding TIBCO Data Virtualization as a supported ODBC connection would empower business users to leverage this product and easily utilize this enterprise data store, enhancing the value of the Alteryx platform as a consumer of this data.

Hi,

I have 2 simple ideas that would help me a little bit while working with the explorer box: 

• I think it would be amazing if we could pick the Internet Browser while using the Explorer box. 

While opening certain websites, I am getting this information: 

I know probably the answer to it isn't so simple, but that would give us a little bit extra flexibility while using Explorer box. 

My goal is to open a word or excel file with specific documentation. If I were able to use a newer browser, I could easily open a file with a link to a webpage. 

• Second, can we give the Explorer box a header similar to what we got in the containers? The address bar does not always give us information about what the explorer box shows and a small extra header that we can configure would add some additional clarification

Alternatively, if I could merge a comment tool with the Explorer box tool that would also work.

There is duplicated action in the table tool to force the user decide the decimal places.

In the normal situation, all the data preparation process has been completed prior to the Table tool, we just want to leverage on this tool to format the header or incorporate conditional formatting. However, once the Table tool is connected and we have to re-configure the decimal places for all the numeric columns, the column names will be varied from year to year and it brings additional manual intervention to the workflow.

We recommend to provide flexibility for us to take the original upstream data source without changing the underlying data set.

Lack of tools in Alteryx to extract data from True PDF. The current set of tools (Computer Vision) only allow us to extract data from images which is not ideal for True PDF documents in terms of accuracy.

I have recently added an Azure data lake v2.   The Azure input/output connectors do not work with this version of the Azure data lake.

It appears that Alteryx adds ".azuredatalakestore.net" to the file path.   This works for V1, but not needed for V2

any plans to configure a connector for Azure data lake v2?