Alteryx Designer Desktop Ideas

Today, there is an checkbox to "Disable All Tools that Write Output" within the Runtime settings for a workflow.  Setting this option requires at least 3 clicks:

• Click on the canvas
• Click the "Runtime" tab in the Configuration pane
• Click the checkbox

Could a keyboard shortcut be added for this?  I've spoken to several users who leverage this feature and, while it is already a time saver, it seems helpful enough where a keyboard shortcut is warranted.

Can the inputs to app interface tools update other interface tools within the same app?  Right now, I believe the only way to do this is with chained-apps, but I don't wish to go that route again.

Just one example:

Can a Dropdown interface tool update a listbox interface tool with an action?  

Right now, I have two interface tools in an app:

1. Dropdown
2. Listbox.  

For the Listbox tool , it references an external source file for the NAME:VALUE pairs, let's call this file:  Category1.yxdb.

I would like for the resulting dropdown selection to update this external source file to say, Category1.yxdb or Category2.yxdb or Category3.yxdb, etc.

The different .yxdb files here have different name:value pairs within them.

It doesn't seem like this possible at the moment, but please let me know if this is something that's currently supported within Alteryx.

Thanks,

Collin

Hello!

Currently when using the formula tool, you can create a string using the two following methods:

With speech marks, or an apostrophe being used respectively.

I would expect both of these methods to behave the exact same way, however what is interesting is that if you type within the apostrophes anything that would prompt a formula, this is still prompted:

This is not the case within the speech marks:

This can cause mistakes with autocompletion when typing within the field. I propose a small QoL change that the formula tool will recognise a string is being written when within two apostrophes. I believe the logic is already built for that, given that it behaves in every other way the same, and highlights green too. 

Cheers,
TheOC

Data Cleansing Tool:   There should be a sub-category on the "Punctuation" cleansing.  Ideally to have an option to "Include Only" or conversely "Exclude these characters" which would allow you for example to remove all characters except   "." from a dollar formatted field .  There are times when you need to clean almost everything except a certain punctuation or not. 

Please consider adding a new setting to the Render Tool, so the users can select or deselect if an existing File should be overwritten (Otherwise throw an error, like the Output Data Tool does, when configured to create a new Sheet and that Sheet already exists)

Trying to solve some use cases, I realized that I had to simulate the factorial behaviour.

Having a factorial formula can make this process easier.

Thanks!

Hello,

It would be very helpful to have a search box for field names in the summary tool, I think it would help decrease errors by selecting fields by mistake with similar names and will help gain a couple of seconds while looking around for a specific field, particularly with datasets with a lots of them.

Like this:

Would be nice if Alteryx had the ability to run a Teradata stored procedure and/or macro with a the ability to accept input parameters.  Appears this ability exists for MS SQL Server.  Seems odd that I can issue a SQL statement to the database via a pre or post processing command on an input or output, but can't call a stored procedure or execute a macro.  Only way we can seem to call a stored procedure is by creating a Teradata BTEQ script and using the Run Command tool to execute that script.  Works, but a bit messy and doesn't quite fit the no-coding them of Alteryx.

Hi,

It would be great if users have the option to display the number of records that go in and out of the different tools in your canvas. This allows users to very quickly see how many records are in their datasets, and especially quickly analyze the results of specific actions such as joins, filters etc. without the need to open each individual tool. Especially when performing joins this can be very useful to quickly see how many of your rows have been successfully joined. I think this will give users a feeling that they have more control over their data and a better understanding of what is happening in Alteryx. Also if you quickly want to review a complex workflow (especially when it is not your own) this could be a huge timesaver. Simply run the workflow and follow the numbers to see what is happening and identify tools that might cause issues.

Love to hear what you think!

Currently - in workflows which make active use of dynamic queries - if the record set is empty then we end up with errors such as "a record was created with no fields".   This creates issues  when a dynamic query pumps rows out to a macro output, or where dynamic queries go into a join.

Could we change the result of the dynamic query so that if it returns an empty record set it still has columns but no rows and therefore doesn't cause errors in workflows?

Let me know if we need to provide a worked example?

Thank you

Sean

Most of the finance industry is using HFM or Essbase finance solutions which is flexible in keeping the data and generating reports. Alteryx should create a direct connection with Hyperion or Essbase so that it's easier to connect with the data in those systems and it can directly feed other system reports.

