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 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?
Our company is loving the Insight's Tool, but I am constantly being asked by users if they can export the data behind the graphs that is feeding in. For example we have an inventory dashboard for vehicles that starts at a Corporate level, but is drillable down to a "Regional" and then even more focused "Managed Area" level. Once users get down to the "Managed Area" level they want to export the line level data that is feeding into the Insight chart to actually view, work, and action the data at a vehicle level.
Essentially an option to export the data feeding into the graphs.
Use case: Person running app to select folder from limited list similar to how the tree tool allows for a user to select one or more files. This selected folder would then be connected via an Action tool to a Directory tool (or by adding a formula tool to a Dynamic Input). The Folder Browse Interface does not have the ability to restrict or provide a starting parent folder. The app below pulls data from SharePoint site, which cannot be easily browsed to. Currently I have the user select a file in the required folder, then use RegEx parse and a Formula tool to pull in all requested files from that folder. It would be a better user interface if the user selected a folder. A test sample of the workflow is attached (final version ends in an Alteryx database this is picked up in a chained app).
Working with the Alteryx Insight tool there are a few functionality features our team believes would be quite useful:
-When you have multiple charts within an Insight the ability to "Drill Out" of an individual graphs versus having to "reset" the entire dashboard would be incredibly useful and save a lot of time
-When drilling into graphs we have found users often forget what particular category they drilled into leading to them having to reset the entire dashboard and start over. Could a "legend" type area be added to drill able graphs to show the user what they have drilled into?
-The ability to "select all" or "de-select all" options in a filter on the right hand side of the Insight
-The ability to drill into your graphs when in the Design Mode or "Configure Insight" to see how any formatting changes impact all layers of your graph once you begin to drill versus having to switch over to Preview Mode and test all layers and then switch back to Design Mode to make necessary changes
-The ability to adjust formatting on individual layers of a drilled graph. For example on the x-axis of your first layer have labels set at font size 10 with no angle, but then on your second layer once you drill have the x-axis font size adjusted to font size of 6 at 45 degree angle in the case where your data labels are longer once you drill
We need an option to schedule a continuous bi-weekly payroll workflow. It is every two weeks starting on a certain day of a week. Some months have 3 and other have 2. If we had an option to select the starting day in a particular month and then select bi-weekly bullet (or every 2 weeks) from that date it would be perfect. thanks
When we create new workflows, we like to have them in our company template, to stnadardise documentation. This makes it easier for a supervisor to review, and for a colleague to pick up the workflow and understand what is going on. For instance, we have all data input on the left, and all error checks and workflow validation on the right, and a section at the top with the workflow name, project name, purpose etc. We have a workflow that we use as a template with containers, boxes and images all in the appropriate places
It would be great if there was an option to select a workflow as a template. When a new workflow is opened, it would load this template rather than having a blank canvas.
Since we know Alteryx uses R for a lot of its predictive and data analysis tools. It takes a while to run the workflow whenever there is R based tool is involved. I was told by a solution engineer that its because its opening and closing R in the background.
Sometimes my workflow has a bunch of tools which are running R in the background and it takes forever to run the workflow.
I think there should be a user setting which allows user to choose if the want to start R along with Alteryx and keep it running in the background.
My organization is considering a move to a Microsoft Azure platform but requires support for Bring your Own Encryption (BYOE) or Bring Your Own Key (BYOK). As such, leveraging alteryx on this data lake would require this level of support.
I would like to see Alteryx support this in the future, ensuring that we are able to leverage the power of alteryx designer within this platform.
The older versions of the Publish to Tableau Server Macro had an option to Request an authentication token however the latest version does not. Please return this option to the tool as it is very useful for constructing Rest API call scripts.
Please allow a hover over that would show you the value of a variable in the formula tool. At times I get long formulas and it would be nice to see the values of each variable by just putting your mouse on top of it. Just show the first row like the preview. There is similar functionality in visual studio and it makes coding easier.
When I click on existing Comment Boxes out in the Workflow I'd like to be able to tack on additional information within the Comment box.
If I hit Enter, I'm not able to type anything in the Comment Box. I think Enter is taking me out of the Box. If I hit the space bar, I'm able to type - but a lot of times I'm updating info and I want to start it on a new line.
Yes, I know it works fine in the Configuration Window.
Can we make the actual Comment Box work like the Text Window in Configuration?
In the Select tool, it would be very helpful, particularly with tables with lots of columns, to show the number of columns showing and the number of columns selected. This would help accounting for all columns when having to split up a table's columns for different kinds of operations before joining them back together again.
Typically I drag tools from the tool pallet to my workflow. Sometimes, when I need to insert a tool into my workflow, I will right click to get the Insert tool dialog to find the tool I want to insert between two existing tools. With the new UI, it is hard to see the tool categories as these were redesigned for the darker back ground. The preparation category is sandwiched between 3 other categories that start with "P" and I typically lean on the color/shape of the tool icon to find what I'm looking for. Now I have to read the text to really know for sure.
Perhaps you could lightly shade the middle of the tool category icons to make them easier to see or perhaps make the background behind the tool categories match the new toolbar color.
Tool categories icons are hard to distinguish since they are now just light colored outlines on a light background.