community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

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 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.

 

Cheers,

 

Mark

I really like the auto-suggest/complete feature in the Formula-Tool, it feels like coding in an programming enviroment, but it's sadly not everywhere.

 

I would love to see the auto-suggest/complete feature in every Tool that has the option to enter formulas.

 

E.g. 

- multi-row formula

- multi-field formula

- generate rows

 

 

Comparison: 

 

1) Formula Tool

grossal_0-1579772740713.png

 

2) Multi-Field Formula

grossal_1-1579772824017.png

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)

- hope

- 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

- repeat.

 

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.

 

Proposal:

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.

 

Thank you

 

 

 

 

 

cc: @BlytheE @SteveA @Ozzie @tlarsen7572 @c2willis @jdunkerley79 

Hi Alteryx Designer Dev Team,

 

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. 

 

Thank you

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.

 

Wordwrap:

 

SQL Query Wordwrap.png

 

Indenting Structure:

 

Could we use a default structure for queries where the on part is indented underneath the Join?

 

Select

    Field1,

    Field2,

    field3

from

    Table1

    inner join table2

        On Table1.key = table2.key

        and table1.keyb = table2.keyb

    inner join table3

        on table3.key = table1.key

        and table3.date = table1.date

 

 

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.

 

Thanks in advance... 

Hi to all,

 

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:

 

totals.JPG

 

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.

 

thanks - Roger

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

When developing in Python using custom objects - you often use print( object) or str(object) to see what's in this object quickly.

For example 

myDictionary = {
'CarType': 'Ford',
'Cost': 20000}

this defines a dictionary.   If I want to quickly look into these to see what's there I can use:

 

print(myDictionary)

# gives {'Cost': 20000, 'CarType': 'Ford'}

str(myDictionary) 

"{'Cost': 20000, 'CarType': 'Ford'}"

 

This is incredibly useful for debugging and to understand how these custom objects / classes work.

 

Please could you add an overload to the str() method to allow this kind of simple debugging and understanding for all the classes used in the Alteryx Python SDK (https://help.alteryx.com/20193/developer-help/sdks/build-custom-tools/python-engine-sdk/classes)

 

For example:

str(record_info_in) which is of type <class 'AlteryxPythonSDK.RecordInfo'>) gives you <AlteryxPythonSDK.RecordInfo object at 0x000001A2C48C3190> which is not very helpful.

Much more useful would be to flatten this into a string format or dictionary so that users can see what's in the RecordInfo object that they're working with to make delivery and debugging easier.

 

 

cc: @Ozzie @BlytheE 

 

 

 

 

Hi Alteryx 🙂

 

When you set maximum records per file, the filename gets _# appended.  Great!  But in reality you get:

 

Filename.csv

Filename_1.csv

Filename_2.csv

 

The first filename doesn't get a number.  I think that it should.

 

Cheers,

 

Mark

When you add an input tool, and select a connection from the connection history - the password is visible in plain text in some circumstances.   The screenshot below shows this in 2019.4

 

Please can you ensure that in this view, the password is ALWAYS masked.

 

Thank you.

 

DataConnectionPWD.png

Hi Alteryx 🙂

 

When I select fields within a BROWSE or Browse Anywhere, it would be nice to be able to highlight and deselect  a range of  fields instead of having to check/uncheck fields one at a time.  Yuck!  

 

Cheers,

 

Mark

Hello,

 

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.

 

Annotation 2019-12-27 180328.pngSettings.png

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.

 

TomMolitor_0-1579025419300.png

The new Paste Before/After feature is awesome, as is the Cut & Connect Around.

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Paste-Before-After/idc-p/510292#M12071

 

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.

 

Thanks,

Joe

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.

 

 

Could you expose a link to the Keyboard Shortcuts (which is here: https://help.alteryx.com/2019.4/HotKeys_Shortcuts.htm?Highlight=keyboard%20shortcuts) on the primary help menu (screenshot below)

 

This will allow people to get quicker in Alteryx by exposing these shortcuts to more users.

 

Annotation 2019-12-26 095035.png

Hi all,

 

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.

 

WhatsNewLink.pngWebpage.png

Hey @APolly 

 

You and the team have been doing a lot of innovative changes to the results window for data.

Could I ask for an uplift to the results window for Workflow Messages?

 

Summary: Error messages in the workflow results window cannot be fully viewed - have to be copied into Notepad and then reformatted before you can read.

Request: Allow user to double-click to see full readable version of a workflow result message

Detail:

 

If you have an error message in a workflow result - it gives you a message that is often longer than the window allows and there is no cell-viewer option

 

DoubleClickError.png

 

As a result, there is really no way to get to the important part of the error message to understand what's going on, other than to use Notepad

 

Step 1: Copy into Notepad

DoubleClickError-part2.png

(you can see the end of line characters being misunderstood)

 

Step 2: Manually clean this up by breaking on the line breaks

DoubleClickError-part3.png

And now you can see the important part of the result message..

 

 

Could we rather add the ability to double-click on a result message in the result window and bring up a modal window that formats the error message for you (similar to the modal window used for XML editing of a tool).   That would eliminate this entire wasteful effort of trying to read an error message and having to use Notepad?

 

DoubleClickError-part4.pngBring up a modal window, similar to this one; so that I can see the error without having to go to Notepad

 

Top Liked Authors