Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

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

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

Submission Guidelines

Featured Ideas

It would be very helpful if we could pick from a list of installed calgary datasets in the dropdown menu:

we currently have the ability to choose geocoder/drivetime/Allocate datasets which are typically stored in the .ini files, but don't currently have the ability to choose calgary datasets. 

jarrod_1-1628862282636.png

 

 

I'm adding a 'Dynamic Input' tool to a macro that will dynmaically build the connection string based on User inputs. We intend to distribute this macro as a 'Connector' to our main database system.

 

However, this tool attempts to connect to the database after 'fake' credentials are supplied in the tool, returning error messages that can't be turned off.

 

In situations like this, I think you'd want the tool to refrain from attempting connections. Can we add a option to turn off the checking of credentials? I assume that others who are building the connection strings at runtime would also appreciate this as well.

 

As a corollary, for runtime connection strings, having to define a 'fake' connection in the Dynamic Input tool seems redundant, given we have already set the 'Change Entire File Path' option. There are some settings in the data connection window that are nice to be able to set at design time (e.g. caching, uncommitted read, etc.), but the main point of that window to provide the connection string is redundant given that we intend to replace it with the correct string at runtime. Could we make the data connection string optional?

 

To combine the above points, perhaps if the connection string is left blank, the tool does not attempt to connect to the connection string at runtime.

I tried multiple ways but unable to find easiest way of handing the auto fit the all the column in final output. If we have already could you please help me with the solution. 

 

if not - can we create one additional tool which auto fit and align the data type accordingly. 

 

2 issue is about post I bifurcate the excel sheet data with multiple workbook data type doesn't show proper. for example Main file contain string and numeric value. post the bifurcate all the number still shows string value only due to every cell has green tick mark. 

Database driver versions are a constant trauma for the admin team and for our Designer users.   We have situations where drivers are different between two peers who are working on the same flow, or where the flow breaks as soon as it's posted to the gallery etc.

 

What would really help is if Alteryx were able to create a driver pack (working with the major vendors), which contains the latest version of the major database drivers.    We could then roll this out to all the designer & server machines to make sure that we have consistency across the user base.

 

This would need to include:

- DB2

- MS SQL

- Mongo

- Sybase

- Postgress

- Apache Kudu / Spark

Plus a few others, I'm sure

 

This is a pain for Alteryx to do this centrally, I know, but it's orders of magnitude less painful than having to do this manually (by searching for the latest drivers on every manufacturer's sites) on every designer workstation across the firm.

 

This is Ganesh from Guidelines. 

 

One of the task in my process is to convert the Pdf to excel sheet for all content. 

 

Pdf content will all depend upon the number details available. 

 

Pdf contain table format detail. 

 

We would like see all the pages of pdf should be in excel sheet with proper format including Table provided in pdf.  

Scenario: I open a results window with a link, filepath, value, etc. and I want to copy the text.

 

If I click inside of that cell and press Ctrl +A, nothing happens.

 

If I click inside the cell, arrow to the end of the text, and then press Shift + Home; the contents of the cell are highlighted.

 

Why can't we have all of the Windows shortcuts?  Or am I missing something here?

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, the distance tool provides an option to calculate mileage distance (as the crow flies) between a point and the edge of a polygon, but you can only calculate drivetime to the centroid.

 

I'd like to see an option to calculate drivetime based on the nearest edge rather than centroid, Thanks.

 

 

image.png

I came up with an idea while replying to @Deeksha. An interesting option to secure the data would be to encrypt the data sets and "license" it to

  • specific users
  • specific time spans or
  • people with certain credentials

just like we do by encrypting the workflow...

 

Picture5.png

 

 

Picture6.png

 

 

 

 

 

Spark ODBC is really faster than Hive, at least for GUI.

However, two things are missing :
1/ Append existing for the write date (exists his way on Hive)

 

2/ability to put "overwrite" even if the table does not exist (it works this way on Hive)

 

test_spark_sql.png

 

These two drawbacks limit severly th

There is no way to natively connect to Microsoft Dynamics 365 F&O. We also cannot use the download tool to connect to the API as it requires an OAuth2 Bearer Token generation step. Documentation can be found here: https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v1.0/

 

