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

I know others have talked about it here and here and here other places.  And everyone suggests the dynamic rename tool and it's drawbacks.  

 

Our users regularly need to write data to various places on a worksheet and we end up authoring VBA to delete the header rows often.  It would make a huge difference to our users if there was a checkbox to exclude column headers when writing out.

Hi All,

 

This is a fairly straightforward request. I'd like to be able to pass through interface tool values to the workflow events the same way I would pass it through to a tool in the workflow (%Question.<tool name>%). One use-case for this is that we are calling a workflow and passing in an ID, and if this workflow fails, I'd like to trigger an event that will call back to the application and say this specific workflow for this ID failed.

 

The temporary solution is to have the workflow write to a temp file and have the event reference that temp file, but this is clunky and risky if there are parallel runs occurring. 

 

Best,

devKev

If I set an Excel file mask under the "arbitrary" configuration of the File Browse Tool on the desktop version, Alteryx will not prompt for worksheet selection. If I save that same configuration to the server, then the file mask is ignored (the users can select any file) and Alteryx will then prompt for a worksheet selection. Please set it where the environments have consistent behavior.

 

Prompting for a worksheet should be an option that the developer can turn off.

I am trying to schedule something to run every 2nd workday of the month (which will not be the 2nd day of the month every single month because the first day of the month might land on a Friday which would make the second workday the 4th of the month). Is there a way to implement this in a schedule? 

 

For a few months we have used the custom schedule since we know the specific dates they would land on but it doesn't seem like the most efficient.

 

Thanks for you help. 

 

 

Think of a pivot table on steroids. In my industry, "strats" are commonly used to summarize pools of investment assets. You may have several commonly used columns that are a mix of sums and weighted averages, capable of having filtering applied to each column. So you may see an output like this:

 

Loan StatusTotal Balance% of Balance% of Balance (in Southwest Region)Loan to Value Ratio (WA)Curr Rate (WA)FICO (WA)Mths Delinquent (WA)
Current$9,000,0009080854.57200
Delinquent$1,000,00010100955.56204
Total$10,000,00010090864.67100.4

 

Right now, I feel like to create the several sums and weighted averages, it's just too inefficient to create all the different modules, link them all together and run them through a transpose and/or cross tab. And to create a summary report where I may have 15 different categories outside of Loan Status, I'd have to replicate that process with those modules 15 times.

 

Currently, I have a different piece of software where I can simply write out sum and WA calcs for each column, save that column list (with accompanying calcs) and then simply plug in a new leftmost category for each piece of data I'm looking at. And I get the Total row as well auto-calculated as well. 

Issue:  How can I return 100,000 rows (results) from Google Analytics.

As per the GA Tool video overview, in the advanced options of the API call, I can set the maxResults to an integer to throttle the API.  However, as per the Google Analytics Core Reporting API reference the maximum number of results returned by one request is 10,000 no matter what it's set to.  After that paging is required by altering the start-index parameter.  How can this be achieved?  Is it possible already?

Google Analytics Core Reporting API references:

max Results

start Index

 

Is there another tool in Alteryx (perhaps a custom tool where I can implement my own Google Analytics API code) to pull as many records as desired?

I installed version 4.0.0 of the Salesforce Input tool since the old tool is deprecated. When I open a saved workflow that has Salesforce inputs, the inputs display an immediate error, for example "Error: Salesforce Input (95): 401 Client Error: Unauthorized for url: https://servings.my.salesforce.com/services/data/v42.0/sobjects/Task/describe/". The workflow will not run until I click into each Salesforce input and then click outside of it again to make it refresh, which takes a few seconds each time. I'm guessing this has to do with Alteryx saving an expired OAuth access token and trying to pull updated metadata.

Alteryx has different behaviours for conversion errors depending on the type of conversion desired. When converting from string to date data type, a conversion error will generate a NULL value. When converting from a string to a numeric data type, a conversion error will generate 0. Why the different behaviours? There is a lack of harmony here. 0 is a valid value and should not be the generated value for a failed string to numeric conversion. It should be NULL.

 

When I perform data type conversions, i do not apply them directly to the source field and then cast it. If there is a conversion error, then I have lost or corrupted the source information. Rather, I create a target field with the desired data type and use a formula to apply a conversion, such as datetimeparse or tonumber. Finally, I do a comparison of the source and target values. If the datetimeparse generated a NULL then I can PROGRAMMATICALLY address it in the workflow by flagging or doing some other logic. This isn't so easy to do with numerics because of the generated 0 value. If I compare a string "arbitrary" to the generated 0 value as a string then clearly these do not match. However, if I compare a scientific value in a string to the converted numeric as a string, then these do not match though they should. My test of the conversion shows a false positive.

 

