ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

When inputting a CSV file via the Azure Data Lake File Storage tool the default behaviour is for the first row to be interpreted as data.

 

When reading the same file locally using the File Input tool the default behaviour is for the first row to be interpreted as headers.

 

Since the majority of files will include headers on the first row, it would be helpful to have the "First row contains field names" option selected by default in the Azure Data Lake File Storage tool, and this would also bring the defaults of this tool in line with the standard File Input tool.

 

Illustration below showing the issue:

jamielaird_0-1620852719680.png

 

Hello Team,

 

Currently, in the select tool, we have to scroll up or down to check or see the list of the fields. In case, if the user wanted to change the data type, they can scroll into the list. Like, I am working on the mid-size data, and sometimes data contain 300+ fields, if I need to change anything in the data type I have to search by scrolling up or down. 

 

The idea here is, If you provide a search bar under Field, it will be a great help to all, in case if anyone needs to go for some specific field, the user just types the name in the search bar and make changes quickly. The select tool is important and we used much time while working on the flow. 

 

Thank you,

Mayank

 

 

Our company often builds applications where we need the ability for it to dynamically update dropdowns based on a user's previous selections. 

 

For example: 

  • A user needs to select their Server, database, and table for analysis (3 dropdowns).
  • When the user selects their server, a query is run to get a list of all databases on that server. Then the database dropdown will automatically populate with this list of databases. 
  • The user then makes a database selection, and a query is then run to get all tables within that database. The table dropdown will automatically populate with this list of tables. 
  • The user makes their table selection, and then runs their analysis using the server, database, and table variables with values that they have selected from each dropdown.

We can do this in other programs, but unfortunately the lack of dynamic selections/dependent dropdowns is a big limitation for us when building Alteryx applications. Our current workarounds are chaining applications together, or using PyQt within the workflow. Chaining is clunky and often causes unforeseen issues when uploading to Server with errors that are non-descriptive, and using PyQt comes with Python versioning issues. 

 

If this interactivity can somehow be added to Alteryx applications it would be a huge upgrade to our current Alteryx processes. Any suggestions for further workarounds would also be helpful!

 

Thank you, 

Amanda 

 

 

Many users will probably follow best practice style guides with Alteryx to use comment boxes under tools to describe in detail what is happening with these tools - such as this one shared by @BenMoss.

 

However a limitation of this is the comment boxes do not move with the tools, so if you have a well documented workflow but then need to add a new tool, you need to adjust all the spacing and re-align the tools, which with a large workflow can be time consuming. 

 

Alteryx Community Idea.gif

 

Therefore the improvement would be to have an ability to lock comment boxes to individual tools (similar to a group function in Office).

 

The interactive results pane is great, but wouldn't it be cool if you could interact directly with the result pane to do things like filtering.

 

There are a few too many steps with the method at the moment, where you need to either copy the value or type it into the filter pop up. A simple right click and filter on selected value would be a big ux improvement.

 

Filtering in interactive pane.gif

It would be great to have an option in the Output Data tool to write the workflow name to the Info properties of Excel outputs.

 

Maybe something like this:

Excel file info.PNG

 

So that whenever you open an Excel file you always have a way of finding the name of the workflow that created the file.

Excel file info 2.PNG

 

This would make it so much easier as I often have to share Excel files with colleagues and customers and then need a way of tracking them back to workflows weeks or months later.

It would be useful to allow for temporary local variables in formula tools. This could make code shorter, better readable, easier to maintain and help to avoid auxiliary columns which have to be deleted afterwards.

 

Arbitrary example for illustration:

if Length([Col1] + [Col2] + [Col5]) > 50 then
    Left([Col1] + [Col2] + [Col5], 48) + "..."
else
    [Col1] + [Col2] + [Col5]
endif

versus

tmpstr = [Col1] + [Col2] + [Col5]
if Length(tmpstr) > 50 then
    Left(tmpstr, 48) + "..."
else
    tmpstr
endif

