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.
The following idea might not be as valuable as some of @SeanAdams posts, but it would save this user precious fractions of time. When I leave the canvas with my mouse (point A) to go up to the pallet I select and drag the tool down to the canvas. Sometimes I do right-click and go through the menus to add the next tool, but generally I go through that labor only when I'm inserting in-stream the tool. So here is my idea:
Double-Click your NEXT tool and it "Alteryx-ly" appears on your canvas in proximity to the hi-lighted (last) tool. Better yet, connect it! Now I can move from the pallet to the configuration panel directly without having to move my mouse down to the canvas and then over to the configuration panel.
Hopefully, my friend @Hollingsworth will find this time-saving idea worthy of a star. Speed demons like @NicoleJohnson and @BenMoss might not need this turbo boost, but at my age it is worth the ask.
When building custom tools for Alteryx using the Python SDK, there is no current way to test these outside of the Alteryx Designer.
This means that your development process is:
- write some code (no code-sense; intellisense; auto-complete because Jupyter; VSCode; Visual Studio; etc cannot access AlteryxEngine or any of the other imports)
- copy that .py module into your C:\Users\<username>\AppData\roaming\Alteryx\Tools\<toolname>
- fire up Alteryx
- drop this new custom tool on a canvas
- run it to see if you get any errors
- then copy these errors out of Alteryx result window into Notepad to be able to read them
- then go back into your development environment to make changes
This is very painful, and this will directly scare most people away from learning how to create custom tools since it's not only inefficient - but also scary and frustrating for beginners.
Could we instead create mock python libraries; and a development harness (like Google does with Android development in Eclipse) in this SDK where:
- you have full code intelligence (intellisense, autocomplete)
- you can simulate engine events in a test harness (for example in the Android SDK; you can simulate the user rotating their phone, turning off GPS, hitting a volume button, etc).
- you can also write test cases which can run automatically
- then once you know that your tool will work - only then you drop it into the Alteryx Designer environment.
NOTE: This IDE way of thinking also allows you to bring the configuration pieces (like number of inputs; etc) out of raw code and into configuration options.
Although you may be able to do remote debugging by using platforms like PyCharm - that really does not give you the full ability to check in the code of your tool; along with all the test cases; in a harness that allows you to automatically check different events; or to make sure that your tool works in the test harness before deploying.
I'd like to see the DateTimeLastOfMonth and DateTimeFirstOfMonth functions be more flexible then just getting the first or last date of the current month. It would be great if you could point to a date field and have it give the first or last date of that month. i.e DateTimeLastOfMonth([randomdate]) and if the [randomdate] = December 3rd, 1981, the result would bring back 1981-12-31
There are times where you want to create a variation of a particular pipeline and the data transformations in the beginning of the pipeline are similar but need slightly different configurations. To save time, can we have a right-click context option for each tool to be able to copy/paste or duplicate tool with existing configuration. This saves time by only having to change a few options in the duplicated tool. This is common for tools like, input, output, joins, groupings and reporting tools. An example where this functionality is handy in reporting: you may have a particular way that you always do your charts and instead of configuring the chart options from scratch each time, you copy paste the chart tool with current configuration and then you only have to make minor changes such as the data connections.
the SQL Editing screen has recently been changed (thank you @JPoz and team!) - and now has syntax indenting and keyword coloring.
Could I ask for a minor change:
- The tool seems to be doing a word-wrap even if the container doesn't need it - for example in the screenshot below, the entire on clause can fit on one line because I've expanded the window so that it doesn't need to wrap.
- Could you also default to putting the ON clause for a join 4 spaces indented underneath the join clause? worked example below.
Could we use a default structure for queries where the on part is indented underneath the Join?
I am trying to generate the multiple sheets in the same Excel using Render tool. one of the sheet having around 100 columns and other two sheets are having only 20 columns. If am configuring paper size to 50 inches in render tool, its affecting the other sheets too and Report doesn't look good since columns width are getting extended to some extent.
So, it will more helpful if there is an option to configure each sheet paper size or a rule kind of thing.
Please let me know if there are any option to that.
I have seen one or two posts requesting ability to total up rows and/or columns of numbers, however this idea also requests the ability to subtotal data by a field and also produce an overall total.
This could be an extension to existing tools such as 'Summarise' and 'Cross Tab' or could be a stand alone tool. Desired output of using a tool like this would produce something like this:
This would be incredibly useful for building reports within Alteryx as well as analysing the data, and cut down the amount of tools currently required to produce this. I have seen a third party tool which does some of this but this adds the ability to subtotal.
It would be helpful if some of your tools had an optional input. For example, the directory tool is of course very helpful at the beginning of a workflow, however I have several workflows that create or pull in files, rename them, edit them, etc. I then need the directory tool to check that folder for the newly created files and then to feed that downstream. The problem is that when I have the directory tool feeding into the workflow, it fires immediately noting that no files are in the folder. I would love if the tool had an optional input so you could choose to put it in the middle of a workflow in an attempt to force it to hold off on firing until its turn.
Even better would be if the dynamic directory tool would allow for dynamic folders to be fed in rather than pinpointing a specific file....since it has an input, that would suffice and the user could either pick the regular directory or the dynamic directory if they wanted it to fire off in the middle of a workflow.
Currently when you add an event to notify you of workflow failure / success - you have to enter the SMTP settings every time. It would be more efficient to set this up as a user setting which can be used for the default across all canvasses that this user creates.
I just want to be able to make the width of annotations customizable. Yes, you can use comment boxes, but those aren't tied to any tools in any meaningful way. There is all this room to write out an annotation in the configuration window, but eventually on the canvas, it will be cutoff. Also, this isn't exactly the most friendly way to read.
I think being able to customize a canvas setting for max width would be awesome. It could be under the canvas tab of the workflow configuration. Additionally, the ability to adjust the width tool-by-tool could also be really helpful.
What would be even better is to allow the combination of the two. E.G. It is not currently possible to copy or cut multiple tools and paste before/after, as this functionality only works for a single tool that's copied.
It seems like it is restricted to 255 characters using .hyper as an input (Alteryx designer discussion). It would be great if we can read at least 2147483648 bytes which is the string limitation in Alteryx.
Would it be possible to update the What's new page for 2019.4 to include the key features in this release (in my mind, one of the biggest features is the SQL formatting)?
Currently if you go to the What's new link in Designer, it takes you to the right webpage, but there is no content for 2019.4
Additionally - would it be possible to keep a few releases on this page - often people skip 2 or 3 updates so it's worth keeping the top highlights of the last 4 releases there so that people can see the new features and explore them.
The great thing about What's New pages is the ability to explore new features, so it's worth linking out to examples on a page like this if possible.