Alteryx Designer Desktop Ideas

It would be nice to instead of scheduling a workflow at a certain time, just schedule workflows to run after the current workflow is done.  

 

So what it would be is instead of running workflow B at 6:00 AM every morning, you could run workflow B when workflow A finishes running so that you would know that if there was anything happening in workflow A that workflow B relied on, everything would finish in the correct order.  

Recently my trial license expired, and after receiving our activation licenses, I needed to upgrade from the 'User' version to the 'Admin' version.

 

When uninstalling the previous 'User' version, it appeared to complete successfully, and I then started installing the 'Admin' version from the installer.

 

After installation completed, I noticed that three versions of Alteryx appeared in my Windows 'Programs and Features' in Control Panel - Alteryx (Remove Only), Alteryx (Admin), and Alteryx (User).

 

When attempting to uninstall the 'User' version, it appeared to complete as expected, but did nothing when examining the application or root directory location, and I could still access and open and use the 'User' version of Alteryx.

 

To make a long story short, after going into regedit and removing all registry keys named 'Alteryx' including the SRC source key for Alteryx, I was able to manually remove all three of these versions and reinstall the 'Admin' application successfully.

 

Some kind of an uninstaller to wipe out all Alteryx directories, installations/versions, etc. to perform a clean uninstall/reinstall would be super valuable and probably save some folks a ton of time who are evaluating the product and moving from a Trial(User) version to an activated Admin license.

Hey all,

We have a policy (similar to the best practices guide published recently by the Copenhagen user group - thank you @danielbrun2) that Alteryx canvasses should run without warnings.

 

However - some of the warnings are tremendously painful to track down. For example - a union that brings together 20 or 30 input streams which gives you a warning saying "not all fields contain field X".

 

Can we change this to multiple warnings saying "Input X does not contain field X" so that we click straight through to the offending warning?

Additionally - when there's a conversion error - we then have to run the flow again with filters and diagnostics to find the offending row. Can we have a way that alteryx automatically sidelines an example row so that you can solve it in one pass?

 

If we look at all the warnings with the intention of "how do we make this something that can be solved right now, without having to run complex diagnostics, so that the very next run is 100% clean" that would be a big help.

 

Thank you Sean

 

https://community.alteryx.com/t5/Inspire-2017-Buzz/24-Best-Practices-for-Moving-from-Ad-Hoc-Analysis...

 

I would like to see a way to partially execute  a workflow (specifically for an App) for the purposes of allowing user to make selections based on a dynamic data flow.

 

Ex:

1. Database Selection Interface

Click Next

2. Select from available columns to pass through to the output file.

Click Next

3. Pick from selected fields which fields should be pivoted.

Output file and complete run time

 

This was a simple example to explain a case, but the most common use I could see is for APIs. 

 

Would like to use arrows and other shapes for documentation. Moreover, having "anchors" (i.e., like in a wiki) would really facilitate moving about large workflows. I imagine the former is not hard to implement, though uncertain about the latter.

 

Check out the mock-up workflow for an admittedly bad example.

 

When I publish using the tabcmd publish command in an event or using the Publish to Tableau Server Macro, the extract becomes LIVE. I do not want it to become LIVE, because when it does, I cannot refresh the extract using the tabcmd refreshextracts command or setup a refresh schedule in Tableau Server. Is there anyway to make this tde stay an extract after Alteryx rewrites the file? When the extract is live it will not refresh until I manually select Refresh in Tableau Server when I am in the Workbook that is connected to the data source I am publishing.

 

I posted the above question and was told this would be good to add to the New Idea module. Thanks!

It is very difficult moving from Alteryx functions to SQL In-Database as a business user, I need to learn a whole new language.

 

In the short term Alteryx should provide a simple function reference, as similar as possible to the Formula tool, for building formula in the in-database tools.

 

Longer term I'd like there to be a parser from Alteryx Formulae to SQL so I can just write in my favourite Alteryx formula (or a subset thereof) and Alteryx handles the conversion to SQL. 

 

The option to "Disable all tools that Write Output" is great during testing but I often need to toggle back and forth and its location on the Runtime tab of the Workflow Config is inconvenient.

 