I would request a tool similar to the Salesforce Input tool to be created.

Suggested process:

  • Configuration Window to log into a Microsoft Dynamics 365 F&O account
  • Configuration Window to select the following
    • 1 or more companies ("all" should also be an option)
    • The specific "table" or "api call" you want to query - for example the "Sales Invoice" Data
    • Date Range filter (both from + to date combination as well as some generic "this month", "previous month", "this quarter" kind of selections)

I would also request that this tool be developed so that it can run on Server and Analytics Hub so that we can run end to end automation.

At work I use a laptop and two external monitors. (L, EX1, EX2) <- that's how it's set up

 

When working in Alteryx I put my main window of Alteryx on EX1 and Results/Configuration tab on EX2

 

Sometimes I need to unplug my laptop, go to the meeting - or, what I have been doing lately, go to one of the meeting rooms and use standing desk to work there.

 

Problem is when I disconnect my laptop from the docking station (where external monitors are connected) other windows "jump" to the laptop screen, apart from Alteryx external tabs - meaning I can't "reach" it, even if I disable/enable or restart Alteryx.

 

It's not really a complaint of any sort but just a discussion if there is a way for this to be improved?

I got to know that in version 9.1 Alteryx will have Unique Tool with "Unknow"check box to make it dynamic. I want to suggest same logic for Summarize tool for making it Dynamic.
Please add Unknow like functionallity in Summarize Tool

Thanks,
Pratik Gujarathi 

Hello all,

Here is a very, very simple idea :

just having the right to put a minimum length to Text Pre-processing
Why ? A lot of words (especially in French) with 1 or 2 characters does not change the meaning, the sentiment: la, le, à, un, une, etc... In English : in, the, etc..

 
 
 

Best regards,

Simon

While it is good to have the test tool stop outputs based on tests, it isn't too insightful to users on the full details of these error messages. It would be more useful to have an output location for a test if these errors appear so that end users can troubleshoot instead of the workflow developer having to work through all of the error messaging.

 

There are workarounds for this that can be used, but they are often extensive and require the addition of significant logic. Adding optional outputs to the test tool would be a simple fix that could save a lot of hours of debugging when end users find an error.

Hi 

In a toold like select it would be nice to place curser in Field - and type the first letter of the fields you want to browse through.:
By pressing F here I would just across fields that starts with F.

Sometimes you want to preserve the field order from the sorce, and if you have many fields it takes a while.

Hamder83_0-1658920082236.png

Or beeing able to filter - just like in excel:

Hamder83_1-1658922381493.png

 

 

Same goes for formula box:

Hamder83_2-1658922420927.png



Beeing able to click D as an example and click though coloumns starting with D.

 

It would be good to have the ability to select what column to use for Primary key when using the "create new table" output option of the output data tool.

 

When using the "update: insert if new" output option, you receive the error "Primary Key required for Update" if table does not have primary key.

 

Workaround is to manually create table with primary key constraint.

My idea is to have the AlteryxEngineCMD.exe to run a workflow as part of the standard Alteryx license.

 

Use case - be able to run Alteryx from the command line without the need to buy the entire Scheduler package (at $6,500/seat).

 

I understand why certain features are add on, but the ability to run AlteryxEngineCMD.exe (I feel) should be part of  the standard license which is already $5K+. For those who only need to be able to run a command line execution of a workflow $6.5K is a lot of money!

I would like to suggest to add a widget which encapsulate an R script able to perform outlier detection, something similar like netflix did:

 

Thank you.

 

Regards,

Cristian

  

Hi,

 

I am not sure why it is so complicated to troubleshoot formula tools in Alteryx. When I am getting an error with information parse error at char (char number) why we don't get this information highlighted in the configuration tool at the left. 

 

It should be crystal clear for the user where he needs to troubleshoot his workflow. We can say that the formula tool is showing us where the formula is working, so it isn't so bad.

 

Emil_Kos_1-1627633045135.png

 

When working with a multi formulas tool, it isn't easy to figure out where the mistake occurred.

 

Emil_Kos_3-1627633300161.png

 

Can we highlight somehow this specific character and make users life easier?

Top Liked Authors