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.
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.
It would be useful if enhancements could be made to the Sharepoint Input tool to support SSO. In my organisation we host a lot of collaborative work on SharePoints protected by ADFS authentication and directly pulling data from them is not supported with the SharePoint input tool, it is blocked. The addition of this feature to enable it to recognise logins would be very useful.
Please extend the Workflow Dependencies functionality to include dependencies of used macros in the worflow too. Currenctly macros are simply marked as dependencies by themselves, but the underlying dependencies (e.g. data sources) of these macros are not included.
We have a large ETL process developed with Alteryx that applies several layers of custom and complex macros and several data sources referenced using aliases. Currently the process is deployed locally (non-server) and executed ad-hoc, but will be moved to the server platform at some point.
Recently I had to prep an employee for running the process. This requires creating aliases and associated connections and making sure that access to needed network locations is in place (storing macros, temp files, etc.). Hence I needed to identify all aliases and components/macros used. As everything is wrapped nicely by a single workflow, I hoped that the workflow dependencies functionality would cover dependencies in the macro nodes within, but unfortunately it didn't and I had to look through the dependencies of 10-15 macros.
Since the tool is trying to connect to the target email server to deliver the messages, you are at the mercy of the target server accepting the connection hence it will always be a hit or miss process.
In my case:
So there is no solution for me, because our smtp server need always an authenticated (user, password) and our IP is dynamicly.
For me it would be nessasarythe Email Tool in Alteryx allow authenticated setting when setting the tool to no Autodetect SMTP. But that is not implemented. My be it is possible in the future. So I must wait!
I can not use the Email Tool as an error-free solution.
In order to perform audit-trail logging - it would be valuable to have 2 new capabilities
a) environment variables which show the workflow name; filepath; version; run start date and time; etc. For any worklows we build, we need to have a solid audit trail to be SOX compliant, so having this detail available as a data field to write and manipulate is essential
b) A logging component. What would be great is a component that you can drop on a workflow, not connected to anything, which is able to trap the start; end; runtime; version; etc of a workflow; and commit this to any output data format (CSV or ODBC etc). This logging tool would need to be able to capture the full runtime, so it would need to be the last thing that runs (which means it may need to exist in parallel to the main workflow in some way). This is not currently possible with a complex workflow with outputs, because it's not possible to identify when the entire workflow ended; or the runtime (since output tools don't have an onward connector to pass flow-of-control to catch the final end-time)
Again, both of these are necessary to meet audit requirements for workflows and prodcution-quality ETLs for BI data warehouses.
I was wondering if any of you have achieved "Transaction rollback" type of feature in alteryx.
Following is the usecase:
If a workflow that writes data into multiple outputs (could be relational tables / files) is failed half way through in writing to one of the outputs, is there an option to rollback the partially loaded data & reset the process to the original state (i.e., before the execution of the workflow)? (OR) does this needs to be done programatically?
There is a workflow level property - "Cancel Running Workflow on Error". This stops the execution but doesn't perform rollback.
Many times; ideas for new ways to use Alteryx come to me while I'm not at work.
Most of the time that happens, I can use RDP via VPN to get to my work desktop.
But sometimes it isn't easy to do that. Like when I'm driving, outside for a run, in the shower.. you get the idea.
My point is that there should be a mobile app for Designer (iPads and Android tablets). The mobile app wouldn't necessarily need to be connected to the actual sources live (maybe require a template used for input for ODBC; but allow connections to HTTP/FTP/local sources).
The user would design the workflow, and then have the option to email the schema to themselves (or others) so that once back at work, one could pick up where they left off.
Although I would prefer to use it on an iPad, it could technically be used on an iPhone as well.
For an example of how that could look, see the iOS app "Workflow". That, in combination with the now defunct "Schemes" was a great way to do visual programming similar to what we do in Alteryx.
I have a process that sends out about 1,500 emails. Every once in a while, it will get stuck at some Percentage and I will have to eventually cancel the workflow, figure out how many emails were sent, and then skip that many emails in order to avoid sending duplicate emails. The process of figuring out how many were sent is currently taking the % of the tool at cancellation minus 50%(since that is where it starts), Multiplying it by 2, and then multiplying that % by the number of lines to get the approximate line of data where it froze up, and then reaching out to individuals to see if they received the email to narrow down exactly where the error occurred.
Example: 60% - 50%= 10% * 2 = 20% * 1249 = 249.8.
This has been pretty accurate in the past, but obviously is not ideal. Is there no way for it to show us how many were sent even if we cancelled the workflow mid processing of the tool?
I asked this before. WHY DO WE HAVE TO HAVE A POP UP WINDOW OPEN UP EVERY TIME WE RUN ALTERYX?! I asked this before, and the comment was made, "there is a check box to turn it off in the settings." Yes, that is true, there is a checkbox! And guess what, to my surprise (insert sarcasm here), IT DOESNT WORK! THE MOST BASIC, EASIEST THING YOU CANT GET RIGHT, and that is EXTREMELY ANNOYING.
Just LOST THE INTRO WINDOW. WE ALL KNOW ITS ALTERYX WHEN WE OPEN IT, DO YOU NEED THAT MUCH MORE ADULATION THAT I HAVE TO CLOSE A WINDOW THAT REMINDS ME THAT I AM USING ALTERYX?!?! Maybe I should send an email to alteryx to remind them I am using their product, will you feel even more important then? Pardon that slam here in my nastygram, but this is JUST AMATEUR!
A multi billion dollar company, and youre wasting effort with this. GEEZUZ