I think it would be great to have a button for that on the toolbar with the added feature that it would visually display whether the feature is on or off (so you don't need to see an Output Data tool to determine the current status)

Hope this is fairly self-explanatory.

I'd like to be able to create presets for Summarize tool.  Instead of having Group By, Sum, Count, Count Non Null, etc on top of the libraries of functions, put them into their own category.  Users could then create a Favorites and the functions that they use the most would be stored in that section (editable by user).

Some say to mato and some say to_mato, but how about:  to/mato?

 

While working with my new friend, @Cedric we ran across a field in his data that contained a '/' character.  We were building a macro where we updated the value of the field [AB/CD] with another field selected from the incoming data.  Our error message was something akin to:  Field AB was not found.

 

We worked around the issue, but what remained was the fact that certain characters are permitted in field names within some aspects of Alteryx and not in others.  I don't know if you're aware of this limitation.  

 

Cheers,

Mark

I'm loving the ability to read from a zip file! However, I would love the ability to read all file types. For me, I don't see .accdb or .flat, and I assume other folks might be missing other file formats that they use. I find it confusing that the input tool accepts a lot of file types, but selecting the zip format then limits my choices. I believe @Aguisande mentioned this issue in the 10.5 beta.

 

Thanks!

Scenario: I open a results window with a link, filepath, value, etc. and I want to copy the text.

 

If I click inside of that cell and press Ctrl +A, nothing happens.

 

If I click inside the cell, arrow to the end of the text, and then press Shift + Home; the contents of the cell are highlighted.

 

Why can't we have all of the Windows shortcuts?  Or am I missing something here?

I've had the need to Find & Replace inside of a formula that I've written.  Would it be possible to have that type of functionality inside of the expression builder?

 

Does anyone else think that it would be useful?

Currently I am running two version of Alteryx and some of the macros were created/updated in the newer version of Alteryx. I would like to see only one error message displayed for all of the macros created in a newer version rather than having a dialog box pop up a dozen plus times (one for each macro) every time I open an instance.

 

Macro Error Message

Hi all,

 

As per the post here: https://community.alteryx.com/t5/Data-Preparation-Blending/Dynamic-input-not-respecting-data-sort/td... - there are situations where you need to use something like a dynamic input to query data, but need it to be brought back in the order that you specified on the input stream.

 

The Dynamic Input too sorts the input stream deliberately, to check for duplicate queries so that it doesn't waste time bringing back duplicate data.

 

It would be great if we can extend the dynamic input tool to allow users to specify that they wish the data unsorted, and that they are OK with the consequences of possibly running the same query twice.    Even if this is a setting that can only be set through XML, it would still be helpful.

 

Many thanks

Sean

It would be good to replicate some of the key workflow configuration settings as shortcut icons in the main shortcut toolbar.

 

For instance, I often use 'Disable all tools that write output' and need to toggle it on/off quickly when I'm testing a workflow. It takes too many clicks to deselect a tool, open workflow configuration, open the Runtime tab and select the checkbox. Many end-users I work with also don't even know the option is there because it is so well-hidden.

 

It would be much simpler and easier If I could toggle it straight from the shortcut bar. Having a keyboard shortcut to do it, like I do with ctrl-R (to run) would be even better.

 

Having shortcuts would also be good for:

 

• Disable all browse tools
• Show/Hide connection progress
• Open the Events window

So - with Challenge 111 - many folk used the Optimization tool

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-111-Make-a-Weekly-Challenge-Dream-Team/m...

… and Joe has done a great training on this here

https://community.alteryx.com/t5/Live-Training/Live-Training-Prescriptive-Optimization/m-p/44779

 

But it's still to hard to use.   It requires you to have pre-knowledge of a bunch of parameters and different types of knowledge.

 

Can we improve the interface on this tool so that it can be used by folk who do not have a background in R - for example, take all the different inputs, and make them parameterized on drop-down boxes or input boxes on the tool?

 

Thank you all

S

 

CC: @JoeM

When working with a transactional API, it would be beneficial to allow for multiple threads to process the workload concurrently.  A single threaded consumption is a good start, but for more volume a throttled multi-threaded tool would be very helpful.

Please add support to read and write spatial data from a SpatiaLite database.  ESRI and QGIS have supported this format out of the box for quite a while.  We have a mixed use environment Alteryx, ESRI, Mapinfo and QGIS and would like a common file based spatial format.  You already support SQLite, its container, so expanding to the SpatialLite spec should be a no brainer.

 

https://en.wikipedia.org/wiki/SpatiaLite