Alteryx Designer Desktop Ideas

I need support for outbound data streams to be gzip compressed.  Ideally, this would be done by a new tool that can be inserted into a workflow (maybe similar to the Base 64 Encoding tool).  Just including it in the Output Tool will not address my needs as I will be sending gzip payloads to a cloud API.  There are two main reasons why this is necessary (and without it, quite possibly a roadblock for our enterprise's use of Alteryx):

1. Some APIs enforce gzip encoding, therefore Alteryx cannot currently be used to interact with such APIs
2. When transmitting large volumes of data across the Internet, gzip compression will significantly decrease transmission times

When using Alteryx from an enterprise, the understanding of all of the known Alteryx domains should be documented.

https://www.alteryx.com/

https://community.alteryx.com/

https://help.alteryx.com/11.5/index.htm

http://downloads.alteryx.com/

https://gallery.alteryx.com

Are there more domains that should be put onto the white list or is that the total set of websites necessary to use Alteryx without firewall issues? 

When downloading files from Alteryx, we also want to list the types of files that we should allow users access.  For documentation, I expect that we will see PDF files.  For installs, either ZIP or EXE files?  

When it comes to setting rules, the more information the better.  Otherwise, users may be blocked and not able to use functions.

Thanks,

Mark

This appears to be a bug with either the Layout Tool or the Render Tool. When I setup two Tables using the Horizontal Layout Tool and export to Excel using the Render tool, the font size of the bottom-right cell of the first table is too large. No amount of changing the font properties within the Alteryx Reporting tools appears to fix this.

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.

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?

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 :

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 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.

The DateTimeParse function always works if there are leading 0 but if one digit day of month or month it can be harder to parse

In some corporate instances that I have encountered, browsing to the internet is not supported. What I've also seen is private instances of wiki media and yammer. Perhaps we could extend the browse to support these types of instances.

Cheers,
Mark

Would be great to see a 'built-in' select on the input tool.

Appreciate you can do this when connecting to dbs but nearly every time I (and I believe most others) use the input tool to connect to a file, the next tool I use is a select tool to rename/remove/change type of the incoming data.

If there was a select tool 'built-in' to the input tool (as the mocked-up image below shows) it would offer three key benefits:

1) quicker for the user

2) cleaner workflow view (especially in workflows with multiple input tools, each subsequently followed by select tools)

3) more intuitive for new users - after all, they are the future of the Alteryx community 🙂

File Input Select

Thanks to members of this forum I have now got my head around how the Run Command tool works and find it incredibly useful. The documentation around the tool is minimal (only this community really...) plus the naming of the items isn't always obvious what values they expect to have entered.

This is one of the most powerful tools in the Alteryx toolset, with Run Command it's possible to do more or less anything you want using Alteryx, it's just unfortunate it's highly opaque how to use it with the existing documentation.

For example it's far from clear what input should come into the tool. I now know you can write a command line script in a formula tool and only bring that script into the tool, which will then create that script and save it based on the name given in the Output section. There is no way to know this using the documentation within Alteryx. Then you can run this script you have somehow created in the Command section just by entering the file path of this currently non-existent bat file.

How you're meant to know the button Input will then output the results of the script, assuming the script was written to output the results, is still a mystery.

Naming the components of the tool more appropriately would be a good start, although I admit not simple to do. Introducing a detailed help section with a few examples would be very useful and unleash far more Alteryx power to more users.

Even with browse everywhere I see plenty of workflows dotted with browses.  Old habits die hard.  Maybe a limit configuration for browses would be a good thing.  If you've recently browsed a very large set of data you might agree.

Cheers,

Mark

Dear Alteryx Team,

Dynamic Input Tool is a great tool to import easily multiple files using files paths parameters ... having the same tool for outputs would be great to export many files in pre-established folder.

Many thanks

Arno

I think the Nearest Neighbor Algorithm is one of the least used, and most powerful algorithms I know of.  It allows me to connect data points with other data points that are similar.  When something is unpredictable, or I simply don't have enough data, this allows me to compare one data point with its nearest neighbors.

So, last night I was at school, taking a graduate level Econ course.  We were discussing various distance algorithms for a nearest neighbor algorithm.  Our prof discussed one called the Mahalanobis distance.  It uses some fancy matrix algebra.  Essentially it allows it it to filter out the noise, and only match on distance algorithms that are truly significant.  It takes into account the correlation that may exists within variables, and reduces those variables down to only one.  

I use Nearest Neighbor when other things aren't working for me.  When my data sets are weak, sparse, or otherwise not predictable.  Sometimes I don't know that particular variables are correlated.  This is a powerful algorithm that could be added into the Nearest Neighbor, to allow for matches that might not otherwise be found.  And allow matches on only the variables that really matter.  

Would be nice to make it so if I change from RowCount to index it all is linked together.

Something like a $FieldName$ which would automatically get substituted. 

Also nice in other formula tools, but most useful in places where name needs to be duplicated over and over

It would be helpful to have the Read Uncommitted listed as a global runtime setting.

Most of the workflows I design need this set, so rather than risk forgetting to click this option on one of my inputs it would be beneficial as a global setting.

For example: the user would be able to set specific inputs according to their need and the check box on the global runtime setting would remain unchecked.

However, if the user checked the box on the global runtime setting for Read Uncommitted then all of the workflow would automatically use an uncommtted read on all of the inputs.

When the user unchecks the global runtime setting for Read Uncommitted, then only the inputs that were set up with this option will remain set up with the read uncommitted.

The Legacy Excel output Driver has the ability to Delete Data & Append as an output option for Excel files.  This is useful to retain custom formatting and conditional formatting on a worksheet.

However, the new Excel Output Driver and Macro-Enabled Excel Driver do not have this option.

I think this would be very helpful for a lot of our business needs, as we still use Excel for a lot of our reporting needs.  I know that Tableau is a very powerful tool for exactly this sort of situation, but we do not yet have any widespread adoption at our company.

Particularly, conditional formatting would be a fantastic option, as it would save a lot of post-run manual process.

In the summary tool, we often use the summary tool to concatenate strings - we love this functionality.

However, we would also like to be able to concatenate just the unique values of strings. This could be done if we ran the preceding text field through the unique tool first, and then concatenate. But when we are doing this for multiple text variables and when we need to summarize other types of data at the same time, this becomes a very un-natural combination of joins & macros. 

Thanks for considering,

Jeremy