Alteryx Designer Desktop Ideas

The Formula tool has lower case, upper case, and title case. But I often need to change multi-word notes text to sentence case, where only the first letter is capitalized. Instead of having to write a special formula, it'd be nice to have a sentence case function.

this is lower case

THIS IS UPPER CASE

This Is Title Case

This is sentence case

Python tool could be useful... for those who need it. Otherwise it just takes time to install and disk space, or even be a security problem for some companies.

Why not make its installation optional so that people could chose to install it only if they need it, or choose to install it later (like the predictive tools for example). 

Thanks,

PaulN

Hi

Support was added in 2018.4 for conditional update and deletion of rows in a SQL Server table (ODBC) based on incoming records, however Azure SQL Server is not supported.

Surely support for Azure should not be difficult to add given other SQL Server implementations are now supported?

See original idea here:

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-Database-Update-and-or-Delete/idi-p/13153...

And 2018.4 release here:

https://help.alteryx.com/ReleaseNotes/Designer/Designer_2018.4.htm

Thanks

I like the cool new features in designer 11.x

However, to my surprise when I searched for a sum() function..... it wasn't there yet

Math bucket has common functions such as Average, Mod, Median and some very complex functions such as Hyperbolic Tangent (an average user don't need it)

But a basic mathematical logic is missing : SUMMATION

Please add SUM() as a function

In Alteryx 11 the formula tool got redesigned but multi-field and multi-row tools have been left as it. It would be nice to have formula autocomplete and other new features in these tools as well.

I see the ability to increment the Vertical Axis on a chart, but not the dates on the Horizontal Axis (data is in date format).  This is unreadable for the data I am trying to present, even after changing font.  Would like to show 1 date per week, instead of every day (for example).

Thanks!

Gary

The recently added feature to sort and filter entries inside the Results Window of the Browse tool is great. However, once I open a new window with the result, the functionality dissapears and I am stuck with a static table where I can only scroll through.

Would it be possible to add the filter and sort funtionality to a new window as well?

Please let me know if I've overlooked a suggestion and I'll be glad to upvote that post.  

I think it would be great to be able to convert a Browse tool to an Output tool.  I always work with browses until I have the product that I want, at that point I'll bring in the output tool.   The ability to right click and convert, would be great.

Pretty simple one here - I would like to have an option in the UI to clear all Input Data caches or even a right click/properties option to clear an individual Input Data cache.  Often when developing, I use the Cache Input Data option to speed up development iterations.  However, if I modify the source data during the development, I am unable to easily clear the cache and often turn caching off to avoid stale data.  The "easiest" way I have found to do this is to pull the temp yxdb file paths out of the log after a recent run, clean them up using notepad++, put a del statement before each file, and paste them into a Command Line.  This inefficiency often offsets the development speed realized by caching.

Please add an append fields component to the IN-Database components.  And also allow the adding of fields to the in-db formula component.  It seems to be really difficult to add a field into the data stream when using IN-DB components.  Would be good to resolve this and try to make the IN-DB components consistent with the standard ones.

I would like to share some feedback regarding the Principal Component tool.

I've selected the option "Scale each field to have unit variance" and 1 of the 4 PCA tools was displaying errors. However, the error message is not very intuitive and I couldn't use it to debug my workflow. The problem was that for my type of data, scaling could not be applied since it had a lot of 0 values.

Couldn't find anything related to this, so hope my feedback helps others.

Thanks!

Hi all,

We were working through some ideas with @BenG and @KatieH about how we can streamline the process of understanding data at the point of bringing this into Alteryx.

We currently have a visual way to see columns that have leading whitespace or null (with the visualitics that have been added to the browse tools) - we can take this further:

• After any input tool, alteryx looks at the data to see what can be done to help cleanse:
  • for columns that look like they have dates - check cleanliness and offer to add the required tools to get these into a clean date format
  • for columns that look like ZIP codes - offer to check vs. US ZIP codes and cleanup
• For columns that have leading or trailing whitespace - offer to add a tool to the canvas to clean this up
• For number columns that have nulls - offer to add a default
• For columns that have strings that contain dates - quick wizard for any anomalies and then add in the tools to automate this cleanup next time.
• For columns which are XML - offer to check this for XML errors
• For any CSV files - check for rows that have different number of columns - and intelligently sideline these

Putting this wizard immediately after input tools, which would then automatically add tools to the canvas to automate the cleanup that we'd agreed during the wizard - we can dramatically reduce / eliminate the cost of the standard data prep tasks.

NOTE: This is exactly how Watson Analytics works when you bring in data, and it makes the process much quicker.

As of today, we cannot choose the field separator when we read a csv file. In France, the common separator for csv is the semi-colon (;)

It leads to this kind of thing in a filter :

Since I am a new user I am not sure if there is already a way to customize sort order in Alteryx.  In Excel it is possible to use a saved list to define a sort order.

One example is where the sort function uses the labels for months of the year.  Instead of ALPHA ORDER in the ouput you might want to see the MONTH ORDER. 

Excel supports an alternative sort order through the use of custom lists. Some custom lists are provided with the software and users can add their own custom lists.

The Excel interface for sorting using custom lists looks like this:

I was trying to download zipped text files from Amazon S3 Bucket using Amazon S3 Download Tool.

Unfortunately the tool allows you to choose between csv, dbf and yxdb files and there is no option to select Zipped Text.

It will be very useful if this feature can be provided as most of files available on S3 are large files and are generelly in Zipped format.

Normally I have no issue with the splash screen but I've found with analytic apps that the splash covers up the App dialogue box.

I'm aware that you can click on it to hide it but having the option to disable it (even just for apps) would be great.

I've had the need to Find & Replace inside of a formula that I've written.  Would it be possible to have that type of functionality inside of the expression builder?

Does anyone else think that it would be useful?

I think it would be a nice feature if a user were able to export the list of tools and annotations in a way to use as the foundation of a process memo (or simply listed sequentially in an appendix). We're using Alteryx for tax data prep processes and documentation of the process is important.  So I believe getting the workflow into words would be a great addition.

Currently, the dynamic input tool reads variable types for two same variables in two different files as different. This causes an error while importing the files. e.g. A field called X in one file has type "double' while the same variable in other file would have type 'V_String'. The dynamic tool would give an error in this case saying that schema is different. Though its not.