Alteryx Designer Desktop Ideas

Session connection to Google Sheet exists for 60 minutes. If someone wanted to keep this for more time then "User Login" option requires re-entering credentials every 60 minutes.

However, we can use the Developer Login0 to bypass this limitation. This method requires sign-in using Google API credentials. This option requires obtaining a Client ID, Client Secret, and Refresh Token and does not require re-entering credentials to run a workflow.

My question - can you address this issue in next release of Alteryx?

Currently the Filter tool not supporting the multiple variable value check like a = b = c. It would be nice if the filer tool supports multi-variable check in one go.

I've been using the Intelligence Suite to automate building models using assisted modelling, It works great. However If I then output the model to the Python tool I ran into a few issues. The Intelligence Suite relies on the EvalML library so I wanted to use the python tool to use the model created with some of EvalML's other features such as prediction explanations.

What I found was that the intelligence suite for 2021.3.5 uses EvalML version '0.13.2' which is from 2 years ago meaning a lot of the extra features are not available.

It would be great with each new Alteryx intelligence suit the EvalML package also updated. 

When I'm working with a new data or tool set, I'd find it helpful to know which tools other analysts are using.

I'm envisioning an optional, dockable window where a list of tools (and possibly percentage/probability rank) exist to suggest the next tool most users add after the selected tool (or blank canvas).

For example, I open a new workflow and the window shows the following suggestions of tools:

Next, I add a File Input.  While the File Input tool is selected, the list updates to show the most utilized tool after a File Input:

If I click back onto the blank canvas though, the suggestion window reverts to:

Ideally, there would be the option of the Community stats and/or your local server/enterprise stats.

I learnt Alteryx for the first time nearly 5 years ago, and I guess I've been spoilt with implicit sorts after tools like joins, where if I want to find the top 10 after joining two datasets, I know that data coming out of the join will be sorted. However with how AMP works this implicit sort cannot be relied upon. The solution to this at the moment is to turn on compatibility mode, however...

1) It's a hidden option in the runtime settings, and it can't be turned on default as it's set only at the workflow level

2) I imagine that compatibility mode runs a bit slower, but I don't need implicit sort after every join, cross-tab etc.

So could the effected tools (Engine Compatibility Mode | Alteryx Help) have a tick box within the tool to allow the user to decide at the tool level instead of the canvas level what behaviour they want, and maybe change the name from compatibility mode to "sort my data"?

Passing data to the next app running in a chain from the gallery varies from challenging to impossible. An impossible situation I've found is when the same user needs to run multiple instances of the app simultaneously. Very difficult is just allowing two different users to run simultaneously without risk of passed data mixing between the two.

This idea would add the capability to pass values from one app in the chain into user variables in the next app in the chain.

This is purely aesthetic but it would be great to have a button to auto format tools positions on the canvas. The idea would be similar to a feature many IDE's come with to auto format code so that the indentation is corrected and duplicate return characters are removed.

We currently have the Align and Distribute capabilities which is great. This could be expanded to the entire workflow so that the canvas could look at which tools connect to which and structure their positioning around that. I think it would be a great clean up feature after finishing a workflow. 

Hello

My problem: I've used the download-tool to download a 40mb XML. Parsing the DonwloadData-field containing this XML results in about 6600 records. The XML-Parse Tool passes the orginal DownloadData field to each record, resulting in quite a bit of memory usage:

XML-Parsing Problem

Suggestion: An option in the XML-parse Tool to not pass the parsed field in its output. 

Marco

I would like to raise the idea of creating a feature that resolves the repetitive authentication problem between Alteryx and Snowflake

This is the same issue that was raised in the community forum on 11/6/18: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/ODBC-Connection-with-ExternalB...

Can a feature be added to store the authentication during the session and eliminate the popup browser?  The proposed solution eliminates the prompt for credentials; however, it does not eliminate the browser pops up. For the Input/Output function, this opens four new browser windows, one for each time Alteryx tests the connection. 

Recursion is a common task that we perform while creating ETL process. There should be some way in the macro to allow recursion process, i.e. taking value from the output in macro and providing it as input to the control parameter. 

Adding this feature could improve ETL capabilities within Alteryx

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.

In a multi-person BI team; or where you have a multitude of different flows hitting similar data - it's easy to loose track of the right connections; the right data sets etc.

Could we please add to the Alteryx toolset, the ability to:

- Register a set of connections with readable names

- Register a set of data-sets which are community managed.

Connection Registration:

