Alteryx Designer Desktop Ideas

In the current expression editor, XOR(exclusive logical sum) is not supported as an operator while AND & OR already exist, so I'd like to request to add XOR to an operator in expression editor.

Without XOR operator, when we want to use XOR conditional expression, it is like below expression; it looks a bit complicated so it's hard to tell condition is XOR at once.

As a workaround, I defined custom function XOR by myself, but this should not be permanent solution since when sharing workflow to others it doesn't make sense unless they also have custom function XML file in their computers as well.

I believe addition of XOR would help to have much readable code for tools with expression editor(e.g. formula, filter, etc).

I find the Run Command tool to be counter-intuitive: rather than supplying a required I/O parameter (in at least one of "Write Source" and/or "Read Results"), I would rather just use a "Block Until Done" approach to 1. write file, 2. issue custom system command, 3. read file.  An even simpler example is the case where I don't need I/O to/from the system command... in that case, I just want to issue the command, nothing more.  But the current tool will require me to specify a dummy file, which is counter-intuitive and also leaves that unnecessary file somewhere.

To fix this up without breaking existing user implementations, the "idea" is:

• Do not require either "Write Source" or "Read Result" ... allow both to be blank.
• Allow (but don't require) any of "Command," "Command Arguments," and "Working Directory" to be dynamically populated from fields in the data streamed into the tool.

So... any existing user implementation should be unnaffected... but these changes would allow users to implement system commands in a more intuitive manner, and even allow for very dynamic system commands based on the workflow.

Thanks!

This idea is to fix one of the Power BI Output tool options for existing datasets.

Currently, if the 'Replace existing dataset' option is selected, the dataset is dropped and replaced with one having the same name.  Problem with this is that any reports or dashboards using that dataset become invalid (likely due to a changed internal identifier).

Idea is to change the 'Replace existing dataset' functionality to delete & replace the data within a dataset rather than deleting & replacing the dataset itself.

This behavior is described in the following thread & flagged as 'solved' although the workaround isn't practical as a true solution to the issue.  We'd like to see this supported more seamlessly via Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Power-BI-breaks-linked-Powe...

In response to my question here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Singin-Error-to-Tableau-server-using-P...

The Publish to Tableau Server does not support SAML/SSO. I would like this feature to be added to this tool as it will make our business process more efficient.

Thank you.

Hello!
I recently build a couple of workflows where i needed to union many parts of my data together. 

Take for instance, the following:

I appreciate this is an unrealistic workflow - but if i am splitting data, at any points, and doing different processes, i am going to need to union that data back together.

Now without my fix - the solution is to put a union tool onto the canvas, and drag each connection to the union tool. This is fine on a small scale, but when its 5+ connections this can become tedious.

My proposed solution, is similar to the 'cache and run' functionality, in that you can select many tools with Ctrl + Click, and at the bottom you have the option for 'Union Outputs':

And when clicked, a union is added to the canvas, following the furthest most right tool (or last clicked), and have a union setup, with all connections made:

Hope this makes sense!
TheOC

It would be great if we could create more customization of the email output in the Events in the Workflow Configurations.  Currently we can output the number of error, warnings, etc. and the entire output log.  It would be great if we could only send the error messages in an email instead of sending the whole output log (similar to the output of a workflow run with errors in the Alteryx Gallery).  The customization in the Email Tool is great, but this isn't helpful when a scheduled workflow fails. I found this related thread on the discussion forum: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Customize-Events-Error-Message/td-p/42... Thanks!

Please enhance the dynamic select to allow for dynamic change data type too.  The use case can be by formula or update in an action for a macro.  If you've ever wanted to mass change or take precision action in a macro, you're forced to use a multi-field formula.  It would be rather helpful and appreciated.

Cheers,

Mark

Bring back the Cache checkbox for Input tools. It's cool that we can cache individual tools in 2018.4. 

The catch is that for every cache point I have to run the entire workflow. With large workflows that can take a considerable amount of time and hinders development. Because I have to run the workflow over and over just to cache all my data.

Add the cache checkbox back for input tools to make the software more user friendly.

Hi,

Add to the feature where you can open a workflow to show how to use a tool.  Allow a user (and share this within an organization) to add a tool template workflow to a tool so one can open the template workflow and then copy the tools in the template into the workflow being worked on.  There are instances where we use the same tool combinations like for dynamic file naming and output.

Regards.

When you enter a search term in the results window, it would be great if it highlighted that term in the data results window. Otherwise, it still takes work to find where your search term is located in each row.

I love the new Custom Format option with the DateTime tool in Alteryx 11.0, this makes working with dates SO MUCH easier... BUT it would be great if you could update an existing field rather than having to create a new column (e.g. DateTime_Out) and then use a select to put this back to the original Date field.

*Simply a QoL suggestion & apologies in advance if this isn't possible within the constraints of Alteryx*

As it stands right now, if statements require an 'else' condition 100% of the time.

However, there are many times where users just need to flag a certain condition and don't care about what the other outcome is, often just needing this to filter or sense check etc. Therefore the idea is simple: allow users to immediately ENDIF a statement after a single if condition, much like we can do in Tableau. When a statement is written in this way, the missing 'else' just defaults to nulling the value if the single condition isn't met:

Sorry if this has been previously suggested but haven't spotted anything from a look around the ideas area.

Cheers!

Working with larger and larger workflows becomes difficult to navigate. I have been using the Right Click on Blank Canvas>Zoom to container recently, but the order in which the containers show doesn't seem to be intuitive. (Not by tool ID, rather the order they are in the XML.)

This has been asked in the past but I couldn't find an idea post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-I-set-the-order-in-which-container...

It would be useful to have the ability to change the list to be in alphabetical or tool ID order please.

As seen in This Discussion Post,  the idea here is to be able to add a link to example workflows in macro descriptions - like the ones seen in native tools.

Filter Tool

Many thanks to @jdunkerley79 for demonstrating how this can be done by manually editing the macro's XML - specifically by adding a child element to the <MetaInfo> section, like so:

      <Example>
        <Description>Open Example</Description>
        <File>\\aSERVER\aRootDir\path\to\Alteryx\Macros\Date Wizard\Date Wizard Examples.yxmd</File>
      </Example>

One small caveat is that it doesn't support truly relative paths.  @PaulN explained in the discussion post that a relative reference here would search in the sample folders.

"Alteryx default behavior is to look for examples under .\Alteryx\Samples\02 One-Tool Examples or Alteryx\Samples\02 One-Tool Examples (or .\Alteryx\Samples\en\02 One-Tool Examples)."

Having said that, trying to reference a macro example in the same folder (using a relative reference) will throw an error given the following situation:

Package Structure:

Date Wizard.yxmc XML edits:

      <Example>
        <Description>Open Example</Description>
        <!-- THIS WORKS -->
        <File>\\aSERVER\aRootDir\path\to\Alteryx\Macros\Date Wizard\Date Wizard Examples.yxmd</File>
        <!-- THIS DOESNT
        <File>Date Wizard Examples.yxmd</File>
        <File>.\Date Wizard Examples.yxmd</File>
        <File>./Date Wizard Examples.yxmd</File>
        -->
      </Example>

This shows a link in the Macro description but yields an error (shown below) when it is clicked.

Example Link ShowsError

 Once again, this works fine with an absolute file path reference.  

Here is ultimately what I am suggesting:  Can we add an option to the Interface Designer (that updates the XML) and have it allow relative paths?  Allowing relative paths would obviously be essentially to maintaining the macro's ability to be "lift-and-shift" when packaged/moved/uploaded to servers/galleries etc.

I'm assuming the option could look something like this, similar to the "Help" file -only it would show link in the macro description...

Interface Designer Suggestion

In conclusion, this would be very useful in providing links to example workflows for custom macros that may be complex and/or not self-explanatory.

Cheers,

Taylor Cox

I have been developing and accumulating custom functions over the years and they have proved to be very useful.  I am submitting these here.  I hope they are found to be beneficial.

Functions included in the attached file include:

• DateTime
  • StandardDate(String) - Transforms any valid string to the standard date format yyyy-mm-dd
• File
  • FileDirDepth(Path) - Returns the zero based depth of the path (zero being the root)
  • FileGetFolder(Path, Depth) - Returns the folder name given the zero based depth in the path (zero being the root)
• String
  • LeftPart(String, Separator) - Returns the left part of a string up to the first separator
  • RightPart(String, Separator) - Returns the right part of a string after the first separator
  • Split(String, Delimiter, Index) - Returns the zero indexed part of a delimited string
  • CleanSpace(String) - Trims string and replaces multiple spaces with a single space
  • UnicodeToASCIIBasic(String) - Replaces all Unicode Characters with ASCII Basic equivalents
• Test
  • InList(Variable, List) - If Variable is in List returns True. List must be pipe delimited
  • IsValidEmail(String) - Returns True if string is a valid email format
  • IsUUID(String) - Returns True if string is a valid UUID

To make these functions available in Alteryx, place the attached xml file in the folder C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn if you have a standard installation. If the install is non-standard, find the \bin\RuntimeData\FormulaAddIn folder and place the attached xml file there.  Ateryx will need a restart for the functions to be available.

Currently, the "SQL editor" window only contain a box for typing text in, we could not see the schema and table on it's side as a reference, we need to jump back and force between "Visual Query Builder" and "SQL Editor" search for table and column names. If we could see the database schema and table in the SQL Editor interface, it will save us a lot of time.

The original engine support expanding the formula tool with custom functions either in XML or C++. The new AMP doesn't support these yet.

There is a fair number of user who are using these in E1 and would be good to have this available in AMP

Admittedly I haven't used the Compare Workflows functionality too often in the past. In using it today, however, right away I found that navigating the workflows being compared wasn't the easiest thing to do. I'm open to ideas on how this could best be accomplished, but it would be nice to be able to navigate around each workflow simultaneously (currently you must move around in one canvas then click to the other then move around in that one separately). Maybe this would best be accomplished by one of the following ways:

 - Allowing scrolling in both tab groups at the same time ( i.e. if I scroll in one tab group, that same movement occurs in the canvas of the other tab group)

 - Allowing movement in both workflows simultaneously from the Overview window

 - Connecting the results windows for the two workflows being compared so that you can easily click to navigate to the tool/part of each workflow with changes with just one click

Presumably, if you're comparing two workflows, they should roughly have the same general layout so hopefully this sort of dual-tab navigation would be plausible (and could be turned off in settings if it is unwanted). I believe this would make it much easier to find and navigate to the places on both canvas where changes have occurred.