Alteryx Designer Desktop Ideas

I'm not doing a report but extracting data from a report 30 times to assign where the data goes.

It would be nice if in the "Output Data" tool if there was a check box to remove all field names so there is only data

Thanks! 

Improve the productivity of creating a canvas workflow by bringing up the 'Search All Tools' when I click on the canvas or create connections.   Currently, you must either search on the top toolbar then drag the tool down or right click in the canvas and navigate the menu.  It would be great to have a similiar functionality of the 'Search All Tools' box anywhere I click on the canvas to quickly add new tools to the workflow by typing rather than dragging from the toolbar. 

Case 1: When I create a connection from a current tool by clicking on the output and dragging to an open are, rbing up the 'search all tools' bar where I click and allow me to search the tools on the canvas.  Once I select enter, the tool selected will be brought into the canvas.

Case 2: when I click on an empty space in the canvas, bring up the 'search all tools' bar where I click and insert the selected tool into the canvas. 

Issue: Even though the Send Email event is configured for the After Run Without Errors setting in the Workflow Configuration it still sends an email when the execution of workflow is cancelled. I think only the Before Run event should be allowed to trigger in this case.

App: Alteryx Designer x64
Version: 10.5.9.15014

Workflow Configuration Error

Email Screenshot

I know for - the most part - the Alteryx core data bundle is the only one part of allocate. It would be great if you could open up allocate to the user so we can add our own third party data sources. Just tell us what the requirements are to make our datasets ready for allocate and then we can load it ourselves. Then we can use the allocate workspace to query data in a similar way.

for example:

Geography(DMA,*)
Variable(CYADULT18P,CYADULT18P,False)

There is no way to search the S3 object list for a specific object which can make it impossible to find an object in a list of >1000. It would be great if there was some way of searching the object names similar to the SalesForce Input Connecter (10.5) which allows a user to start typing the name of a table to find it.

It would help if there is some option provided wherein one can test the outcome of a formula during build itself rather than creating dummy workflows with dummy data to test same.

For instance, there can be a dynamic window, which generates input fields based on those selected as part of actual 'Formula', one can provide test values over there and click some 'Test' kind of button to check the output within the tool itself.

This would also be very handy when writing big/complex formulas involving regular expression, so that a user can test her formula without having to
switch screens to third party on the fly testing tools, or running of entire original workflow, or creating test workflows.

It would be good if an option can be provided wherein on clicking a particular data profiling output (cellular level) one can see the underlying records.

May be configurator/designer can be given this option where she can select her choice of technical/business keys and when an end user (of Data Profiling report output) clicks the data profiling result he can be redirected to those keys selected earlier.

One option might be to generate the output of data profiling in a zip folder which would contain the data profiling results along with the key fields (hyperlinked files etc).

Since in such case even data would be maintained/stored, it would be good to either encrypt or password protect the zip file based on various industry standards.

This can be provided as an optional feature under something like advanced properties for the tool, making use of the industry best practices followed in context of report formatting and rendering.

The reason why this should be optional is, not always there might be a need to have the detailed linking back to source level records in place.

For e.g. if the need is only to highlight the Data Profiling outcome at a high level to a Data Analyst this might not be useful.

On the other hand if there is a need for the Data Steward to actually go and correct the data based on the Profiling results, the linking of profiling results back to source data might come handy.

I'd like to see a tool that you can drop into a workflow and it will stop running at that tool and/or start running after that tool. I know about the cache dataset macro, but I think it could be simplified and incorporated into the standard set of tools.

In version 10.5 if the taskbar is auto-hidden and alteryx is the active window - you cannot access the taskbar by moving the mouse to the bottom of the screen.

You have to use the windows key or switch to another application window

Hi there,

Just a quick note on a really small improvement that could be made on the Data Cleansing tool but that could help a lot.

Actually this tool allows us to convert input data with NULLs to either blank or 0 values depending on the datatype.

It would be really appreciated to be able to do the opposite, converting blank or 0 values to NULLs.

When you press tab from from the Test Type combo jumps to the Ok box, think should go to Test Value text box

I am always coping the open workflow path for various reasons - would love a COPY button right here to copy to clipboard.

Please?

Sometimes in a crowded workflow, connector lines bunch up and align across the title bar of a tool container.  This blocks my view of the title, but also makes it hard to 'grab' the tool container and move it.

Could Alteryx divert lines around tool containers that they don't connect into, or make tool containers 'grab-able' at locations other than the title bar?

Image demonstrating connector line overlap

Hi,

When you create a data model in excel you can create measures (aka KPI). These is then something you can then use when you pivot the data and measure would dynamically be updated as you segment the data in your pivot table.

By example, let's say you have a field with the customer name and a field with the revenue, you could create a measure that will calculate the average revenue per customer (sum of revenue / disctintcount of customer)

Now if you have a 3rd field in your data that inidcates your region, the measure would allow to see the average revenue by customer and by region (but the measure formula would remain the same and wouldn't refer to the region field at all)

Excel integrates well with PowerBI and currently these measures flow into PowerBI.

While we have a "Publish to PowerBI" in Alteryx I haven't seen any way to create such measures and export them to PowerBI.

Hence I still need to load to Excel to create these measures before I can publish to PowerBI, it'd be great to avoid that intermediate tool.

Thanks

Tibo

It would be super helpful if there were a way to

1. have an active list of all inputs/outputs that, if the links were changed, would update the connection for every occurance of that input/output in the workflow

2. a similar list of formulas that could could simply reference in a formula tool, so if you have to change the source formula, it's automatically updated in all the linked occurrances of that formula.

Currently we resort to using a manual create table script in redshift in order to define a distribution key and a sort key in redshift.

See below:

http://docs.aws.amazon.com/redshift/latest/dg/tutorial-tuning-tables-distribution.html

It would be great to have functionality similar to the bulk loader for redshift whereby one can define distribution keys and sort keys as these actually improve the performance greatly with larger datasets

One of the common methods for generalization of different types of normal and beta distributions is triangular.

Though Alteryx doesn't have a function for this, even excel doesn't have this but

• SAS (randgen(x, "Triangle", c)) and
• Mathematica (TriangularDistribution[{min,max},c]) like tools include one.

Can we add something like randtriangular(min,mode,max)?

I have my solution attached, but this will ease the flow...

Best

We don't have Server.  Sometimes it's easy to share a workflow the old fashioned way - just email a copy of it or drop it in a shared folder somewhere.  When doing that, if the target user doesn't have a given alias on their machine, they'll have issues getting the workflow to run.

So, it would be helpful if saving a workflow could save the aliases along with the actual connection information.  Likewise, it would then be nice if someone opening the workflow could add the aliases found therein to their own list of aliases.

Granted, there may be difficulties - this is great for connections using integrated authentication, but not so much for userid/password connections. Perhaps (if implemented) it could be limited along these lines.