Alteryx Designer Desktop Ideas

I got so used to double click the tool on the tool pallet to insert it on the canvas that whenever I search for a tool, I keep double clicking it in the search results and, of course, nothing happens. 

Currently it is possible to save the expression in the formula tool. However, the field size and type are not stored with that saved expression, that would be some nice change. Maybe could be a checkbox to include that.

I often work with files from vendor software packages where the input/output files are actually delimited text files, but where the filetype is a vendor defined filetype (Branding!), rather than .csv or .txt.  I would like to be able to whitelist these file extensions as data files so that they can be dragged into workflows.  I'm able to import them using "All Types" and then manually defining the import specifications, but it would be nice if I could define this on a file type basis rather than on a per file basis.

Hi Team,

Could there be an enhancement made on the Dynamic Input tool to configure based on name.

This idea came up as I wanted to use an excel file and combine all the sheets. Currently, the tool imports data based on position, if there could be an option to import the data to configure the import based on name, that would be helpful.

I love the macro indicator. It is not obtrusive and over the top. Can I have something similar for tools that are available to be cached? I don't want to hunt and right-click on tools to see if the cache option is greyed out of the context menu. Please just put a wedge or some other shape on the tools that can be cached.

In older versions, I could delete the text of an annotation. It didn't matter if I wrote it or if it was autogenerated. Now, I cannot remove the text of the annotation. Yes, I know that I can hide the annotation of that tool. I want to delete the text. I have to select all the text and replace it with a space. I don't know why this functionality changed. Please change it back.

Hello,

the Python scripts sometimes get lost or updated when the user forgets to save his/her Jupyter notebook.

Please enhance.

Thanks and best regards,

Fabian Rudolf

The community could benefit from easier integration of splitting and applying functions to grouped data. The summarize tool is great for splitting your data and applying summary statistical functions. It would be super useful to take that block just one step further, and allow users to apply any other (aggregate) function to their grouped data instead of just the built-in functions in the summarize tool. I would envision that aggregate function either being a custom function that is a combination of existing user-specified functions within Alteryx (e.g. in the formula tool) and/or even an interface that allows you to use other Alteryx macros on the grouped data.

Apply user-defined functions, or other powerful Alteryx macros to grouped and data is a very common operation in the data analyst's daily workflows and being able to apply them without reverting to batch/iterative macros in a seamless manner would be naturally helpful.

https://ramnathv.github.io/pycon2014-r/explore/sac.html

To insert and update rows to our Oracle database, we're mostly using the output data tool (especially updating, since it's not available for Oracle via the in-DB tools). The output data tool just has more options to choose from versus the in-DB toolset (screenshot 1). 

However, the one thing that we would really like to see in the output data tool is the option to connect to a database via a connection file (like f.e. in the connect in-db or data stream in tool, see screenshot 2). The thing is, we can set an encrypted connection in the output data tool (and upload it to our Gallery). However, doing this for 80 workflows and 10 output tools per flow makes it quite a annoying task to do. We're not the administrators of our Gallery and want to be able to run the workflows locally as well. Therefore, in my opinion, it would be great to utilize the connection file function in the output data tool, it provides the option to centrally manage your db connections without being dependent on a server administrator.

Screenshot 1

Screenshot 2

It would be great if you could fix the Interactive Trainings - great idea to have them, but they are constantly down (at the moment Apps does not work, then went to Predictive Grouping, which also does not work). Not quite sure why this is so complicated, maybe the whole thing could be moved to youtube (if you have server limitations) and then have the test questions separately on the alteryx website.

Really demotivating that whenever I have an hour to learn  during the day, it is a lottery, whether the interactive trainings will work or not.

Before new ideas, we should also be conscious of getting the basics right.

Thanks

Would like a component to analyse an incoming dataset and suggest a key for the data, i.e. detect what field or composite of fields would uniquely identify a record in the data.  The key could then be detected by the output data component and add primary key's to tables when created.  Great for when using the drop and recreate option, i.e. would retain an index on the key.

These windows when pulled out as stand-alone windows are free floating, able to be placed anywhere on any screen you have connected.

If one of these screens gets disconnected those windows don't change position. So if your monitors die or go away for some reason there is no way to get them back unless you get a second monitor.

I propose you change the coding to where when a window is re-enabled it always shows up at position [0,0] on monitor 1.

Very frustrating.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-a-asc-document/m-p/883666#M212467

Hello,

I am currently testing whether my company could use OneDrive as repository for all of our new projects.

Example path:

C:\Users\MyUserNameFolder\CommonCompanyOnedriveFolder\SpecificTeamsDirectoryFolder\

"C:\Users\UserName" is dynamically changed part of all dependecies located on our Onedrive TEAMS folder. In order to dynamicaly define that part for all of our input/outputs we have to utilize GetEnvironmentVariable("USERPROFILE") function at all input/output routes.

Problem lies with macros. Although I can use %TEMP% user variable to define paths for all macros, I wasn't able to replicate that with %USERPROFILE%

<EngineSettings Macro="%TEMP%\CommonCompanyOnedriveFolder\SpecificTeamsDirectoryFolder\OneDriveTesting\testingmacro.yxmc" /> works

<EngineSettings Macro="%USERPROFILE%\CommonCompanyOnedriveFolder\SpecificTeamsDirectoryFolder\OneDriveTesting\testingmacro.yxmc" /> doesn’t

Could you please enable all user/system variables to be detected at runtime (even custom ones)?

This would enable Alteryx Designer to support cloud based storage folder natively, as filepaths for all OneDrive based files stored locally would be dynamically changed across users with a particular workflow opened.

Alteryx version 2020.4

In the Explorer box configuration section, it would be great to add a navigation button to pick a URL address (pin point) to a directory/folder so that the user don't have to learn by heart (or copy paste) the exact URL address to make use of the tool.

I have three groups: a control group, a group that got product A, and then a group that got product B. There is a way to test the differences across all groups rather than running separate t-tests (which introduces type I error several times). If my outcome is the percent of people who were contacted, I want to see if the percent is different across groups.

Control Group % who were contacted: 10%

Product A group % who were contacted: 25%

Product B group % who were contacted: 33%

I shouldn't have to run a t-test comparing control to A, then another comparing control to B, and then a third comparing A to B. I know the method is pairwise comparisons but I'm not finding how I can do this in alteryx and I've looked on the community and surprisingly the answer seems to be "you can't" but this is not a rare statistical test!

A product analyst at alteryx help build a macro in R to run the tests but the variables need to be categorical rather than continuous. The ideal solution is that an additional predictive analytics tool can run these ANOVA tests and there's something to specify whether the variable is categorical or continuous.

-Justin

Hi,

As it is so important to be able to calculate and present time related concepts in modern businesses, it is not possible to have a better output choice?  I have seen the reporting chart tool, I have looked at the TS Plot tool and even noticed that the Laboratory Charting tool has disappeared.  So can you please provide an output tool that provides some focused functionality on this lacking part?

Kind regards,

Peter 

During execution the user cannot scroll around. Large workflows need to be shrunk to very small icons to be able to follow the progress. Either have an option to automaticaly center on the active icon or allow scrolling during execution.