cancel
Showing results for 
Search instead for 
Did you mean: 

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 star 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 Workflow configuration window currently has "Canvas" as the default tab when clicking on whitespace in a workflow. 

Since workflow orientation, annotation settings, and progress settings tend to be consistent for a user, I think it makes more sense to have the default tab on something that might be more relevant to the user.

 

Workflow provides information that is useful...location of the workflow and constants related to the workflow.

Runtime has settings that can change often as the user is developing out the workflow.

 

So either of these would provide better access to more important info that that found on the Canvas tab.

 

I love the gallery data connection feature - we're going through some big systems architecture changes, resulting in new locations for many datasets. Having a single place in the Gallery Admin area to update connection information works beautifully.

 

We're running into issues with the gallery-hosted data connections when trying to run some apps on our private gallery though. The trouble comes up when the gallery-hosted data connection appears inside a macro that's part of an app. We get an "Unable to translate alias" error when trying to run these types of apps.

 

If we have an app using gallery-hosted data connections that are outside of a macro, the gallery is able to resolve the connection alias fine and work properly. The issue only appears when the gallery data connection is part of a macro used inside an app.

 

We use macros a lot in our app development because it allows us to use standard methods for accomplishing common tasks. Using macros also enables us to set up automated testing workflows to make sure our processes produce expected results. As it is, we're unable to take full advantage of the gallery-hosted data connections because they don't work within macros, and instead have to continue using hardcoded connection strings. These are a bigger maintenance burden as our underlying systems evolve and are updated.

Currently, if you want to change from Built-in to Windows Authentication, you have to:

 

To switch authentication types, you'll need to start from scratch.