I want a unified and harmonised conversion behaviour. If the conversion fails, generate a NULL across the board please. If I am missing something here and people actually like conversion errors to generate 0 please let me know.

As an enterprise customer, we need to know that Alteryx products are kept secure.

 

Please post vulnerabilities and fixes, and provide a way for me to subscribe to these alerts.

User.DevInputPath  \\Server\Path\Input

 

%User.DevInputPath%\myInputFile.yxdb

 

When I define a constant and then use it to reference an input dataset it makes it very easy for me to switch paths.  It also creates a little headache for me if I copy that input or create another workflow.  When I create another workflow, I must re-type and create more user constant entries.  It would be nice to be able to + (create new workflow) and to generate it via a copy of the current open workflow (copy ALL preferences set plus the user constants) from the workflow.  Even the ability to copy/paste the constants would be an improvement.

 

Cheers,


Mark

Hi,

 

Please provide users the option of downloading course videos and transcripts. If it is already there, please let me know.

 

Regards,

Meenakshi

It seems that currently the Python tool is raising a `FileNotFoundError` exception in Python when there is not data incoming on an input connection. I have, for example, a Filter tool before the Python tool and sometimes there is just no data coming to Python tool - as it is intended.

 

Unfortunately, the Python tools gives my an error message in those cases with this message before the error:

 
Python (15)Unable to connect to input data (C:\Users\CCEB8~1.HAR\AppData\Local\Temp\3a9bb9672d7abbe6af3176379ae8c3b1\15\4460abb7be83bae8f01b9bf1238a923c.sqlite)

 

This is only the case when there is no data incoming. In all other cases, the tool works fine.

 

Since this is not really an error, a way to either catch this before using `Alteryx.read("#1")` or just having `Alteryx.read()` return an empty data.frame (as I would expect it to do) would be appreciated.

I know that incoming and outgoing connections can be wired and wireless, and that they will highlight when one clicks on a tool. However, it would be very useful to be able to highlight a particular connector in a particular colour (selected from a palette, perhaps, from the drop down window, or from the configuration). This would be especially useful when there are many connectors originating from a single tool.

Thanks

When I perform data type conversions I sometimes receive conversion errors. There is not a slick way to programmatically handle these that I am aware of. Instead, I have to manage them with half a dozen tools or really unsightly expressions in formula tools. As an example, I have a string field with a value "two" and I want to convert to a decimal or int. I receive a conversion error and the value is either "0.000" or "0". This is clearly wrong and I want to have a NULL value instead. I want to use a function to attempt the conversion in the formula tool so i can nest it inside conditionals in a cleaner fashion.

Here is a reference to the try_cast doc:

https://docs.microsoft.com/en-us/sql/t-sql/functions/try-cast-transact-sql?view=sql-server-2017

 

 

Dear Alteryx GUI Gang,

 

I'll create a container and then customize the colours, margins, transparency, border and then want consistency for other containers.  It would be nice to have a format painter function (brush) to apply the format of one container to another.  This of course could be extended to other tools like comments.  There might be a desire to apply this to more tools too, but the comments and containers would be my focus as they are almost always custom configured.

 

Cheers,

 

Mark

Please add a toggle for Dark Mode as Alteryx, after all these years of using it, is burning out my retinas. 

 

The OS and most apps have a Dark Mode theme so flipping back to a bright white canvas is very jarring.  I tried to adjust the canvas colors in a more muted way but never can get it to work satisfactorily and still be as easy to read as the retina burning default.  

 

I would like the ability to take custom geographies and write them to a table in Exasol. We visualize our data with Tableau and rely on live connections to Exasol tables rather than Tableau extracts. One shortcoming with spatial is that we have to output our custom geographies as a .shp file then make a Tableau Extract.  This would save us a few steps in sharing this data with our users. 

 

Thanks!

I cannot seem to create a vertical or horizontal tab group of workflows. This feature used to exist in prior versions and I think it disappeared in 2018.3, the release with the revamped UI. Is it just me or is this feature gone? I do still see it in the current documentation.

I want to keep my user settings, pinned palettes, and other configurations in a file. I can keep the file versioning purposes, backups, use across multiple machines, silent installs, and other uses.

 

It will make life easier. Thank you.

Hello,

 

From my experience, an SSD drive allows a big improvement of performance when the RAM is not sufficient and Alteryx has to swap on the temp storage location. It really changes the user experience. Also, I noted a correlation with the AlteryxProcessManager::Start : ConnectNamedPipe :  error : I think it happens less with a SSD.

Given that, shouldn't be a requirement or at least a recommandation?

Top Liked Authors