Alteryx Designer Desktop Ideas

All the input tools like Input Data and Dynamic Input will have a new flag  "Skip on fail" that will process all the data, or none of the input data, or partial of the data requested and will return the data that could be read and do not return any error in the WFs.

If the 'Skip on fail' flag is false - the system should act like it is now.

if the 'Skip on fail' flag is true - the system should return the  only the accepted or manager to read data on the default out put, and can have a second output connection for the error log, so we can parse it and do something with it, but the WFs should still run,

I am a big user of the browse tool and the filter option within the browse tool. In many cases I filter on multiple columns at the same time as I'm sure many users do. I am suggesting the following 2 enhancements to filter functionality in the browse tool:

1. After applying some filters, although I can see the filter icon activate at the top of the tool, it is difficult to know at a glance which columns have filters applied without clicking on every column heading and examining the filter settings. In the event a column is filtered, a filter icon could be provided at the top of the column to easily identify filtered columns, removing the need for users to memorise filtered columns.

2. After applying multiple filters, if a user clicks onto another tool with the workflow or anywhere else on the canvas - even accidentally - all filters will be removed and the user will need to reapply them. In my view it would make more sense to make the filters persistent, or at least give users the option of doing so. Doing so would be a big time saver.

Have you ever had the business deliver an Excel (EEK!) file to be passed into Alteryx with a different number of header rows (because it looks pretty and is convenient)? Never, you say? Lies! 

I would suggest adding an option to the Input Data Tool that would give us the ability concatenate multiple header rows. This would help enable accurate data profiling for columns when output and eliminate loss from unnecessary conversion errors. Currently, the options allow us to Start Data Input on Line X; however, if the header for the column is on multiple rows, they would have to be manually entered after input due to only being able to select the lowest possible row to assure the data is accurately passed. The solution would be to be able to specify the number of rows that contain headers, concatenate them to a single row (ignoring null and carriage return) and then output that as the header. 

The current functionality, in a situation where each row has a variable number of header rows, causes forced errors such as a scientific string conversion of a numeric value.

To embed the "Not ok" filter option in the browse tool

After closing the Table or Query option on an Input Data tool, the table layout in the Visual Query Builder view gets reset to stacking the tables/views on top of each other. It would be great if the layout stayed the way I left it the last time I closed it.

Idea

Currently

Hi everyone,

Add two additional features to a directory tool. Something like this:

Use cases:

1. Since it is not possible to use a folder browse on the Gallery, this could help a basic user create a list of possible folders to select from with the help of a drop-down

2. Directory analysis for cleaning purposes - currently, if you want to get a list of the folders with Alteryx, it takes forever for big file servers since Alteryx is mapping all the files

Both are achievable today through regex or a bat script.

Thank you,

Fernando Vizcaino

Using File Browse on Excel files first of all is inconsistent between running the Analytical App in the Designer and in the Gallery:

• In the Designer, the user is not being asked which Excel workflow shall be selected.
• In the Gallery, the user is always asked which Excel workflow shall be selected.

Depending on the use case, both behaviours can be the right one:

• To load a specific Excel file worksheet, the dialog for workflow selection is appropriate.
• When working with the entire Excel file (copying, getting the list of worksheets, etc.), the dialog is not helpful.

Thus, my idea is as follows:

• Add a checkbox to the File Browse tool which determines whether the worksheet selection dialog shall be opened (and the output will be <filename>.<ext>|<worksheet>) or not (and the output will be <filename>.<ext>) in case of Excel file selected.
• Make behaviour consistent in Alteryx Designer and Gallery.

Enhancement request for the option to Encrypt ODBC credentials instead of just hashing them

For companies that have migrated to OneDrive/Teams for data storage, employees need to be able to dynamically input and output data within their workflows in order to schedule a workflow on Alteryx Server and avoid building batch MACROs.

With many organizations migrating to OneDrive, a Dynamic Input/Output tool for OneDrive and SharePoint is needed.

