Alteryx Designer Desktop Ideas

Have Alteryx have different colored lines for the different paths that come in and go out from a tool like how Excel colors references in a formula.

Please allow disable or ignore conversion errors in SharePoint List Input. 

In SharePoint List Input I see the same conversion error about 10 times. Then....

"Conversion Error Limit Reached".

Can you simply show the error once or allow users to choose to ignore the error? (Union Tool allows users to ignore errors).

I am not using that SP column in my workflow. Meanwhile I have to show my workflow to a 3rd party within the company. SO annoying to see errors that do not apply to my workflow being shown.

Currently there are forecasting tools under time series (prediciting for the future). But can a back casting function/tool be added to predict historic data points.

I would like to suggest that right-click on the tab allows the user the ability to EDIT the workflow name/path and save updates by use of an ENTER key press.

Cheers,

Mark

My Backstory:

I am currently what you would call an "independent" data analyst.  I currently work for a major US based bank and I am trying to change roles to a data analytics role within said company.  Many of our data analytics teams use (or are migrating to) Alteryx.  I myself love the program.  I have now attained the Core certification.  As I have yet to be hired as a data analyst I am currently independently learning and building skills...but as of right now, it seems that data analytics is more of a hobby. 

Issue: 

I think there are a lot of people out there who are in my shoes.  They are either migrating to a data analytics role or are a former analyst just wanting to keep doing what they like doing or are freelancers.  Alteryx is an amazing tool.  But, the big issue is that we can get the free cert/license...but after a time...we will lose access at some point.  Unless we find an employer who can purchase the license for us.

How it Effects the parties involved: 

As stated above, I love Alteryx.  I would absolutely love to continue using it.  But, I am not in a place right now where my company is considering me for a data analytics role.  I also barely make enough to survive and would probably take me a lifetime to raise the funds for a full license on my own.  In the end, if i were to never get a data analytics role with my current employer or new employer that would be able to give me access...I would have to seriously think about abandoning the Alteryx system as a tool as I cannot spend $5000 on a what is currently a hobby.  After my learners license time is up...what do I do?

Now as for how it effects Alteryx...I would think that having people chose whether to use the software or not use the software because of financials wouldn't be the best option for business.

A Possible Fix:

A monthly subscription license.  You could have a lite version where the advanced tools are not usable.  Maybe even make a tiered subscription model.  For example, a Core subscription that has the core learner tools and maybe some of the other tools that would allow someone to do basic analysis.  Then a more advanced tier with more tools for a higher monthly rate.  And so on...

This would allow people such as myself the ability to continue to use Alteryx...and spread the good word about it to others.  It would also allow people to continue to truly master the software.  I imagine this could also make Alteryx more of a name brand within the data community...and bring it to the attention of other corporations who would then have a user base coming into the company WITH the more advanced skills to use the system built-in.  Rather than a company adopting software that they then have to train the users and going thru the growing pains of that.  Again, we would-be-monthly-subscribers wouldn't need all the fancy tools.

To wrap it all up, I love Alteryx.  I wish I was able to continue using it.  But, as I near my learner license end date, I have to think: how am I going to continue?  Do I just hope and pray I eventually find a department/company who will let me back into the cool kids club?  Do I look for something similar and move away from this simply because I have access?

I appreciate you taking the time to hear me out.  😀

The chart tool is really nice to create quick graphics efficiently, especially when using a batch macro, but the biggest problem I have with it is the inability to replace the legend icon (the squiggle line) with just a square or circle to represent the color of the line. The squiggly line is confusing and I think the legend would look crisper with a solid square, or circle, or even a customized icon!

Thank You!!!!

いつも大変お世話になっております。本日は、製品の動作環境についてご相談させていただきたく、ご連絡いたしました。

弊社のお客様の中には、Windowsのユーザー名やフォルダ名に日本語を使用している方々が多く存在します。

現状、こうした日本語環境でのAlteryx製品の動作保証が明確にされていないため、問題が発生した際の対応に困難を感じております。

したがって、Windowsの日本語ユーザー名、または日本語のフォルダ名を使用した環境における

Alteryx製品の動作保証について、再検討をお願いできますでしょうか？

これにより、お客様へのサポートがより円滑に行えると考えております。