The idea is that the temporary variable has limited validity inside the formula for a specific cell.

 

Hi 

 

The wording of the tool tip displayed in results window cells with long strings is misleading.  The current wording is "This cell has truncated characters".   

danilang_0-1616587137476.png

 

 

New users tend to infer that this means that the data value has been truncated somewhere upstream.  See here, here and here.   Changing this message to something like "Only a portion of long strings is displayed" will help reduce the confusion immensely.

 

Dan  

Hi team,

 

Currently, we can FILTER results in the result window using some string operations like "String equals", "String Contains", etc.

Firstly, it's a great feature. Kudos for the same.

 

However, it would be really helpful if we can add the IN operator functionality to this Result window FILTER.

Most of the time, we always want to check for multiple values while filtering the data.

 

I am attaching a screenshot of the FILTER location that I am referring to!

 

shreyanshrathod_0-1618910290701.png

 

For eg, In the above screenshot of the result window, I want to filter for Name IN ('Bullock County','Baldwin County','Butler County')

 

Kindly look into this.

 

Thanks in advance.

 

Regards,

Shreyansh Rathod

 

 

 

Hi all,

 

When debugging an error, we need to verify tool by tool in a sequence to better understand what is really going on.

 

Sometimes the tools are miles away from each other. Imagine a gigantic workflow with a lot of connections going back and forth and wireless connections everywhere to help the workflow organization. Here is an example with more than 1300 tools: 

fmvizcaino_0-1615923127842.png

 

My idea is to have a shortcut showing all the previous/next tools and by selecting the previous/next one you go directly to them.

Something like this: 

 

fmvizcaino_2-1615924201119.png

 

What do you guys think about that?

 

Best,

Fernando Vizcaino

 

 

 

Hi,

 

It would be great if users have the option to display the number of records that go in and out of the different tools in your canvas. This allows users to very quickly see how many records are in their datasets, and especially quickly analyze the results of specific actions such as joins, filters etc. without the need to open each individual tool. Especially when performing joins this can be very useful to quickly see how many of your rows have been successfully joined. I think this will give users a feeling that they have more control over their data and a better understanding of what is happening in Alteryx. Also if you quickly want to review a complex workflow (especially when it is not your own) this could be a huge timesaver. Simply run the workflow and follow the numbers to see what is happening and identify tools that might cause issues.

 

Love to hear what you think!

 

Schermafbeelding 2021-04-08 om 10.50.36.png

 

 

 

New Runtime configuration option.

 

 

Check box = Do not output ANY file if an ERROR is present.

 

HOLD all output functions until workflow runs every tool (cache them) and then start writing to output if no errors are found.  If one of the output files fails, we'd like to not output any, but that would be Christmas.  Let's just know that all processing of data was successful before outputs are generated.

 

Maybe in a cloud or future environment this would look like step #1 build cache.  Step #2 is load output files.  In a local implementation, you've got to have adequate temp space available for the cache.

 

Cheers,

 

Mark

When building API calls within Alteryx there are a few common steps required

1) Build out the URI for the API call (base URL plus any query parameters)

2) Deal with authentication, such as basic authentication requires taking a key and secret, base 64 encoding and passing this into the tool

3) parsing the results out and processing these downstream

 

For this idea I am specifically focusing on step 3 (but it would be great to have common authentication methods in-built within the download tool (step 2)!).

 

There are common steps required to parse out the results, such as using Filter (to check for a 200 response), JSON parse, text to columns and then cross tab to get the results into a readable format. These will all be common steps anyone who has worked with APIs will be familiar with:

cgoodman3_2-1616585073736.png

 

This is all fine for a regular user to quickly add in and configure these tools. However there is no validation here for the JSON result being as expected, which when embedding an API into a batch macro or analytic app means it can easily fail.

One example of a failure which I've recently come across is where the output JSON doesn't have all fields (name:value pairs) depending the json response. For example using the UK Companies House API, when looking at the ceased to act field at this endpoint - https://developer-specs.company-information.service.gov.uk/companies-house-public-data-api/resources... the ceased to act field only appears in the results if a person has actually ceased to act. This is important if you have downstream tools such as a formula to create a field [Active] where you have:

