Alteryx Designer

Share your Designer product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the like in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

The select tool does a great job at flagging up when something has changed from its original state. However why does this not happen with the checkboxes to keep or remove a field? It would be much faster and easier to read if we could have the same color conditional formatting as the rest.

 

Jonathan-Sherman_0-1594041131247.png

 

When using the output data tool, it would save me and my cluttered organizational skills a lot of effort if the writing workflow was saved as part of the yxdb metadata. 

I've often had to search to find a workflow which created the yxdb. I tend to use naming conventions to help me,  but it would be easier if the file and or path was easily found. 

cheers,

 

 mark

Please add official support for newer versions of Microsoft SQL Server and the related drivers.

 

According to the data sources article for Microsoft SQL Server (https://help.alteryx.com/current/DataSources/SQLServer.htm), and validation via a support ticket, only the following products have been tested and validated with Alteryx Designer/Server:

 

Microsoft SQL Server

Validated On: 2008, 2012, 2014, and 2016.

  • No R versions are mentioned (2008 R2, for instance)
  • SQL Server 2017, which was released in October of 2017, is notably missing from the list.
  • SQL Server 2019, while fairly new (~6 months old), is also missing

This is one of the most popular data sources, and the lack of support for newer versions (especially a 2+ year old product like Sql Server 2017) is hard to fathom.

 

ODBC Driver for SQL Server/SQL Server Native Client

Validated on ODBC Driver: 11, 13, 13.1

Validated on SQL Server Native Client: 10,11

After hitting "Test" in Workflow Dependencies:


Failed result = Bold red text (and a message)

Success result = Nothing? 

 

Maybe we could get bold green letting us know that the test completed successfully. 

In order to make the interface tools more accessable - please could you add explicit documentation to the help-text that explains how the data is returned to the canvas?

 

For example - the text input tool is documented here: https://help.alteryx.com/2019.3/QuestionTextBox.htm

What is missing from this is whether the multi-line version will provide the data to the canvas as a semi-colon delimited; comma delimited; newline delimited etc?

 

Would be very valuable if the documentation could explicitly define how the output of checkboxes; multiline textboxes; tree views etc are passed to the action tool.

 

Annotation 2019-12-27 183346.png

  • Documentation

Often as I am scraping web sites, some clever developer has put an invisible character (ASCII or Unicode) in the data which causes terrible trouble.

I've identified 89 instances of zero-width or non-zero-width glyphs that are not visible and/or Alteryx does not classify as whitespace. There are probably more, but Unicode is big y'all.

Unfortunately, the Trim() string function only removes 4 of these characters (Tab, Newline, Carriage Feed, and Space).
REGEX_REPLACE with the \s option (which is what the Cleanse macro uses) is a little better but still only removes 20. And it removes all instances, not just leading and trailing.

I've attached a workflow which proves this issue.


@APolly: this is what I mentioned at GKO.

And I did see this post (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Elegantly-remove-all-ASCII-characters-...), but it's too brute force. Especially as Alteryx is localized and more users need those Unicode characters.

Dear Alteryx GUI Gang,

 

I'll create a container and then customize the colours, margins, transparency, border and then want consistency for other containers.  It would be nice to have a format painter function (brush) to apply the format of one container to another.  This of course could be extended to other tools like comments.  There might be a desire to apply this to more tools too, but the comments and containers would be my focus as they are almost always custom configured.

 

Cheers,

 

Mark

It is just a bit of annoyance, really. I'd like to see the option of inputting a hexcode of color and/or a screen color picker in the color dialog. At the moment, you have to change R, G, B separately or play around with the cursor to find the right color.

The color dialog is relevant for the documentation purposes but also reporting tools and I'm sure it would make life easier to some people, especially when branding colours are important.

 

 

image.png

It would be extremely useful to quickly find which of my many workflows feed other workflows or reports.

 

A quick and easy way to do this would be to export the dependencies of a list of workflows in a spreadsheet format. That way users could create their own mapping by linking outputs of one workflow, to inputs of another.

 

Looking at the simple example below, the Customers workflow would feed the Market workflow.

 

WorkflowDependencyType
CustomersSQL Table 1Input
CustomersSQL Table 2Input
CustomersExcel File 1Input
CustomersExcel File 2Input
CustomersExcel File 3Output
MarketExcel File 3Input
MarketSQL Table 3Output

 

It would be CRAZY AWESOME if we could get a report like this for all scheduled workflows in the scheduler. 

At the moment containers either expand and overlap other tools, or you have to leave space for them (defeating the original purpose of using them). Is there a way we can have the containers expansion shift the workflow so the others tools shift down / right to account for this expanision?

  • Documentation

 

We are using Alteryx designer to bulk upload to Snowflake database. We also use Alteryx Connect to pick up metadata from Snowflake. It would be awesome if the designer can add table and field description and snowflake loader can pick up the description automatically. 

 

As of now, the metadata loader doesnt pick up metadata content in real time. This feature will motivate our analysts to document which will improve Connect adoption in our department. 

  • Documentation

Problem:

When searching for Alteryx help on Google the search results rarely return the current version of the Help documentation from the Alteryx website. Instead, what often happens is that an old version of the Help documentation is returned.

 

For example, a search for 'Run Commend Tool Alteryx' returns links for the 2018.3 and 11.3 instances of the help page:

 

Screenshot 2019-05-15 at 16.30.00.png

 

These relate to prior versions of Alteryx and a better result would be to link to the /current/ version of the page (the URL for which never changes).

 

https://help.alteryx.com/current/RunCommand.htm

 

The problem above can be replicated for almost any tool or variant of search terms.

 

Since Google is such a crucial resource for troubleshooting, there is a risk that (a) users will inadvertently access out of date documentation and (b) users will be confused by the presence of multiple search results.

 

Solution:

By adding a 'robots.txt' file to web pages for prior versions of the tool these results can be suppressed from Google search results.

 

https://support.google.com/webmasters/answer/6062608?hl=en

 

This should result in the /current/ documentation pages rising in search results and being more prominent when users search for help on Alteryx using Google.

 

  • Documentation
// This is my new formula
MAX([Price] * [Quantity],0)
// This was my old formula
// [Price] * [Quantity]

Imagine being able to SELECT your text block (could be many lines) and right-clicking to see an option to Comment or Un-Comment those configuration statements.  I thought that you'd like it too.

 

Cheers,

Mark

It would be useful to have the WorkflowName captured as one of the default Engine constants. The WorkflowDirectory is included so why not the WorkflowName as well?

 

I often have to use configuration files to pass in values to workflows meaning the workflow name needs to be manually entered into the workflow, either as a text input or User Constant, which feels like an unnecessary step as Alteryx must know the name of the workflow once it has been saved.

  • Documentation

When you drag a comment box into a workflow it should sit underneath all other data tools by default.

 

Currently, the order of tools is set by the order of placement (that is, tools placed in the workflow first are placed below subsequently placed tools).

 

  • Documentation

Hi Alteryx team,

 

Not sure if this is a Designer or Connect idea but the idea is to allow more options when searching in Connect from the Designer interface. As of now, it seems that it is only possible to search for tables and views, or generally those objects which can be added as an input data tool.

 

search.jpg

 

I believe that search directly from Designer is a great feature and at least our clients use it more and more. Would it be also possible to find workflows within Connect catalogue and open these workflows in Designer?

 

This could also apply to other data assets within the Data sources section like APIs, procedures etc.

 

Thank you

Michal

To get simple information from a workflow, such as the name, run start date/time and run end date/time is far more complex than it should be. Ideally the log, in separate line items distinctly labelled, would have the workflow path & name, the start date/time, and end date/time and potentially the run time to save having to do a calculation. Also having an overall module status would be of use, i.e. if there was an Error in the run the overall status is Error, if there was a warning the overall status is Warning otherwise Success.

 

Parsing out the workflow name and start date/time is challenge enough, but then trying to parse out the run time, convert that to a time and add it to the start date/time to get the end date/time makes retrieving basic monitoring information far more complex than it should be.

  • Documentation

As stated in the help on the Alteryx website, hive as a data source in Alteryx is validated for Hive 2.0. We were wondering if the most recent version of hive is included in the roadmap and, should anybody migrate to HIVE 3.0, what kind of support can be expected in case of technical issues ?

When a custom (bespoke for @chrislove) macro is created, I would like the option to create an annotation that goes along with the tool.  This is entirely cosmetic, but might help users to recognize the macro.

 

Thanks,

Mark

Hi Team,

 

Alteryx designer to integration with VSTS/ GitHub to have multiple resources working on same workflow.

 

In current scenario we are facing issue if we have two developer that need to work on complex workflow and need to complete in short timeline.

 

Please have a thought around to see if there is any faster option to integrate.

 

Thanks In Advance.

  • Documentation
Top Liked Authors