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.
A partition is a division of a logical database or its constituent elements into distinct independent parts. Database partitioning is normally done for manageability, performance or availability reasons, or for load balancing. It is popular in distributed database management systems, where each partition may be spread over multiple nodes, with users at the node performing local transactions on the partition. This increases performance for sites that have regular transactions involving certain views of data, whilst maintaining availability and security.
Well, basically, you split your table in several parts, according to a field. it's very useful in term of performance when your workflows are in delta or when all your queries are based on a date. (e.g. : my table helps me to follow my sales month by month, I partition my table by month).
So the idea is to support that in Alteryx, it will add a good value, especially in In-DB workflows.
Report text tools currently only give the option to allign left, right or center. Would be great if we could have the option to have a true 'Justify' option also as it makes chunks of text look so much cleaner
My team uses a shared macro repository (say F:\AlteryxMacros), and we recently ran into an issue with the default save location for macros. While we save most macros to our repository, there are times when folks save their macros elsewhere (let's say C:\MyAwesomeWorkflow). The issue we've encountered is that if you go to file >> save as with a macro, it will ALWAYS default to the macro repository, even when my macro is currently saved elsewhere (C:\MyAwesomeWorkflow). Speaking for a friend, people have accidentally saved things to the macro repository by accident. Or, they waste time navigating from the macro repository to the their current folder.
If a macro is saved somewhere, please change the file >> save as to default to the current folder. Thanks!
I built some workflows which will input full or sample data in multiple Input Data tools based on changing the value of a user constant. These workflows have email events enabled after run.I want to change the email subject based on whether the workflow ran in full or sample mode. That's my use case. I know that I could do this using the Email tool and that's not going to work in my use case. If the workflow fails, there won't be an email. Also, I don't know if the Email tool is blocked by just my Gallery or by all Galleries.
To generalise this, I want to dynamically change email event subjects, bodies, and more by either using expressions/constants from the workflow or by having an expression editor directly in the event itself.
The option to open Hyper files in 2019.4 is great! For some of our use cases it would be even better, if we would be able to directly open Hyper files that have been published to Tableau Server.
It should be possible to achieve this by combining the Tableau REST API method Download Data Source, which returns a Tableau Packaged Data Source (.tdsx), which then would need to be converted to a Zip file to be able to navigate to the contained Hyper file.
That said, one of the great features of mapbox is the ability to customize your own map layers.
It would be great if this was an option to use a custom map as the alteryx reference map similar to what is available within tableau. We in our organization have several custom map styles built with mapbox and I'd love to use them as a reference in the report map tool, or any other scenario where maps become useful.
In instances where many tools need to be connected to one tool, I think a "Connect All" type of function might be useful.
For example if you had 4 threads of data that all ended in a select tool and needed to be connected to a Join Multiple tool, you could grab all of the select tools and the Join Multiple tool, right click, and then select "Connect All" which would connect each select tool to the Join Multiple tool.
I think this could be implemented a few ways:
1) Right-click and select action
2) Keyboard shortcut
3) Holding shift on a selection of origin tools and then clicking on the shared destination tool
I've added a screenshot of a quick Photoshop representation of this idea.
I love this tool, but think it would be improved by including an option to create a column per delimiting character. This could be added in the number of columns selector box. In the case where 1 row has more delimiters than another, null columns can be created. Without this option you have to Regex count the delimiters, select the max and then embed the Text to columns tools in a macro and then pass the max columns as a param. Would be nice to resolve all this in the main tool.
I suggest that it would be beneficial to add in a column filter that can automatically remove columns based on a condition, such as removing columns where all values are NULL or if they contain something in the values.
Should have a True and False output, like the normal Filter tool, so you can check what is being removed.
e.g. Would help with when you get poorly formatted excel sheets that add in hundreds of redundant columns, or if your workflow has generated NULL columns that should be removed, without having to Transpose, Filter, Cross tab etc to clear them out.
Dummy/garbage text is required in the "Write to file or database" field to be able to write files from fullpaths using the "Take File Table name from field" check box and dropdown (also horrible UX/UI IMO). Without which you get a uninformative "Cannot access the folder" error message.
This isn't obvious and makes no sense and should not be required. The User experience here is very unintuitive, can you review this component?
It will be great if we have a round down or round up function just like excel in Alteryx. I know we can use the left function after converting the number to string, but it becomes difficult when the decimal value is huge.
I love the ability to setup the UI with the different windows (results, config etc) in the places that I want. However, once I have them setup I generally don't want to move the positions much again, resize windows in place, yes, but not move them all together.
I would love the ability to lock the window configuration in place so accidental drags on a title bar doesn't move the windows stay in place. I still want to be able to resize those windows in the space though.
The Alteryx.Flexnetoperations.com license management site needs major work.
On the View Licensespage it shows all licenses going back several years. A basic need is to show only licenses which haven't expired, but that is not an option.You cannot even sort on the expiration column while you can sort on most others columns.
The most simple need is to see a list of my current active license users - but I do't see a way to do that.
I tried an "Advanced Search" and chose expiration date after 2019-10-29 andnone of my licenses which expire in 2020 appear- I get a blank list.
Similarly on the administer machinespage you cannot filter to hide expired licenses or even on the licensescolumn (which doesn't sort either).
The helplink on the page doesn't bring you to help specific to that page but the general activation help front page. After several clicks I found this page: