This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!
Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesThis is a QoL-request, and I love me some QoL-updates!
While I'm developing I often need the output of a workflow as input for the next phase of my development. For example: an API run returns job location, status, and authentication ids. I want to use these in a new workflow to start experimenting what'll work best. Because of the experimenting part, I always do this in a new workflow and not cache and continue in my main flow.
Writing a temporary output file always feels like unnescesary steps, and tbh I don't want to write a file for a step that'll be gone before it reaches production. Esp if there is sensitive information in it.
Thanks.
I surprisingly couldn't find this anywhere else as I know it's been discussed in person on many occasions.
Basically the Formula tool needs to be smarter in many ways, but this particular post focuses on the Data Type component.
The formula tool, should not always default to V_String as the data type when entering data or a formula into the formula tool, it should look at the data type and estimate the most likely option.
I know there are times where the logical type might not be consistent in all fields, but the Data Preview and the Function of the formula should be used to determine the most likely option.
E.G. If I type a number or a date directly into the formula tool, then Alteryx should be smart enough to change the data type from the standard V_String to Int, Double or date.
This is an extension to the ideas posted here:
I often need to create a record ID that automatically increments but grouped by a specific field. I currently do it using the Multi-Row Formula tool doing [Field-1:ID]+1 because there is no group by option in the Record ID tool.
Also, sometimes I need to start at 0 but the Multi-Row Formula tool doesn't allow this so I have to use a Formula tool right after to subtract 1.
So adding a group by option to the Record ID tool would allow the user not to use the multi-row formula to do this and to start at any value wanted.
We have 'CountDistinct' and 'Concatenate' options within Summarize tool.
But 'Concatenate' displays all the instances of value for a Grouped field, this might include lot of duplicates.
It would be great to have an option like 'ConcatDistinct'.
For example -
Group by 'Branch' and 'ConcatDistinct' Customer should result as Figure 1 instead of Figure 2 -
Figure 1-
Figure 2-
While this is achievable in different ways currently with a set of tools, but it gets tedious when number of fields is large from which distinct values are to be captured.
Thank you,
Rohan.
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
Please add ablity to globally, within a module, forget all missing fields.
When creating a workflow I generally open a "TEMPLATE" first and then immediately save it to the "NEW WORKFLOW NAME". My template includes all my preferences that aren't set naturally within the user settings and won't get RESET by them either. It has a comment box and containers as well as logos and copyrights. It would be nice to have ready access to this feature. Maybe others have standards that they want applied to all users and their workflows too.
Thanks,
Mark
The more python and R development I do the more I want to use the shortcutes [CTRL] + [ENTER] to run my workflow,
Is it possible to add this as a second way to run the workflow?
I'm thinking its going to have to have a new shortcut anyways with cloud as [CTRL] + [R] would refresh the page! :D
Asking for a friend :D
Hi there Alteryx team,
When we load data from raw files into a SQL table - we use this pattern in almost every single loader because the "Update, insert if new" functionality is so slow; it cannot take advantage of SSVB; it does not do deletes; and it doesn't check for changes in the data so your history tables get polluted with updates that are not real updates.
This pattern below addresses these concerns as follows:
- You explicitly separate out the inserts by comparing to the current table; and use SSVB on the connection - thereby maximizing the speed
- The ones that don't exist - you delete, and allow the history table to keep the history.
- Finally - the rows that exist in both source and target are checked for data changes and only updated if one or more fields have changed.
Given how commonly we have to do this (on almost EVERY data pipe from files into our database) - could we look at making an Incremental Update tool in Alteryx to make this easier? This is a common functionality in other ETL platforms, and this would be a great addition to Alteryx.
I was looking at the ideas history to see if this was already posted and couldn't find it, but feel free to merge if there is a existing one.
The motivation for this is that I have a workflow that works perfectly when you hit the run button in Designer, but fails when runs from schedule (To local computer).
So the idea is to allow the users to run the workflows from within the scheduler, once a workflow has been scheduled (So it runs exactly as it'll be when the schedule triggers it, but without having to reschedule every time).
Correct me if I'm wrong, but wasn't this possible in old (I mean very old) versions of Designer?
There is no way to natively connect to Xero. We also cannot use the download tool to connect to the API as it requires an OAuth2 Bearer Token generation step. Documentation for Xero can be found here: https://developer.xero.com/documentation/
I would request a tool similar to the Salesforce Input tool to be created.
Suggested process:
I would also request that this tool be developed so that it can run on Server and Analytics Hub so that we can run end to end automation.
To enable a check mark kind of option to lock or edit the configuration window of each tool.
It could be very useful to keep safe the settings in the configuration window.
Shopify is a popular software for e-commerce. With Shopify Connector in Alteryx, it will be very helpful for Alteryx users to integrate with Shopify.
There is no way to natively connect to Microsoft Dynamics 365 F&O. We also cannot use the download tool to connect to the API as it requires an OAuth2 Bearer Token generation step. Documentation can be found here: https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v1.0/
I would request a tool similar to the Salesforce Input tool to be created.
Suggested process:
I would also request that this tool be developed so that it can run on Server and Analytics Hub so that we can run end to end automation.
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.
It would be great to dynamic update the next Analytic App based on an interface input. This mean I have a chained app. In Step 1 I ask a Yes/No Question. The Answer to this question will determine to open in Step 2 Analytic App A (with it's own interface Inputs) or Analytic App B (with other interface inputs).
Many users are facing this issue when they want to create an tool (e.g. for mapping purposes) that contains two datastreams/flows with different interface input requirements.
Adding this feature would allow us to create different dataflows with different input requirements. This helps us to differentiate between different mappingsschemes and increases userexperience (currently they have to fill a lot of unnecessary interface inputs). Thanks.
H.
Hi Team,
This is very helpful if you add the run and stop option in scheduled workflow for Alteryx designer desktop automation. There is no option of pausing the workflow. this idea should be implemented that will make life easy who are running n- number of workflows.
Thanks,
Kaustubh
FILE==>Open Recent==>
(add the ability to Pin Favorite Workflows)
The Pinned workflows will persist at the top of your recent files each time you open your Alteryx Designer Application.
Provide Desktop Automation with Workflow REST API to have the ability to start workflows from other corporate systems without expensive Server license in a small environment.
Using Email tool, you are not able to send email via SMTP server that uses STARTTLS protocol and self-signed certificate for completing the handshake between the client and the server. You face an error:
This is due to the fact that the Alteryx Designer SMTP client uses cURL and it does not read the Microsoft cert store, but instead looks at a specific .pem file listed in the installation directory: {AlteryxInstall}\bin\RuntimeData\Certificates\cacert.pem
I would really appreciate if Alteryx Designer will be able to look into the Microsoft certificates store so that it should be able to use self-signed certificates available there.
Self-signed certificates are often use in the companies in order to get more secures their own communications.
Thanks
please refer to the case #00447188 for more details
The ARIMA tool provides a ton of valuable information with just a small amount of effort. And the "I" anchor efficiently outputs test results to evaluate the effectiveness of the model.
Annoyingly, in the Browse tool off the "I" anchor, test definitions such as MPE/MAPE/MASE cannot be read when hovering without widening the Configuration window beyond the chart above. Definitions have a wider range than the chart itself. The user has to manually widen and then subsequently unwiden the Configuration window to read.
Idea would be for the tooltips when hovering to be as wide as the chart above. That would avoid repetitive resizing of the Configuration window.
The Data Preview of the Formula Tool is SO helpful !
Make it better by allowing preview on other rows than the first
User | Likes Count |
---|---|
27 | |
21 | |
17 | |
12 | |
12 |