1. Stop the AlteryxService
2. Open a Windows Folder Explorer and go to the directory you have MongoDB loaded (System Settings->Controller->Persistence->Data Folder
3. Rename or delete that folder (a simple backup would be to rename the folder, you can move it to another directory as well)
4. Open the Alteryx Server System Settings and click next to Gallery->General.
5. Select the new Authentication process you would like to use.
6. Finish the System Settings and the new database will be created.

 

The Gallery and Scheduler databases are closely tied.  Workflows that are uploaded, results created, and schedules created from the Gallery are stored in the Scheduler database.  So you will need to start from scratch on both the Gallery and in the Scheduler.

 

This is a non-starter for any company that has any amount of time invested in establishing the use of the Gallery.   Starting over is not an option, but improving security, streamlining access protocols as a part of overall data governance is a must.  Please consider fixing the authentication protocol to make it so we don't have to start over.

 

Thank you,

 

 

When I first started using Alteryx I did not use macros or the Runtime Tab much at all and now I use both a lot but...I can't use them together. 

 

When working in a macro there is no Runtime Tab. While working on a macro and testing it you can't take advantage of any of the handy features in the Runtime Tab.  I am assuming a macro will inherit any settings from the Flow that calls it, can't find anything in the community or "help" to confirm that though, but this is not helpful while developing and testing.

It would be really nice to be able to easily trace a selected field through a workflow (see below, trace in green). This would greatly help with troubleshooting.

TraceFields.JPG

Currently the Gallery's Admin API is a bit light on functionality. It only works with data connections & workflows and not regular server admin functions. Endpoints I'd love to see, but not limited to, are:

 

  • Create/modify/diable users
  • Create/modify/delete subscriptions (including assigning users to subscriptions)
  • Job status
  • Add/modify/delete workflow schedules

When using the Summarize Tool please provide a grouping action that does a unique string concatenation. Example below. 

 

Input table

CategoryString
ADog
ACat
BMouse
BRat
CFish
CFish
CFish
CFish
ADog
ADog

 

Typical Concatenation output grouping on 'Category'

CategoryConcat_String
ADog,Cat,Dog,Dog
BMouse,Rat
CFish,Fish,Fish,Fish

 

Desired output with Unique String Concatenation

CategoryUniq_Concat_String
ACat,Dog
BMouse,Rat
CFish

 

I realize that this can be done with two inline Summarize tools but getting this done in one tool will streamline a workflow.

When using the Alteryx email tool to send a text to a mobile device via carrier URL (i.e. xxxxxxxxx@vtxt.com) bad characters appear. This is due to the fact that the Alteryx email tool is sending in XML format and the carriers only accept HTML.

 

This was determined after working with the Alteryx support team to determine the root cause of that bad characters appearing on the mobile phone.

 

We are using an Alteryx workflow as an early warning system for technical issues to upper management. These advisories or alerts are being sent to mobile devices via email tool.

 

Regards,

Andrew Hooper

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

I superimposed multiple screens and multiple workflows and rendered them into a single image below. Have you noticed something?

 

Picture1.png

 

 There is a space never being used at all times, painted in yellow for emphasizing...

Picture2.png

 

 

Actually this is an enough space for ads Smiley Happy And we can make the designer for free...

Picture3.png

 

Though I suggest a better placement and use of the available screen space;

Picture4.png

 

 

 

 

 

As each version of Alteryx is rolled out, it would be much easier for our users and admin team to validate the new version, if Alteryx allowed parallel installs of many different versions of the software.

 

So - our team is currently on 11.3 - if we could roll out 11.5 in parallel then we could very easily allow users to revert to 11.3 if there are issues, or else remove 11.3 after 2-3 weeks if no issues.

The same goes for versions which are in BETA.

 

This would be a huge help!

 

cc: @avinashbonu ; @Deeksha ; @revathi

When saving a workflow to the gallery, the manage assets box is a fixed size. Due to the length of our file paths, the full path name is cut off. This makes it difficult when trying to package macros to select the correct box. I understand you can group assets by tool, however with the more complicated workflows this can still present it's challenges. I'd like to see this box to be re-sizeable.

Manage Assets Box.png

This is a pretty quick suggestion:

 

I think that there are a lot of formulas that would be easier to write and maintain if a SQL-style BETWEEN operator was available.

 

Essentially, you could turn this:

ToNumber([Postal Code]) > 1000 AND ToNumber([Postal Code]) < 2500

 

Into this:

ToNumber([Postal Code]) BETWEEN 1000 AND 2500


That way, if you later had to modify the ToNumber([Postal Code]), you only have to maintain it once.  Its both aesthetically pleasing and more maintainable!

This idea arose recently when working specifically with the Association Analysis tool, but I have a feeling that other predictive tools could benefit as well.  I was trying to run an association analysis for a large number of variables, but when I was investigating the output using the new interactive tools, I was presented with something similar to this:

 

CorrelationPlot.PNG

 

While the correlation plot draws your high to high associations, the user is unable to read the field names, and the tooltip only provides the correlation value rather than the fields with the value.  As such, I shifted my attention to the report output, which looked like this:

 

CorrelationTable.PNG

 

While I could now read everything, it made pulling out the insights much more difficult.  Wanting the best of both worlds, I decided to extract the correlation table from the R output and drop it into Tableau for a filterable, interactive version of the correlation matrix.  This turned out to be much easier said than done.  Because the R output comes in report form, I tried to use the report extract macros mentioned in this thread to pull out the actual values.  This was an issue due to the report formatting, so instead I cracked open the macro to extract the data directly from the R output.  To make a long story shorter, this ended up being problematic due to report formats, batch macro pathing, and an unidentifiable bug.  

 

In the end, it would be great if there was a “Data” output for reports from certain predictive tools that would benefit from further analysis. While the reports and interactive outputs are great for ingesting small model outputs, at times there is a need to extract the data itself for further analysis/visualization.  This is one example, as is the model coefficients from regression analyses that I have used in the past.  I know Dr. Dan created a model coefficients macro for the case of regression, but I have to imagine that there are other cases where the data is desired along with the report/interactive output.

 

Hello all,

 

When looking at the Results window, I often find it a headache to read the numeric results because of the lack of commas. I understand that incorporating commas into the data itself could make for some weird errors; however, would it be possible to toggle an option that displays all numeric fields with proper commas and right-aligned in the Results window? I am referring to using a display mask to make numeric fields look like they have the thousands separator while retaining numeric functionality (as opposed to converting the fields to strings). 

 

What do you think?

Alteryx Display Mask example.JPG

 

 

 

Currently - if someone has accidentally kept an excel file open on their desktop, Alteryx will fail to load this flow.

 

However, it would make more sense to open this file without read-lock as a dirty-read (equivalent of "Read Uncommtted").

This may require some interaction with Microsoft but would be worth pursuing because it prevents / eliminates an entire category of needless canvas errors.

Currently if one wants to compare different alteryx files or different versions of the same file - one needs to compare the XML files. If you are not very familiar with navigating XML, this poses a risk as one may not be able to identify all changes.

 

It would be a great addition to Alteryx to integrate Alteryx with Git, Subversion, CVS, Mercurial, and GitHub as this tool is becoming the go-to tool for data processing for data analysts and even programmers.

 

This additional functionality to compare previous versions (diff) and also to merge alteryx workflows if two people are working on the same workflow, and also to easily see what changes have been committed/ made by other developers and when would make Alteryx a much more powerful tool and would open doors to other types of users, as essentially you can run anything through Alteryx.

 

Hey Alteryx Community,

 

I think Alteryx uses the Tableau SDK to create tableau data extracts, TDE's. Since Tableau 10.3, there is functionality to connect to spatial files in Tableau (.shp). These shapefiles can be converted to an tableau data extract within Tableau. The tableau SDK has this functionality as well, but Alteryx does not support it yet. The suggestion is to add this functionality. See https://onlinehelp.tableau.com/current/api/sdk/en-us/SDK/tableau_sdk_samples.htm for the SDK link. 

 

Spatial TDE's are way smaller (3gb .shp went to 140mb TDE) and way faster.

 

 

Thanks,

Marco 

Working with @BenB we discovered that the time stamped on jobs in the logs on the server may be in different timezones depending on the worker's timezone.

 

This leads to odd behaviors where a job may appear to end before it starts because the controller stamps the start time, and the worker stamps the end time.

All times should be logged as UTC, taking into account the worker & controller's timezone - that way this issue will not occur.

 

cc: @avinashbonu ; @Deeksha ; @revathi

Although the connectivity to the eMail infrastructure is set up on the controller and worker nodes - there is no ability to set up automated alerting for errors on workflows from the server.

 

We would like to be able to set up the gallery as follows:

- Every job is owned by a user or a distribution list

- If that workflow throws an error or warning (this should be configurable on the server, whether warnings are included), then the author should be e-mailed with a link to the specific workflow and the error log.

 

This can be done in a round-about way, by running an error-reporting alteryx job after the fact - but this kind of alert needs to go out almost immediately given our dependance on Alteryx for specific SLAs.

 

cc: @avinashbonu ; @Deeksha ; @revathi

Top Starred Authors