お忙しいところ恐縮ですが、具体的な方針や計画についてご教示いただければ幸いです。何卒、よろしくお願い申し上げます。

Some of the predictive tools put out a "Score" field when output is run through the scoring tool, and some put out a "Score_1" and/or "Score_0".  Since I frequently reuse the same workflow template for different predictive model types, it would be nice if they were consistent so that I wouldn't have to crash the workflow the first time through to get the input field names correct for downstream tools (e.g., Sort).  Thank you

The default variable size is a V_WSTRING of size 1073741823.  If no one catches this, it uses up the memory on the server.  Could the default be smaller?

Wouldn't it be great to be able to pick results from a drop down, based on the up-stream tools in the workflow? I had this situation many times, where I had to create a complex, chained app, just because the tools connected to the interface can't run before the interface tools are displayed to the end user.

For example, imagine an app, that based on what column it sees, it lets you drop one by just picking it from a drop down. It would open many development opportunities, and decrease the number of chained apps we need to build.

I have long and large workflows, IMO, that are getting difficult to follow. I'd like the ability to highlight the joins and set specific colors or at the very least highlight and toggle on/off highlights. I'd also like to be able to move my joins and so they are not curving all over the canvas.

Idea to have the option to include the workflow "meta info" (last tab of the workflow configuration when clicking on the cavas) when printing the workflow.

The Meta Info desciption and author sections would be particularly of value. Currently on the long file name is embedded in the header.

Add the ability in the select records tool to use formulas not just record numbers. 

Many of today's APIs, like MS Graph, won't or can't return more than a few hundred rows of JSON data. Usually, the metadata returned will include a complete URL for the NEXT set of data.

Example:  https://graph.microsoft.com/v1.0/devices?$count=true&$top=999&$filter=(startswith(operatingSystem,'W...') or startswith(operatingSystem,'Mac')) and (approximateLastSignInDateTime ge 2022-09-25T12:00:00Z)

This will require that the "Encode URL" checkbox in the download tool be checked, and the metadata "nextLevel" output will have the same URL plus a $skiptoken=xxxxx value.  That "nextLevel" url is what you need to get the next set of rows.

The only way to do this effectively is an Iterative Macro . 

Now, your download tool is "encode URL" checked, BUT the next url in the metadata is already URL Encoded . . . so it will break, badly, when using the nextLevel metadata value as the iterative item.

So, long story short, we need to DECODE the url in the nextLevel metadata before it reaches the Iterative Output point . . . but no such tool exists.

I've made a little macro to decode a url, but I am no expert. Running the url through a Find Replace tool against a table of ASCII replacements pulled from w3school.com probably isn't a good answer.

We need a proper tool from Alteryx!

Someone suggested I use the Formula UrlEncode ability . . .

Unfortunately, the Formula UrlEncode does NOT work. It encodes things based upon a straight ASCII conversion table, and therefore it encodes things like ? and $ when it should not.  Whoever is responsible for that code in the formula tool needs to re-visit it.

Base URL: https://graph.microsoft.com/v1.0/devices?$count=true&$top=999&$filter=(startswith(operatingSystem,'W...') or startswith(operatingSystem,'Mac')) and (approximateLastSignInDateTime ge 2022-09-25T12:00:00Z)

Correct Encoding: 

Idea:

Similar to the Formula Tool how it shows an example based on the first record. Could the Filter Tool have a example based on the first record showing how the formula in the filter would handle that record? It would either show in an example field for the true sample or false sample based on the criteria. I feel this would be very useful for more complex formulas such as AND/OR.

Ex.

Filter Formula: [Count] <= 1

True Sample: [Blank]

False Sample: 4 (Value of first record which was filtered from [Count])

Currently, the Parse Address tool cannot parse a field where the entire address, including so-called "last line" information (city/state/zip), is in all in the same field - it can only parse a street address contained in one field and last line information contained in a second field.  Can this tool be enhanced so that it can parse a full address in a single field?

Need a tool that can remove nulls in 2 ways:

1. Remove rows with null values

2. Remove columns with null values

Save/Load Unique Key Tool Configuration – similar to saving/loading other tools configs  (ie: select, join, append, etc)

For the summary tool, allow for the field data definition type of the output.