Alteryx Designer Desktop Ideas

Bulk Load for Vertica (especially with the gzip compressed format) is very powerful, I can upload several dozens of millions of rows in a few minutes. Can we have it please?

https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/UsingCOP...

The new Paste Before/After feature is awesome, as is the Cut & Connect Around.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Paste-Before-After/idc-p/510292#M12071

What would be even better is to allow the combination of the two. E.G. It is not currently possible to copy or cut multiple tools and paste before/after, as this functionality only works for a single tool that's copied.

Thanks,

Joe

I see many posts where users want to view numeric or string data as monetary values. I think that it would be friendly to have a masking option (like excel) where you could choose a format or customize one for display.  The next step is to apply the formatting to the workflow so that folks who want to export the data can do so. 

cheers,

mark

Hello All,

I am not sure whether my idea makes sense or not. 

In today's advanced analytics world, we used RPA for various automation, process simplification, etc. There are CO-BOTs that are designed to run the Alteryx flow as well. Through RPA we are able to log in to the system and tools like Cognos, Oracle, TM1, and so on.

So, I am thinking, if Alteryx developed RPA as a tool in the Alteryx Designer like other tools such as Join, Transform, ML, Computer Vision, Interface, etc. 

I believe the implementation of RPA in Alteryx will prove an Asset, and make Alteryx.com more powerful.

Thanks,

Mayank

Idea: Build a version of Designer that runs on ARM devices without requiring an emulator.

Windows 10 on ARM is becoming an increasingly popular option for new devices.  Also, with Apple's move toward ARM, virtualized instances of Windows on Mac will either need to be the ARM version or will have much better performance over an emulated version of x64 Windows 10.

Emulated software is considerably slower than native binaries, so to maintain Alteryx's fast performance, an ARM version of Designer would be the best way forward for those looking to move to ARM platforms.

The ‘Existing File Action’ configuration setting needs to address the situation where columns change.

Currently the following options exist, with instruction as follows at https://help.alteryx.com/20213/designer/microsoft-power-bi-output-tool:

There are two expectations when using this tool:

1. Reloads are built to completely replace the contents of a dataset, i.e. an Append is not being performed

2. Columns will change over time with continued development

There is therefore a need for an ‘Overwrite (update columns)’ option. However, when this Existing File Action is used it updates column names, but it does not delete the contents prior to upload. An append onto the existing data, but with new column names is therefore performed.

I acknowledge that the instructions do not say that existing rows are deleted.

This leaves the need to perform a workaround:

1. Publish with ‘Overwrite (update columns)’
2. Publish (immediately after) with ‘Overwrite (keep existing columns)’

If step 2 is not done data will be appended which would lead to duplication issues.

Either these Existing File Actions need to be renamed to be clearer as to their operation, or preferably an option that updates the columns and sets up new (non-appended) data is required.

The ability to output to Amazon Workdocs via a special Output tool would be very helpful for anyone looking into using Workdocs for personal or professional purposes.  This is similar in functionality to the OneDrive connector.

XGboost regression is now the benchmark for every Kaggle competition and seems to consistently outperform random forest, spline regression, and all of the more basic models. For those of us using predictive modeling on a regular basis in our actual work, this tool would allow for a quick improvement in our model accuracy. And I think, from a marketing standpoint, having a core group of users competing in Kaggle using Alteryx would be a great way to show off Alteryx's power.

It is readily available as an R package: https://cran.r-project.org/web/packages/xgboost/index.html

Hello all,

As of today, if you have admin and non-admin version of Alteryx Designer installed on your computer, and install Business Intelligence Suite, you are able to run either version. It will not run both versions. This means whatever reason you installed admin and non-admin version, Business Intelligence Suite will run with only one Designer. 

I installed my computer Alteryx Designer 22.3 non-admin and 23.1 admin versions, both Predictive Analytics. I also installed BI Suite admin version, and BI suite non-admin version. Alteryx will uninstalled admin version, and kept non-admin version of the BI Suite. So, I can use BI Suite only with non-admin version now.

I'm bringing this idea for your vote to make available for both profiles/versions within Designer.

Thanks for voting

I think it would be incredibly helpful for Alteryx to include a "Fuzzy Join" operator, similar to what is described in this article: http://www.decisivedata.net/blog/alteryx-fuzzy-join-workflow/