I frequently connect to 5 different datastores to bring together analytical results.   Because Alteryx remembers the connections once-used I don't have to keep on building these connections from scratch, but these don't have a human-readable name; and they cannot be shared among the team to make workflow creation easier.

Suggestion: 

• Create the ability in Alteryx Designer to set up a data-store connection, with a human-readable name (e.g. "Timesheet Server").   
• Allow me to share this connection list with my team
• Allow me to either do pass-through password (i.e. don't save a password in the connection); or embed a password but make sure it's masked & encrypted so that the receiver cannot use this to get the password for the DB
• For enterprise customers - it would be great if I can connect to the enterprise connection store and use known good connections that way too...

Known Good Data Sets:

The other part of this is the community effect once a large number of people in the company start to get data-savvy.    for e.g. One person has found a good way to query the actual timesheet data (username; project; hours) - and another person has found a good way to query the HR systems to get user demographic information (username; location; contracted working hours).   

• Can we add to the Alteryx server, in the same way as Tableau and IBM Cognos / Watson have done; to allow users to publish a data-set connector which is known to work.
• That way - if I want timesheet data - I just browse the known good data-sets through Alteryx designer, and if I have questions I can go back to the connector owner
• additionally - the central administration team can then identify the ones that are certified as "golden source" or "clean; valid; governed data", and which ones are in a state of "user supplied - use at own risk"

For enterprise customers - this would transform alteryx from a stand-alone tool where everyone is re-inventing the wheel every time - to a Data Platform where each additional piece of work done increases the net value of the full ecosystem in a virtuous cycle.   It would also MASSIVELY accelerate every workflow build.

Happy to talk through this live with the Alteryx team if that's appropriate and helpful.

Thank you

Sean

When running an app on your desktop, nested radio buttons work wonderfully.  You can collapse groups and drill down to your heart's content.  If you promote the app to the gallery, it doesn't work.  I reported this as a bug to Client Services.  Their response leads me to believe that they designed it this way.  I'd like nested buttons to work both as a local app and as a gallery app.

Please star this idea if you agree...

Dear Mark,  

This email has been sent to confirm that your technical support ticket has been closed. Please contact us if you need any further assistance.

Case #: 00095540

Case Subject: Radio buttons- different functionality between Gallery and local version

Your comment:  

when using radio button to activate a sub set of questions that also use radio buttons then entire group has to be unselected then reselected to make additional change either activate/deactivate selectoins.

link to recorded webex that demonstrates issue: https://alteryx.webex.com/alteryx/lsr.php?RCID=740fd707be5e4654ba659f25713f8cdb

Would love to have a 'common used' tab, rather than a favourties box (as that lags what I am currenty using).

Would be nice to have it look at my usage and create sort by frequency of use table. Could also be done with all users as well (some kind of opt-in telematary data?).

When output is disabled, Alteryx's output tools are helpfully grayed out and include the message 'output has been disabled by the workflow properties.'

However, if a macro has an output, there is no visual indicator that output is disabled, even though the macro's output will also be suppressed by this workflow configuration.

Obviously, macros can be very complex, and could have both a file and a macro output, or have an optional file output, so these cannot be entirely locked out just because there is an output.

To that end, I suggest some other kind of color-coding/shading be applied visually to these tools, and that a message be added to the interface for these macros that says something like "output has been disabled, this macro may not perform all of its functions".

I just spent about 10 minutes debugging why a macro wasn't working properly in one workflow but was working in another, and it was because I had disabled output, which I wasn't thinking of because this particular macro uses the Render tool to produce a hyperlink.  I wouldn't have spent more than 30 seconds on this if there was some kind of visual indicator showing me what I was doing wrong!

Pretty much only time I add Browse tools during development now is to get access to the Cell Viewer to examine values better. 

Would love to be able to do this on the output window

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.

Hi All,

Did you all experience when building a iterate macro this situation?

When you have no idea why the output is different from what you want,

hence, you remove the rows/ data to force the data run only 2 iterate, review the result.

then, you add back the rows/ data to force the data run only 3 iterate, review the result 

then 4, 5 and etc... until we found the issue.

so it was important that we can view how the result of each iterate to enable us to identify the issue quicker and more efficient.

Example output

The output may like below: (with a option to let user to choose of cause)

if input data is 3 and the macro is to multiply 2 and power of 2 every iterate. (1st iterate=3*2^2, 2nd iterate=12*2^2)

just add one column in front to show the iterate and rest is the result.