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.
Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.
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
Whilst the "Disable All Tools that Write Output" option within the Runtime Settings in Designer is useful.
I think a Workflow "Live" status / indicator could be really useful?
One key thing we have to seriously remind people whenever they start using Designer, especially when they are potentially picking up a workflow that some else has built is to sternly remind them that they need to understand the workflow outputs properly before pushing the run button!
One thing we do to get this message across is to demo the disable outputs option.
What would be better is to have some kind of interface / visual similar to the browse tool visuals that are created. But within the canvas / workflow / runtime config window?
This would instantly draw users attention to the fact that the workflow is connected to live outputs and that they should proceed with caution / turn off outputs etc.
So lets say I have five incoming connection. SQL, Redshift, Excel...whatever. I know I can right click, or control-right click on each incoming connection and select cache and run workflow. I'd imagine there would be a run and cache all incoming connections but there isn't. I realize I can arrange all incoming connections so they arrange easily so I can box them all, but on complex workflows, this might get complicated.
Hello - the added feature to show the designer tool detail of the four highly used tools (Join, Formula, Filter, and Summarize tool) is an incredible addition to Connect functionality. Can this functionality expand to the In-DB version of the same tools? We leverage In-DB when possible to utilize the processing power of the database. Adding this as well to Connect would be a huge benefit to see the complete picture of a workflow.