Virtually every client/project I work on, there is a nead to clean up data.  Most of the time, that involved standardizing to some existing list of data.  However, as we all know, data from differnet systems or being manually collected will not match perfectly in all cases.  This is most often when I tend to use the Fuzzy Match tool.

However, I have to use a lot of weird steps to effectively create a "Fuzzy Join", which is something I've done using database functions in the past.  I think it would be great if a new tool were created that would do the following:

• Accept two inputs, one for the "raw" data and another for the "list" of data to match to.
• Perform a fuzzy join based on similar functionality to the fuzzy match, convert data to metaphone keys and then run Jaro/Levenstein matches.  By default, return only the highest matching result.
• Expand the pre-process functionality to include words to exclude from the analysis (beyond just "and", "the" and "in").  
• Match on the whole string.  No need to try and do joins based on partial words within a string.

This seems like a very common thing (I've created a macro for this anyway) that could be made to be simpler for everyday use.

Thanks!

I have had multiple instances of needing to parse a set of PDF files. While I realize that this has been discussed previously with workarounds here: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Can-Alteryx-Parse-A-Word-Doc-Or-PDF/ta-p/115...

having a native PDF input tool would help me significantly. I don't have admin rights to my computer (at work) so downloading a new app to then use the "Run Command" tool is inconvenient, requires approval from IT, etc. So, it would save me (and I'm sure others) time both from an Alteryx workflow standpoint each time I need it, but also from an initial use to get the PDFtoText program installed.

In-database enables large performance benefits on big datasets, it would be great to incorporate multirow and multifield formulas for use within the in-database funcions for redshift

Hi - Please delete this if it perhaps exists already in a newer version.  (I am on 2022.1 and don't see this functionality.) 

I would love to see the ability to right click a tool that isn't in a container and be able to add it to an existing container.  Currently I drag it over and drop it into the container then move it back to where it was.  Inevitably I misalign the tools and spend time getting it linear again. It would be cool if based upon the choice made in the right click, it would bring the assigned container around the tool in its existing location.

OR

Perhaps within the config of the container you could choose tool #s to add to the container?

Anyways this isn't a huge need but it would be nice to see that additional functionality for people that spend a disproportionate amount of time aligning and distributing their tools HORIZONTALLY.  (Nobody cares about the people that do vertical workflows.)

With the new intelligence suite there is a much higher use of blob files and we would like to be able to input them as a regular input instead of having to use non- standard tools like Image, report text or a combination of directory/blob or input/download to pull in images, etc. I would like to see the standard input tool capable of bringing in blob files as well.

Blob InputImage InputText Input

Need an option in the output tool(Delete and append option is selected) so that if some error occur while writing into the table. workflow would automatically gets back to original record count. Right now if the workflow fails we are seeing zero records in the output table.

The new functionality of filtering within the results window is very handy but quite limited for date fields where you can only Filter by 'Is Null' or 'Is Not Null'

Can you please expand the functionality so we have the same options as within the Filter tool.

I noticed that Tableau has a new connector to Anaplan in the upcoming release. 

Does Alteryx have any plans to create an Anaplan connector? 

Hi Alteryx Team, 

Now, Connect In-DB cannot use the data connection in gallery.

User need to input those DB info as well as the login and password.

I suggest to enhance the Connect In-DB tool, so that can select/use the gallery data connection. 

From enterprise point of view:

1. No database credentials and connection properties be shared to designer user. It can reduce the risk from abnormal access. 

2. Easy to manage the access control by Alteryx Admin in gallery. Can assign the data connections to different group of users. More convenience for audit.

3. Easy to maintain the data connection by Alteryx Admin in gallery. For example, reset the database password or update the connection properties . 

On the other hand, it is better to setup in-DB data connection in gallery. 

Best regards,

Samuel

Dear Alteryx Team, 

please put an option marker /button in the formula tool to ask if the newly added column should be placed at the beginning as first column or at the end (as it is now- this could be a default setting). 

The problem is that with a lot of fields it is quite time consuming to drag and drop the newly added column from the end of the field array to the beginning. Depending on where you want to reallocate the column you might want to start from the front or from the back to drag and drop (right click holded) the column in order to reorder it. 

Mostly I would like to start from the front, I noticed. 

Thank you