Alteryx Designer Desktop Ideas

When a tool container is disabled, I'd like the lines that are going into it to be different from "enabled" lines. 

They could be grey or dotted for example.

When working on a workflow and disabling containers, I find that the lines entering disabled containers become confusing or cluttering. It would be much simpler to focus my attention efficiently if lines that remain enabled could be distinguished quickly.

I would like to suggest the functionality of converting an In-DB tool to Input Data automatically as it is done with Input Data so that it becomes an automatic Macro input.

The reverse would also be interesting, converting the Input Data, when it is connected to the database, to In-DB.

There are times where new versions of Alteryx come out, but there are situations where you cannot keep the Desktop and Server versions in sync.

As an example, at his time of the year, we are getting ready for year-end and al the workflows located on the server have been tested and signed off on. Now there is a new version of desktop with new features, but advise everyone to stay on the current version in case we need to make a fix. Typically, if we updated Designer desktop and try to publish the server -- you will get a versioning error.

I propose that when saving to the server, I can choose the compatible version and Designer/Server can let me know if there is any features I am using that will not work. If I don't use any features from a newer version, the workflow will publish.

So, let's say my server and Designer are at version 2022.1 and I decided to download version 2022.2. Typically, if I open and make any change with the new version -- I would get an error saving to the server - even if I am not using new features. However, what I am saying is that there is an option asking me what version I would like to save the workflow to the server as and I can choose 2022.1. Designer or server can check if I did or did not use any incompatible features, and if not, can save to the with the appropriate version.  

Thanks,
Seth

Designer should support statistical testing tools that ignore data distribution and support Statistical Learning methods.

Alteryx already supports resampling for predictive modeling with Cross-Validation.

Resampling tools for bootstrap and permutation tests (supporting with or without replacement) should be tools for analysts and data scientists alike that assess random variability in a statistic without needing to worry about the restrictions of the data's distribution, as is the case with many parametric tests, most commonly supported by the t-test Tool in Alteryx. With modern computing power the need for hundred-year-old statistical sampling testing is fading: the power to sample a data set thousands of times to compare results to random chance is much easier today.

The tool's results could include, like R, outputs of not only the results histogram but the associated Q-Q plot that visualizes the distribution of the data for the analyst. This would duplicate the Distribution Analysis tool somewhat, but the Q-Q plot is, to me, a major missing element in the simplest visualization of data. This tool could be very valuable in terms of feeding the A/B Test tools.

Hi,

we use a lot the in-db tools to join our database and filter before extracting (seems logic), but to do it dynamically we have to use the dynamic input in db, which allows to input a kind of parameter for the dates, calculated locally and easily or even based on a parameter table in excel or whatever, it would be great to be able to dynamically plug a not in db tools to be able to have some parameters for filters or for the connect in-db. The thing is when yu use dynamic input in-db, you loose the code-free part and it can be harder to maintain for non sql users who are just used to do simple queries.

You could say that an analytic application could do the trick or even developp a macro to do so, but it would be complicated to do so with hundreds of tables.

Hope it will be interesting for others!

It seems like it is restricted to 255 characters using .hyper as an input (Alteryx designer discussion).  It would be great if we can read at least 2147483648 bytes which is the string limitation in Alteryx.

Hello Alteryx Team,

it is very important to upload json strings to snowflake. The reason is to built data vault 2.0 on snowflake side to have a scalebale dwh. I tried many different ways to do this but nothing works for me. Please can you implement for me this feature for the output tool.

best regards

Jan

it would be great to have an Azure SQL DB or/and Azure SQL DW Connector. In the moment it is only possible to connect with the Standard SQL Db connector. To be successful a username and password is always required.

It would be perfect, if you can use your Azure AD User and Password and connect against the relevant Database within the Azure environment. 

I often search for a tool on the canvas using control find and the tool number. If the tool is already in the visible pane, Alteryx highlights the tool with a faint dotted box. The problem is that I often have hundreds of tools that are visible and I have to constantly hunt around the canvas to locate the highlighted tool. Please update the control find settings so that when you use control find, Alteryx centers the current view on that exact tool. That way your eye can scan the middle of the canvas and locate the tool every time without this wasted effort searching for the tool outline. 

Hi there,

Could we please add a simple date function which allows you to construct a date from the basic inputs (rather than having to go through date-time-parse).

Example:

Function CreateDate(Year as integer; optional month as integer; optional day as integer; optional hour as integer; optional minute as optional; optional second as integer) as DateTime

Examples:

• CreateDate(2017) = 2017-01-01 00:00:00
• CreateDate(2017, 4) = 2017-04-01 00:00:00
• CreateDate(2017,04,05) = 2017-04-05 00:00:00

Hi all,

@PaulT put this list of keyboard shortcuts for the Alteryx Designer together in 2013, and it seems to not have been updated since then, and I cannot find a well-structured version of this elsewhere in Alteryx documentation.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Keyboard-Shortcuts-in-Alteryx/ta-p/1188

Please could I ask that this be converted to a standard page in the Alteryx help documentation, and be structured into logical categories (example: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts)

Many thanks

Sean

Scenario: I open a results window with a link, filepath, value, etc. and I want to copy the text.

If I click inside of that cell and press Ctrl +A, nothing happens.

If I click inside the cell, arrow to the end of the text, and then press Shift + Home; the contents of the cell are highlighted.

Why can't we have all of the Windows shortcuts?  Or am I missing something here?

Add PowerPoint format file (ppt/pptx) into supported file type as direct connection in Input Tool.

PS. I know that we have workaround allowing to import PowerPoint slides into Alteryx but I'm describing automated solution :)

Cheers,

Pawel

Dear Alteryx Team,

Dynamic Input Tool is a great tool to import easily multiple files using files paths parameters ... having the same tool for outputs would be great to export many files in pre-established folder.

Many thanks

Arno

The Formula tool has lower case, upper case, and title case. But I often need to change multi-word notes text to sentence case, where only the first letter is capitalized. Instead of having to write a special formula, it'd be nice to have a sentence case function.

this is lower case

THIS IS UPPER CASE

This Is Title Case

This is sentence case

Hi All,

With Integration of various platform in Alteryx, connector seems to be an ease of use.

One is, yammer connectors. It would-

1. Help to extract insights of organisation pages.

2. Understand the productivity/Ideas of an organisation overall and help in enterprise content management.

Currently, the process to extract such data is through REST API/Bulk API and a connector would solve the issues.

Thanks

Harsh

We really need a block until done to process multiple calculations inDB without causing errors. I have heard that there is a Control Container potentially on the road map.  That needs to happen ASAP!!!!

Service Now dashboards really don't give me as much flexibility as I need, but can't help thinking an Alteryx connector coupled with Qlik Sense dashboards would be fantastic. SNOW seem to be supportive of Tableau - have you guys got plans to get in on the action?

We have several .txt input files (same structure) that need to be combined into one file.  But all the files have summary information on the first 6 rows.  Alteryx help me created a macro to skip the first x rows but it is involved - but it works.  Having a "start data import on line x" would greatly simplify the process.