Alteryx Designer Desktop Ideas

Would love a tool where I could do Weighted Averages etc.

 

Ideally be able to write: SUM(Price * Volume) / SUM(Volume) and it would work.

HI!  Love Alteryx.  I have a parameterized macro output tool that has 16 parameters linked to as many fields from my batch file.  The number of parameters is high enough that I have a scroll bar on the on the Config window. 

 

Just out of habit I use the scroll wheel to scroll to the bottom, but by doing so completely blow out the config of the fields-to-parameters mapping because you can use the scroll wheel to also change the fields that are linked to the parameter.  Then I have to go through all the parameters to set them back to the way they were before, which is tedious.  I would like the macro tool to only change the field-to-parameter mapping by clicking, not by scrolling the wheel.  That will keep from a bunch of setting and resetting of the parameters.

 

Thanks, Kurt

Hi!

 

It would be cool if the Overlap tool also worked with report layouts, instead of just the map image. For example, once I've pieced my different report tables into one layout, it would be cool if I could just add my company logo using image tool, add a Overlay tool, and add the logo to the top corner of my finalized report. I realized there are other ways of doing it, this would seem the most straight forward though. Just an idea.

 

Background:

Teradata is a high performance database system.  It is highly sensitive to indexes and balancing the records across each index segment.

Teradata uses Spool to perform queries on the database.  It is also very sensitive to type of table (volatile, temp, permanent) created.

 

Issue:

Alteryx "In - Database" nodes are not providing the ability to configure them to Teradata needs.

As a result, when executing workflows with "In - Database" nodes there is high probability of "out of spool" error specially when working on medium size data base (between 250 million to 1 billion records).

 

Impact:

Question mark on the ability of Alteryx to handle medium to large databases.

Knime and SSIS are currently preferred to Alteryx

 

Action Requested

Please change the configuration of the "In - Database" nodes to allow fine tuning of the node behaviour.

 

 

Currently the Throttle Tool allows control to a number of calls per minute. Some APIs include a limit to the calls per hour and a combination of throttles. I would love to see the option to choose the number of calls per hours and have 2 limit controls (eg 100calls per minute and 100calls per hour)

The RegEx tool has a drop down list so that user does not need to go KnowledgeBase; the specifier list should be added to the DateTime tool so user has a quick reference.

 

Users would benefit from this concept if done elsewhere as well

Disabled Containers throw errors if it contains any interface tools. It should not throw any error as the user is intentionally disabling the container.  

 

I have a 3 year license but am required to activate the license key each year. Is it possible to get the activation period matched to the duration of the purchased license? This would not only remove the need to update each year, but would also clarify the actual duration of the licence too.

From discussions the new distribute auto spaces when distributing. Any chance we can get a spacing setting in the user settings. Settings would be like we do our grid spacing except we would separate the horizontal and vertical spacing(set number of pixels for horizontal/vertical). This would allow people to have a different vertical spacing compared to their horizontal spacing. Particularly helpful for heavy formula usage. Thanks.
Also take into account ability for it to stay snapped to grid. Example I use a 72 px grid size for ease of lineups. With the new distribute it pulls between those grid snaps

Change the sample tool to have an allow all records option.  This will allow you to include the sample tool in a production workflow and will be a constant tool to allow you to debug the workflow if necessary.  This will prevent you having to delete and re-add the sample tool everytime you need to use it.  Could also have a workflow option of 'set samples to all records' which you could click on when publishing to Gallery.

Hi,

 

I was told this feature is working as intended/designed, so I decided to post an idea to see if there was interest in the feature I'm looking for.

 

In debugging a workflow that another Alteryx user at my company was developing, we realized that an in-db connection was inadvertently pointing to the wrong environment.  Because of how in-db tools output messages, there wasn’t anything visual pointing to this as an issue without manually inspecting the connection in “Manage In-DB Connections”.  Since I’ve encountered some challenges with In-DB connections before, I suggested using the Dynamic Output In-DB tool, which I’ve used before for the “Input Connection String” option.

 

What I had never done before, and didn’t realize until I tested this, was use this with a connection that leverages an embedded SQL Server account username/password.  When using this type of connection, an error is thrown that says: “              Dynamic Output In-DB (1)             To use this tool select an appropriate data source and select the "Allow Decryption of Password" Password Encryption option in Manage In-DB Connections.”.  However, the tool still works and appropriately pulls the connection as it exists.

 

 

For security reasons, we don’t want decrypted passwords floating around in this information, and we can’t enable “allow decryption of password” in our server environment.

So, my request would be to either add logging to In-Database tools to pass the connection string information (similar to regular input tools), or to add a method for outputting a connection string without a decrypted password that doesn't cause an error in Alteryx.

 

Screenshots below for reference.

 

 

Assume users using AD login/ password to access gallery. 

And they are using individual AD account to login database with different access right.

 

Now, if we want to use individual account in the gallery data connection.

We need to get the user password and create many data connections in gallery 

 

If input data tool can pass the gallery login/password when user try to use gallery data connection to connect the database. 

We only need to setup one data connection but have individual access control.

 

For example, user A and B have different role in a oracle database. 

Even they use the same gallery data connection, they will access different table/view. 

Hi, i am from ETL back ground and coming from my knowledge i would like to suggest or ask a feature which will helpful in alteryx solution.

 

"Error Line" : many ETL tools provide an "On Error" line which performs certain actions like "altering user by sending an email", "ignoring and going to next step" etc. It will be great if Alteryx can provide the same feature where we can have an error line (red line) for each tool.

 

Hope this is not a repeated idea. thank you for all the support and providing a wonderful tool.

 

Thanks,

Harika K

It would make it a lot easier to create and manage a work stream if you added the standard ability to maximize and minimize the workflow canvas and configuration and results windows.

Constantly using rand() function but also need;

 

• Normal distribution function like we have in Excel and
• Triangular distribution function too...

Idea: can we please add normdist() and triang(min,mode,max) functions...

 

Best

 

Edit: for normal dist. attached a discretized example...

This is not a terribly important thing, but in the formula tool, the nitty gritty details of the Expression almost never fit into the annotation space. It would be nice if the annotation by default just contained the names of the variables being derived.  So, e.g. if I'm deriving "CalcVar1", "CalcVar2", "CalcVar3" and so forth, the default annotation would just be:

This gives a much cleaner (by default) canvas.  The same concept applies to the MultiRow and MultiField Formula tools, perhaps others.  Just a thought and obviously not very important.  Thanks.

 

It would be useful to have a function or a tool to convert a number into a currency like excel.  Where it would add the $ before and you could choose to have commas and a period for cents.  

ex:  

Input:  15978423.89

output:  $15,978,423.89

 

 

of course, i'm sure there would be a need for other currency values besides the '$'.  

 

 

 

 

 

 

 

 

 

 

415978423.89

I think that it would be nice to be able to append a Time Stamp to the name of a file in the OUTPUT Tool, as a Mainframe Programmer I could append a time stamp to file names this is helpful when doing batch jobs that are scduled on a server. 

Hi,

 

I've been using desktop scheduler to download and parse out a streaming JSON file.  My script takes 4 seconds to execute, the data is updated on a per second basis.

 

Currently, my only option is to execute the scheduled job at the lowest level of granularity in the temporal at 1 minute. therefore I'm missing records.

 

Would it be possible to add a second(s) option to the scheduler?

 

I can see particular benefits from doing a CRON at under a minute, especially with event data capture.

 

Best Regards,

 

Allan