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.
We need color coding in the SQL Editor Window for input tools. We are always having to pull our code out of there and copy it into a Teradata window so it is easier to ready/trouble shoot. This would save us some time and some hassle and would improve the Alteryx user experience. ( I think you've used a couple of my ideas already. This one is a good one too. )
This got me to think a little more about localized logging options in Alteryx.
At a high level, there are ways to accomplish this in Designer at a User or System level by enabling a Logging directory and then parsing those logs with a separate Alteryx job. However, this would involve logging ALL Designer executions, which seems like it may be overkill for this need. A user can also manually save a log after each execution, although this requires manual intervention.
I think adding an option in the Runtime settings for Workflow Configuration to Enable Logging and (optionally) specify a Logging directory would be a great feature add for Designer. In my opinion this should not apply once a workflow runs on Server (Server logging should be handled in a fully standardized way), but should apply to designer "UI" execution. Having the ability to add a logging naming convention (perhaps including a workflow name and run date in the log name) would be icing on the cake.
This would allow for a piecemeal logging solution to log specific flows or processes that might be high visiblity or high importance, while avoiding saving hundreds or thousands of logs daily of less important processes, and of dev test. It would also reduce or eliminate a manual process to save these logs individually.
Hi, i am from ETL back ground and coming from my knowledge i would like to suggest or ask a feature which will helpful in alteryx solution.
"Error Line" : many ETL tools provide an "On Error" line which performs certain actions like "altering user by sending an email", "ignoring and going to next step" etc. It will be great if Alteryx can provide the same feature where we can have an error line (red line) for each tool.
Hope this is not a repeated idea. thank you for all the support and providing a wonderful tool.
It would be nice to have the annotations that a user gives a tool with a different background color on the canvas than those tools where the annotation is being automatically populated. Example would be the user gives a tool a specific name that shows up in blue but the formula tools that display the formula preview under the tool show up in yellow.
When a process is running in foreground, the GUI does an excellent job of giving feedback to the user as to which "step" the job is running and how much data is processing through the active tools. When that same job is scheduled, the amount of information is limited to when the job began execution.
If a tool was able to give checkpoint status out to the user, we could better monitor the progress of scheduled jobs. The visibility to the job is most important for long running jobs. We've unfortunately had instances where we have had to cancel jobs and to restart them not knowing how close or how far from finishing they were.
I have several modules that need to run in sequence. Can a ksh or some other program be used to string the modules together?
So that if I have Step1.yxmd, Step2.yxmd and Step3.yxmd. 2 is dependent on 1, 3 is dependent on 2. I want to tell it the jobs to run and then to wait until that module completes, then run the next.
run Step1.yxmd Wait
run Step2.yxmd Wait
run Step3.yxmd Wait
Or, if I have a group of modules that can run concurrently but subsequent jobs are dependent on all of them to finish, i can let all those jobs run and have the next step wait for those to complete to begin.
run Step1A.yxmd run Step1B.yxmd run Step1C.yxmd run Step1D.yxmd Wait
run Step2.yxmd Wait
run Step3.yxmd Wait
I know this is very simplistic, but hoping it shows the need. Also, we do have the scheduler set up to use, so if there is a way to set dependencies between modules within Scheduler, that might be helpful. Just haven't found anything.
Add an option to cancel an occurrence currently queued to run without it removing, or completing, the original schedule. Not sure if this is by design or a bug but when you cancel a workflow that's in queue, it sets the scheduled workflow to "Completed" even though you just wanted to stop that occurrence and still keep the workflow schedule “Active”.
Also, adding an option to PAUSE a scheduled module. This is useful when you need to temporarily suspend a workflow from running, but save the hassle of re-configuring the schedule when you want to turn it back on.
I would like the ablity to view the processing order of tools within module prior to processing and if needed reprioratize which tool processes first/last. It would also be great to have the ablity to disable a subset of tools within a module prior to processing.
Create a new module that outputs statistics after processing. For instance creating a table of all used modules by reference number with fields for records input, records output, processing time, processor load, memory used. As well as starttime, endtime, username, hostname, etc. This would make debugging quite a bit easier, expecially if the results could be output to Excel.
While Alteryx is processing it displays information in the module with record/file infromatoin. Once processing is complete this information is gone, except for in the output window. Could you add a key combination or button toggle to redisplay this info from the prior run. It would be very helpful for debugging.
I have the Show Properties Window selected, but it is not showing up on my screen. At first I thought it was just hidden and that I could just pull it back from being hidden, but I can't find it anywhere.
I am getting error ORA-00001 Unique Constraint Violated for any error when updating my Oracle table.
Specifically, my workflow's output tool Output Options is "Update, Insert if new" so I should never get an ORA-00001 error. If the record exists, it should be updated, if it does not exist, it should be inserted. The update happens most of the time, however when the update fails, the actual error my database is raising is an ORA-20001 error with a custom error message that I want to pass all the way back to the person reading the workflow log. When I run an update in the database I receive the correct error: ORA-20001: No overrides to Sales allowed on data in closed periods. INVOICE_NBR=12345. But the error Alteryx is presenting my user is: Error: MyWorkflow_output: DataWrap2OCI:endBatch: ORA-00001: unique constraint (MY_SCHEMA.MY_TABLE_PK) violated.
Am I misinterpreting the error in Designer or is the incorrect error being presented to me?
One of the biggest and most impactful changes would be support for detailed unit testing for a canvas - this could work much like it does in Visual Studio:
In order to fully test a workflow - you need 3 things:
Ability to replace the inputs with test data
Ability to inspect any exceptions or errors thrown by the canvas
Ability to compare the results to expectation
To do this:
Create a second tab behind a canvas which is a Testing view of the canvas which allows you to define tests. Each test contains values for one or more of the inputs; expected exceptions / errors; and expected outputs
Alteryx then needs to run each of these tests one by 1 - and for each test:
Replace the data inputs with the defined test input.
Check for, and trap errors generated by Alteryx
Compare the output
Generate a test score (pass or fail against each test case)
This would allow:
Each workflow / canvas to carry its own test cases
Automated regression testing overnight for every tool and canvas
For this canvas - there are 2 inputs; and one output.
Each test case would define:
Test rows to push into input 1
Test rows to push into input 2
any errors we're expecting
The expected output of the browse tool
This would make Alteryx SUPER robust and allow people to really test every canvas in an incredibly tight way!
Noticed an issue in the Browse tools, specifically if you’ve run a module once, where browse tools are displaying information, and then you add new browse tools into the process (without clicking run yet). What I’m seeing is if I’m looking at the “existing” Browse that is showing data, and then click directly onto a Browse tool that was added after the run (not remembering I just added it), the “new” Browse tool is showing the previous Browse tools info, I literally have to click on the canvas, and then back to the new Browse tool for Alteryx to recognized there isn’t any data to display in it yet. My point being it can be misleading to the user if they don’t recognize the wrong info is being displayed (because as you click back & forth between the two, the data stays the same, making the user think the issue is in the process rather than just the display, can waste a lot of time backtracking for no reason). I’ve seen this behavior over at least the past 3 engine updates, just FYI.