• The existing Directory and Dynamic Input tools only work with UNC path and cannot be leveraged for OneDrive or SharePoint.
• The existing OneDrive and SharePoint tools do not have a dynamic input or output component to them.
• Users have to build work arounds and custom MACROS for a common problem/challenge.
  • Some users have identified a work around for the dynamic input (See Community Post)
• Users have to map the OneDrive folders to their machine (and server if published to the Gallery)
  • This option generates a lot of maintenance, especially on Server, to free up space consumed by the local version when outputting the data.

The enhancement should have the following components:

OneDrive/SharePoint Directory Tool

• Ability to read either one folder with the option to include/exclude subfolders within OneDrive
• Ability to retrieve Creation Date
• Ability to retrieve Last Modified Date
• Ability to identify file type (e.g. .xlsx) 
• Ability to read Author
• Ability to read last modified by
• Ability to generate the specific web path for the files

OneDrive/SharePoint Dynamic Input Tool

• Receive the input from the OneDrive/SharePoint Directory Tool and retrieve the data.

Dynamic OneDrive/SharePoint Output Tool

• Dynamically write the output from the workflow to a specific directory individual files in the same location
• Dynamically write the output to multiple tabs on the same file within the directory.
• Dynamically write the output to a new folder within the directory

Alteryx is not able to read generated Excel sheets which have the prefix "x:" within it's XML tags.  Often this occurs when an xlsx file is created from a bot or rpa process.  Example file attached.

My team always run into the issue that two people running two workflow at the same but those workflow using the same excel flat file, then it clash into each other. 

I want Alteryx to develop a feature to allow read only capability to a input excel, that way two workflow use the same input file will not clash into each other, it's very good for running workflow in parallel, this way really increase our efficiency. 

I know this feature is not easy to achieve, we have had chat with Alteryx team before. 

I am opening to alternative solution to this problem. 

Thanks! 

My Team Heavily rely on Dremio. 

It would be great for Alteryx team to add Dremio as a dedicated data source Input for Alteryx, it would be so much easier for us to configure and run things in the future. 

Thanks! 

A new type of Browse tool which can dynamically be renamed through a field could be helpful for the cases where Analytic Apps display output results in Browse tabs. It could both help create the name of the Browse tab dynamically and create multiple Browse tabs automatically.

Being able to specify a name for the FileName field in the Input Tool configuration would be helpful for cases where a field named FileName is already present in the input data and has a different purpose than the newly added FileName field. Instead of having to use Field Info and other tools to rename the last field into something else (i.e. AYX_FileName), this would be an easier approach.

Hello all,

As of now, you have two very distinct kinds of connection :

-in memory alias

-in database alias

It happens than every single time I use a in-database alias I have to create the same for in memory since some operations cannot be realized in in-database (such as pre-sql or interface tools)

What does that mean for us :

-more complex settings operations/training/tests

-unefficient worflows that have to deal with two kinds of alias.

What I propose :
-a single "connection alias", that can be used either for in-db either for in-memory,

-one place to configure

-the in-db or in-memory being dependant on the tools you use

Best regards,

Simon

User should get an Alert that file is open when using Input Tool.  Currently Alteryx just clocks when attempting to use an open file in an Input Tool.  

From what I can tell using ProcMon, presently when using the Directory tool to list files (including subdirectories) the Alteryx Engine runs a single threaded process.

When you're trying to find files by checking recursively in large network paths, this can take hours to run.

It would be great if the tools would split up lists of directories (maybe by getting two or three levels down first) and then run each of those recursive paths in parallel. 

While it is possible to do this using a custom Python or cmd->PS command, it would be great if this could just be a native part of the application.

In the Input tool, I rely heavily on the recent connection history list. As soon as a file falls off of this list, it takes me a while to recall where it's saved and navigate to the file I'm wanting to use. It would be great to have a feature that would allow users to set their favorite connections/files so that they remain at the top of the connection history list for easy access.