IF ISNull([ceased_to_act]) THEN "Active" ELSE "Ceased to Act" ENDIF

However without modification the macro / app will error if any results are returned where there is not this field.

 

A workaround is to add in the Crew Ensure Fields or union on a list of fields, to ensure that the Cease to Act field is present in the output for all API calls. But looking at some other tools it would be good if an expected Schema could be built in to the download tool to do this automatically.

 

For example in Power Automate this is achieved as follows:

 

cgoodman3_1-1616584699689.png

 

I am a big advocate of not making things unnecessarily complicated. Therefore I would categorise this as an ease of use feature to improve the experience of working with APIs within Alteryx and make APIs (as load of integrations are API based) accessible to as many users as possible.

 

 

 

 

Right now it is not possible to open .xlsx files in Alteryx that has restricted access to specific users from the excel file, even when you are logged in to Alteryx and Excel with the same user. If it is possible to make Alteryx recognize which users/email addresses should be able to input a file to Alteryx I think it would be a great enhancement. To get around the problem we are currently changing the file restrictions through right clicking on it -> Properties -> Security, but this is time consuming and not a smooth fix. 

 

All the best,

Elin

When Alteryx Designer detects an existing 32-bit Oracle driver on a user's machine, it displays an error message saying  that it requires a 64-bit driver.  If there is no driver at all installed, it will go ahead and install one. 

 

Can we get Alteryx to simply prompt the user to install the 64-bit driver instead of the 32-bit driver present error message? 

 

(I know they can co-exist since removing the 32-bit driver will cause Alteryx to install its own 64-bit driver after which one can re-install the 32-bit driver.)

 

Thanks!

D

 

I would love to be able to see the actual curl statement that is executed as part of the download tool. Maybe something like a debug switch can be added which would produce 1 extra output field which is the curl statement itself? This would greatly enhance the ability to debug when things aren't working as expected from the download tool.

Inspire 2021 Call Center Demo.png

 

Having the ability to call-out via ARROWS/SYMBOLS (gold star) would be nice without requiring the user to create images and call them to the canvas.  This makes the workflow even more readable.

 

Watermarks (e.g. DRAFT, AMP, Do NOT AMP, FINAL) would be useful on the canvas as well.  

 

Cheers,

 

Mark

The Output tool currently creates a zero-row file if you filter all the rows out (an empty file)

 

However - there's a very common need to say "don't generate a file at all if there are zero rows" - for example if you are generating a "Daily Details" file and there are no daily details today, you want to suppress this file.   This frequently trips up newer users since the only way to suppress a zero-row output file today is to it with macros.

 

Could you add a flag to the output tool to "Suppress empty files" so that if there are no rows to be written, Alteryx does NOT create an empty file?   This way the user can be in control of what to do with empty record sets?

 

Here is the issue I have, when you are using a Join tool and you have multiple columns that you are joining on (to the point that they don't all show in the 
Configuration window), i have a tendency to use the mouse scroll wheel to move down to see additional columns i am joining on.  The mouse scroll controls different things depending on where your cursor is.  If your cursor is over the Left or Right columns then the scroll button will change the Fields you are using to join on.  I have messed up more workflows then i care to mention due to this.  I do not think it is appropriate for the scroll wheel to effect and change the fields in the configuration window and it should only be used to scroll up and down in the configuration window.  

 

Ryan_Myers_0-1616702929504.png

 

it would be great if the formula tool could expand the intellisense to the select column box. For example, I could start typing in the select column box and it would widdle down the list of fields down.let's suppose I wanted to update field 79A, I could type in 7 and it might show something like 

7

17

27

37

70

71

79A

79B.

 

So if I typed in 79 then, it would further reduce it to 

79A

79B

 

And i could select 79A.

 

patrick_digan_0-1614186078945.png

 

Top Liked Authors