Using the Snowflake Input and Output Connectors when Snowflake is setup to use Single Sign On generates a lot of browser windows as the connectors authenticate multiple times (opening a browser window each time) which is very disruptive and disctracting for users.  Any time the workflow interacts with the tools and it authenticates and the browser is opened.

This is driven by the Snowflake ODBC driver using the externalbrowser authentication method however it would be helpful if Snowflake and Alteryx worked together to refine how the connectors authenticate in order to reduce the number, or completely stop the browser windows and therefore greatly improving the user experience.

Currently the BROWSE tool shows numeric data in raw format.  It would be easier to evaluate a column of data if the data was right justified and formatted with the decimal point aligned.  

Thiwould change this

234.56788

12.0

.098

to 

    234.567

      12.000

          .098

Can we please have a tickbox (ideally one that remembers your preference to be ticked or unticked) on the Save to Gallery pop up that would allow us to save a (timestamped?) copy of that workflow on a local drive (perhaps one that is preset in the user settings)?

Alteryx Server was recently updated to allow TLS-mediated connections to the MongoDB persistence layer. This allowed us to switch off of the embedded MongoDB to a highly-available MongoDB Atlas cluster. To our surprise after the switch, when we went to edit our workflows that make use of the persistence layer's data (Server Usage Report, etc.) to hit the new Atlas cluster, we found that the MongoDB Input tool does not support TLS connections. This absolutely needs to be changed. Based on organizational constraints, Atlas is our only option for a HA persistence layer. We absolutely have to have TLS support for the MongoDB Input tool. There is no other way for us to natively query our server persistence layer in Designer. Please bring the MongoDB Input tool into alignment with the MongoDB connections that are supported by Alteryx Server.

The download tool is currently a general purpose tool that is used for many different things; from downloading FTP files; to scraping websites.

However, as a general purpose tool, it cannot serve the specific need of scraping a website without doing a huge amount of work to get there.    What makes Alteryx great is the fact that it drops the barrier so that regular folks can do some really powerful analytics, but the web scraping capabilities are not yet there and still require a tremendous amount of technical skill to accomplish.

I'll go through this from top to bottom:

• Split capability: The download tool tries to be too many things to too many people.   Break it up into its component parts - one for FTP; one for Web Scraping; etc - with deep speciality.   You can still keep the download tool as the super-user version but by creating the specialized tools, we can make this much more user-friendly
• Connection:  For enterprise users, where there's a locked down connectivity to the internet - there is no way to scrape web content without using CURL.   So we need the ability to connect to websites in a way that does not require curl or complex connectivity setups for users to navigate through web proxy settings.
  
  • Alteryx could auto-detect settings by allowing the user to point to the site within a controlled browse form like Excel does
• Parameters: Many websites explicitly support named parameters (using ? notation) - it would be very useful to allow the user to link to these parameters explicitly without having to do complex string conjugations or %20 scrubbing to get of non-URL friendly characters
• Content: Alteryx presents the user with no native ability to process HTML, so all scrubbing to pull out a specific field has to be done through complex read-through of the underlying source of the website (delivered in "DownloadedData") followed by guessing on patterns on how the site does tables or spans etc, followed by complex regex.    
  • Instead, we could present the user with a view of the web-page and ask them to select the elements that they want
  • This would serve the dual purpose of making this user-friendly for regular folks and abstract away the technicalities; but also would allow the download tool to eliminate all the other bits of the page that are not wanted like scripts; interstitial adverts; images; headers & footers etc.
• Improved post / parse capability:   Sometimes the purpose of a URL is to generate a download (like the Google Finance API) - again, would be good to observe the user using the target site to record & interpret what they are looking for and what they get (e.g. the file from google)
• HTML & XML types: why not an explicit type in Alteryx for web content?
• Finally - HTML aware.   The browse tools are not currently HTML aware, so all the useful formatting to be able to see what's going on, expand nodes, find patterns etc - all this has to be copied out of Alteryx into Notepad ++.   Given the ubiquity of HTML parsers and pretty printers and editors, it should be reasonably easy to get a cheap component that can provide this capability

When entering a number of column names in the RegEx parse mode - please can you allow either Enter or down-arrow to move down to the next cell (standard windows convention)?

Currently Enter just exists the edit mode; and down-arrow does nothing.

cc: @Hollingsworth 

It can be daunting to find the tool that is currently being processed by the engine in workflows that contain hundreds of tools with many ins, outs, and branches. During runtime, I want to be shown the tool that is running on the canvas. This functionality should be in the form of a button or something to direct focus to that area. It should not be the default.