I've seen various solutions/workarounds but this seems to be a table-stakes ask? When scheduling a workflow I should be able to specify which parameter values to run with. Just two of many use case examples -
Use case #1 - a single analytic app could be scheduled multiple times, each schedule specifying a different line of business
Use case #2 - credentials, allow the user to schedule a workflow with their saved credentials. When their credentials change all they would have to do is update the schedule parameters
(If you know a better way I'm all ears, not the API thought that isn't a bad way to do it, just not super Easy)
I would like to see the enhancement of being able to schedule a start and stop time for specific jobs that need to run multiple times per day, so they don't run during the nightly backup periods of the Alteryx server. This can cause the daily backups of the Alteryx Gallery to fail. Currently SQL Server Management Studio/SQL Server has the function to able to schedule start and stop times for specific job. Currently Scheduler page on Alteryx Gallery/Server lacks this feature.
SQL Server Management Studio
Schedules on Alteryx Gallery/Server
Using current version of the server - you can see that there is no OAuth managed or published API endpoint for canvas delete (screenshot 1). However this API does CLEARLY exist as you can see if you inspect what happens when you hit the delete button (screenshot 2 clearly shows the API being called - but it requires user login security token)
Please can you enable this API for OAuth - the API already exists, it just needs to be exposed with the others.
I would like to set a retry count when scheduling a job, and also to specify to duration in between retries, e.g. job fails, but then will retry to run 3 times with a 5 minute wait in between each retry.
Also would like a radio button next to all workflow results, so when you get a list of failed jobs you can click all the jobs and then hit rerun. This should be complimented with select all functionality. This will prevent me from having to go into each job and rerunning, i.e. save me loadsa clicks!
Currently, to allow a user to schedule jobs, prioritize jobs, assign jobs, create collections, or have API access, toggles must be set at the user level.
As a server administrator, I want to configure these toggles at the group level, so that a) I don't have to modify a large number of users individually to grant them such permissions, b) I ensure consistency across groups of users that doesn't rely on humans clicking all the right things for each of the relevant people, and c) I can easily change these settings for multiple people, if needed.
As a large company we have many controls we have to adhere to. One of those being Python libraries we are allowed to use internally. We are requesting that Alteryx document all Python libraries within the tool as well as if they are fundamental to running Alteryx Server (Or Designer as most time these are same) and even what functionality they may play in the tool. This way, we would be able to remove these unallowed libraries from our Server if needed or at least know functionality and if it is needed.
As an Alteryx Admin, we have too many users to maintain the Data Connections for every connection that every user has. A nice add to the collections ability is to create and share Data Connections among users of only that Collection. Managed by the Collection Admin(s), they would be able to manage their own credentials and connection strings for their team and project.
If two users sit in the same studio and have multiple scheduled workflows in that studio, both users can see the results of those schedules under "Workflow Results" -> "My Jobs"/"Jobs Shared with Me"
It gives both users in the studio good visibility of all the workflow results they have access to.
Now if we move to a 1 studio-1 user environment and share workflows and schedules via collections, this "Workflow Results" -> "Jobs Shared with Me" functionality is empty. Instead users have to go to each schedule individually to see the results from them there.
So if you're in a 1 studio-many users environment, there is a single place to go to see all workflow results. But if you're in a 1 studio-1 user environment and sharing via collections, you have to go to infinitely many places to see the results of all the schedules shared with you.
So my idea is to have results from schedules shared via collections appear in Workflow Results.
As Alteryx Admin, we want to understand what our users are doing in their workflows as much as possible to ensure best user experience. In order to do this we would like to scan through User workflow XML in order to breakdown everything going on. We understand that their are many posts on workflows already doing a lot of this but:
Our Ask: is to release XML DTD or similar documentation that can help us breakdown workflows at individual tool levels (as well as differences between tool versions)
This would allow us to further build out solutions to admin visibility of user workflows.
The Pop up window for Browser tool currently is working in the App environment but not working in the Gallery environment. It is essential when you want to show user the immediate results. there will be too much efforts for user to see the results if I use output/render tool.
We would like Gallery admins to be able to add any workflow to a collection - not just the workflows they authored.
The purpose is to have one collection where we have a set of workflows that were reviewed and approved for audits.
Only the reviewer could add to this collection
Currently, only Gallery administrators can create credentials on the Gallery. But this doesn't seem to make sense because publishing users may need to embed their credentials in workflows. And they would benefit from managing these on server so that password changes don't require re-publishing large numbers of workflows. Please allow any user to create and manage credentials on the Gallery.
It would be great if you could overwrite an existing workflow when saving to the gallery from designer. It could be a simple popup with a yes/no option to overwrite/save a new copy. Currently, you would have to
1) Save your workflow to the Gallery.
2) Click on ok and be taken to that workflow.
3) Go back to your private studio.
4) Search for the app you want to replace.
5) Realize you have 7 copies of the same workflow with the same name and try to determine which one you want to replace. (this could just be a "me" problem)
6) Select that app
7) Click on replace workflow.
😎 type the name of the workflow in the box.
9) Look through your list of 7 workflows and choose the one that was just uploaded. Usually the first in the list I think.
10) Lament that it took way too many steps.
I recognize that you can open workflows from the gallery in designer which does allow overwriting, but I've run into issues with 1) external dependencies not working as expected (ie packaged assets don't quite work the way I want) and 2) about half the time it will simply give you root errors and then your only option is to save to a folder and then go through the process above.
It appears that every time we have a talk about the gallery organization, people bugs around the difference between district and collection. Adopting a new semantic with less confusion would lead to
: -a more intuitive product for everyday life
-less question and less confusion during pre-sales/POC/Training.
I was recently hired by a fortune 500 company to eliminate use of their Access DB's by replacing them with Alteryx solutions. My first step is to understand the old DB's so I know what type of workflow to build. I'd love to have an ERD tool built in Alteryx to drop right after the input data tool. The closest I've found is the Network Analysis tool, but I don't see that giving me the desired output.
I would like to see how tables are connected, what manipulations are being done, when a query/view/macro was last used, what outputs being delivered.
We would like a built-in process that would search or, and resolve, workflows that are stuck in the "initializing" state. These seem to happen for various reasons but communication problems between the controller and workers .. usually a socket timeout.. which appears to be most problematic. It seems that these type of errors should be expected in all but the most stable environments,
Currently, the only tool that we have to solve this problem is to restart the Alteryx Service on the controller and while this works there tendency to cause some collateral damage in workflows ...erroring or restarting from their beginning.
There may be a way to solve this without restarting the service by editing Mongo using a tool like Robo 3T but that is unproven and has its own risk.
After dealing with this issue and struggling for quiet some time we think that the best option is to implement a "clean up" DB process that will run every 5 min or so, capture a list of workflows in the "initializing" state , then compare that list to one in the next 5 min cycle and fix any workflows that appear in both lists. We think that returning any stuck workflows to the queued state would be the best Fix option.
We just don't want to continue to use Restart the Service process to solve this issue and accept the collateral damage.
Thank you for your consideration
This may be a little controversial. As of today, when you buy an Alteryx Server, the basic package covers up to 4 cores :
I have always known that. But these last years, the technology, the world has evolved. Especially the number of cores in a server. As an example, AMD Epyc CPU for server begin at 8 cores :
So the idea is to update the number of cores in initial package for 8 or even 16 cores. It would :
-make Alteryx more competitive
-cost only very few money
-end some user frustration
Moreover, Alteryx Server Additional Capacity license should be 4 cores.
I am in the process of migrating apps from the old gallery to the new. I have screen captures of the results from the same app in both. In the older gallery version, if there is only a single file type available, it defaults to that file type and you click the icon for the type. In the new gallery version, you must select a file type before you can download the file, even if there is only a single type available. The dropdown makes sense for one that you have multiple types (like pcxml), but it makes no sense to require the user to go through an extra step to select a type before downloading when that's the only type they can download. Please see all the screen captures. The blue-ish background is from the new gallery.
I’m facing issues with scheduling workflow in Europe/London timing. I’m trying to schedule jobs to run at 10pm UK hours everyday (except Fri and Sat) starting from today i.e. 26th Jan (as per UK timing)
However since I’m in India and my local desktop is showing India time (which is 00:15hrs on 27th Jan), the Alteryx Gallery scheduler is picking India hours but not as per the region we selected. The 26th Jan date is greyed out and unable to select.
The workaround for this to change local time on desktop which is not in our control in our case.
Could you please bring a change in this behavior. If I am am scheduling on x date a workflow for a timezone which is x-1 the scheduler should allow me to set up the schedule.
In prior versions, Gallery Admins could easily and quickly reactivate users that were deactivated (e.g., and employee leaves the company so we inactivate their Gallery account, but then they come back to the company in a few months with the same name and email).
Now, the only way to do this is to edit the Mongo page.
We need a way via the UI to reactivate users, like we did in the old UI.
I suggest adding an option in the current User List/Grid to be able to filter for Inactive users.
I think it would be extremely useful to be able to trigger an Alteryx workflow using Power Automate.
The main benefit I see at the moment is automatically triggering an Alteryx workflow when the input data has been refreshed.
This would also enable a Power App to be added directly to Power Bi which can simply be clicked to re-run an Alteryx workflow then refresh the Power Bi dataset.
It would be helpful if there was a way to setup notifications so that it would email Admin whenever a workflow runs longer than a preset amount of time.
Admin would set time threshold for triggering notification i.e. > 15min and Alteryx Server would email Admin whenever a workflow runs longer than that so that they could monitor this specific workflow and take corrective action,