community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the like in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

The "Manage Data Connections" tool is fantastic to save credentials alongside the connection without having to worry when you save the workflow that you've embedded a password. 

 

Imagine if - there were a similar utility to handle credentials/environment variables. 

 

  • I could create an entry, give it a description, a username, and an encrypted password stored in my options, then refer to that for configurations/values throughout my workflows. 
    • Tableau credentials in the publish to tableau macro
    • Sharepoint Credentials in the sharepoint list connector
  • When my password changes I only have to change it in one place
  • If I handoff the workflow to another user I don't have to worry about scanning the xml to make sure I'm not passing them my password
  • When a user opens my workflow that doesn't have a corresponding entry in their credentials manager they would be prompted using my description to add it.
  • Entries could be exported and shared as well (with passwords scrubbed)

Example Entry Tableau:

AliasTableau Prod
DescriptionTableau Production Server
UserIDJPhillips
Password*********
+ 

Then when configuring a tool you could put in something like [Tableau Prod].[Password] and it would read in the value.

 

Or maybe for Sharepoint:

 

AliasTeamSP
DescriptionTeam sharepoint location
UserIDJPhillips
Password*********
URL http://sharepoint.com/myteam
+ 

 

Or perhaps for a team file location:

AliasTeamFiles
DescriptionRoot directory for team files
Path\\server.net\myteam\filesgohere
+ 

 

Any of these values could be referenced in tool configurations, formulas, macro inputs by specifying the Alias and field.

1-3-2019 12-43-52 PM.png

Love the new updates to the Browse tool in 2019.2! However, if you choose the option Open results in new window, which I do often so I can see my whole dataset, the search/filter/sort functionality goes away. Would be great if that new functionality also worked in the new window. Thanks!

1.JPG

 

Can't wait for the new base maps!

OK, this one will only save a single click per addition of a tool, but with Alteryx's general awesomeness small annoyances become like a stone in the shoe.

 

Consider my highly complex workflow below ; having inspected the dataset I now realise that I don't want some of the fields in my dataset...

 

SwitchToInput_1.PNG

 

...so I drag a Select tool in to deselect the columns, but I can't remember what the dataset looks like and I can't see the data...

 

 

SwitchToInput_2.PNG

 

...so I click on the Input tab and there it is, I can deselect away !

 

SwitchToInput_3.PNG

 

It would be particularly useful with something like a Summarize tool where I like to see the data to decide which aggregation to use.

 

Thanks !

I couldn't find anything where someone has submitted an idea yet and solution proposed by Paul N. (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/List-of-Tables-in-Ms-Access/td-p/30020...) does not work when attempting through Alteryx (that SQL works directly in MS Access).

 

I'd like that have the metadata option similar to xlsx input where you can output a list of all the tables in the file.  That data can then be used for a dynamic input to iterate through those different tables in a more automated solution.  As an example, if I have a list of accdb's that I want to parse through to scan the contained data for something of interest, I'd have to currently view each table one by one for each database which is highly time consuming.  Whereas if I had that table list from the metadata, I could loop through those searches must faster by using the full file path as the iteration. 

 

Thank you

The configuration window for the Browse tool already shows Min, Max, Average, St.Dev, etc for numeric fields. If it included 'Sum' as well it would be very useful for tracking a control total for a given field through a workflow.

I would like to have all my annotations show on top of the tools by default. I can change them one at a time, but I would like to be able to change the default setting to be "Show Annotations on the Top" always.

Hey Alteryx Dev Gurus - 

 

I've got a situation wherein the user runs something in Gallery, and complains.  I have to log in as that user to view the output files that came back out.  As a super user, I should be able to have all seeing ability!  Thanks!

 

brian

 

I love Workflow Meta info, especially the ability to put the Author, the search tags,the version, the description, etc...

workflow meta info.png

But why can't we use it as Engine Constant? It doesn't seem very hard to implement and it would change life for development.

 

engine_constant.png

