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

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 

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

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

 

 

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

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

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

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

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

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

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

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

 

I love this tool,  but think it would be improved by including an option to create a column per delimiting character.  This could be added in the number of columns selector box.  In the case where 1 row has more delimiters than another, null columns can be created.  Without this option you have to Regex count the delimiters, select the max and then embed the Text to columns tools in a macro and then pass the max columns as a param.  Would be nice to resolve all this in the main tool.

 

Thanks, nick

I do a lot of work with SQL code in the PRE/POST SQL options and when I get an error, it usually returns the entire code and a little bit about what is wrong. These long strings are hard to read in the current tooltip format as if you hover over to see the entire error, the tooltip goes away after 5 seconds. So I am frantically reading through lines of error code 5 seconds at time. Can we make it so the tooltip just hangs out until I move my cursor off of it?

I see many posts where users want to view numeric or string data as monetary values. I think that it would be friendly to have a masking option (like excel) where you could choose a format or customize one for display.  The next step is to apply the formatting to the workflow so that folks who want to export the data can do so. 

cheers,

 

mark

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

My team uses a shared macro repository (say F:\AlteryxMacros), and we recently ran into an issue with the default save location for macros. While we save most macros to our repository, there are times when folks save their macros elsewhere (let's say C:\MyAwesomeWorkflow). The issue we've encountered is that if you go to file >> save as with a macro, it will ALWAYS default to the macro repository, even when my macro is currently saved elsewhere (C:\MyAwesomeWorkflow). Speaking for a friend, people have accidentally saved things to the macro repository by accident. Or, they waste time navigating from the macro repository to the their current folder.

 

If a macro is saved somewhere, please change the file >> save as to default to the current folder. Thanks! 

@JeffA posted an awesome blog about how UI automation testing is being done within Alteryx using the Selenium library and the Python SDK.

https://community.alteryx.com/t5/Engine-Works-Blog/Total-Automation-Badassery/bc-p/509096#M2105

 

This would be a TREMENDOUS addition to the core product - especially given that the alteryx team have already built these into a series of generic tools that can be dropped onto canvasses.

 

Example of where this would be super powerful for the Alteryx platform:

- the data I need to analyze is on a legacy system with no API; or behind a web login wall

- the data I need requires a user to hit a series of steps to download Excel or CSV (again, no API)

- I've found an outlier - can I submit this to an application so that someone can act on it?

 

This would be a very valuable addition to the core product; and really increase the scope of analytics capability - please could you consider adding this to the standard downloadable version as a brand new tab full of automation tools?

 

The eMail setup for the eMail tool and the eMail notifications are subtly different - in that the eMail notifications screen does not offer an explicit location for port.    This is important if the SMTP server does not use the default port.   You may be able to do this with : notation, but it would be better to create an explicit field for this.

 

 

No Port.pngNo Port available on the eMail settings for EventsStandard eMail Window.jpgPort is available on eMail tool

When selecting a HANA view in Alteryx that has a required prompt/parameter/variable Alteryx does not pre-populate the SQL with the required HANA prompt code.  Instead it give a SQL Error.   Requesting an Alteryx enhancement that would read the HANA view and determine the required HANA prompt SQL required and prepopulate the prompt or ask the user to fill in the prompt/variable box.  This may work similar to how Tableau work when connecting directly to a HANA view that requires a prompt (it would pop up the prompt and allow you to select, when you convert Tableau to custom sql it would save the SQL code required for the prompt.

Top Liked Authors