When reading and writing large data frames to/from a python script in Alteryx it seems that there are limitations to the SQLite component of the tool. Given that this selection is recommended only when the user is having issues in the python tool why is the option selected by default? A colleague and I spent a couple of hours trying to work through an issue with importing a data frame larger than 1000x1000 and once we found this option (SQLite override) and unchecked it the data was written back to Alteryx without any problems.

 

Hint provided by the tool, "This changes the intermediate data format between Alteryx and Jupyter from yxdb to SQLite. Use only if running into issues. See help for more details."

 

Python Jupyter.PNGSQLite override is default selection

Error message provided by the tool

error message.PNG

After unchecking the option the workflow ran without any errors.

 

Recommendation: the python tool should default to SQLite override unchecked

 

It would be very useful to be able to search the field by typing the name instead of scrolling up and down looking for it among a few hundred fields.

 

 Select Seach as you type.jpg

This is the most minor of annoyances, but it would be great if I could copy and paste color hex values between containers, comments, etc. The system color dialog doesn't have that, so maybe if the color boxes in the configuration pane were directly editable, or something like that. If I'm changing the colors for multiple containers, it's kind of a pain that I have to select the R, G, and B values manually. 

Maybe it was a lack of planning, but I've had a need to rename a variable within a workflow and would like to (outside of the XML view) be able to rename the variable so that downstream tools don't have to be reconfigured (e.g. formula, join, union).  

The admin needs to be given more control. The admin (curator) should have equal to and great control than the users of the system.

 

My organization is in the Healthcare industry and we have HIPAA laws to abide by when it comes to data. Not all users should be able to see all data. Developers should not have complete control over the data they publish.

 

Private studio -- admin should be able to control if user can publish to public gallery (compliant issues occur when users can all see and run workflows)

 

Collections

  • admin should be able to create collections so they can manage the collections and what users have access to
  • admin should be able to control if users can create new collections (again, compliance issues)
  • admin should be able to add workflows to collections (so users don't need to manage collections, admin can add the workflows for them)
  • admin should be able to give and remove download of workflow rights

 

Get tips from Tableau as they have admin controls down with their permissions process.

User.DevInputPath  \\Server\Path\Input

 

%User.DevInputPath%\myInputFile.yxdb

 

When I define a constant and then use it to reference an input dataset it makes it very easy for me to switch paths.  It also creates a little headache for me if I copy that input or create another workflow.  When I create another workflow, I must re-type and create more user constant entries.  It would be nice to be able to + (create new workflow) and to generate it via a copy of the current open workflow (copy ALL preferences set plus the user constants) from the workflow.  Even the ability to copy/paste the constants would be an improvement.

 

Cheers,


Mark

I'd like to see an enhancement that at the install level (through an XML configuration file for example), the use of the From field in the Email reporting tool could be disabled for population by the end user and instead would auto-populate with that current users e-mail address.  Currently users can populate the field with any address on their domain, which is useful, but also poses a risk in that messages can be made to appear to be coming from a party that is not aware of it.  We'd like to be able to control that on install and "turn off" access to the From field

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!

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

I want my Save Setting to stick on the Browse tool when I save output.  I almost always save to Excel.  The default is to save the output as an Alteryx .yxdb.  That is useless unless I going to further slice and dice in Alteryx - which I'm not - which it why it being output to Excel to go to the end user.  Once a file type is chosen - let that file type stick for future exports as most people save there output in the same file type each time.  I find myself inadvertently saving .yxdb and then needing to resave in .xlsx.

The issue : we have to regurlary change our passwords. It implies changing it for all the connections alias (at least for standard connections). 

What I'm looking for :

A commande line to execute like :
alteryxpw.exe -connection {alias name} -connection_type {user/system} -connection_mode {standard/indb} -pw {new password}

This command line could be executed by a powerhsell script.

In Dec I had an issue where I could not uninstall or upgrade Alteryx. As part of troubleshooting and the eventual solution I had to manually delete any registry key related to Alteryx. As these were hundreds of entries this took a long time. It would be handy if Alteryx could provide a tool that cleaned the registry of all Alteryx related entries. Related: "Case 00088264: Unable to uninstall Alteryx"
Top Liked Authors