Alteryx Designer Desktop Ideas

In the Output Data tool, when the file type is YXDB, one of the options is to Save Source & Description.

Splitting these into "Save Source" and "Save Description" -- independent options -- would be useful.

Sometimes I don't want the file recipient to know how a field was derived but I want to include a description.

Right now there is no easy way of doing this.

Occasionally, the Calgary Loader tool will not write out all fields passed to it.  This seems to happen after writing out a certain number of fields then later, when rerunning, adding a new output field.  Very annoying because you don't know it will happen until processing is complete and you examine the result.  I usually manually delete the calgary files prior to rerunning, to avoid the versioning, but it still happens.

Also, please make the versioning optional with a check box, default off.

Hello,

I work with alteryx databases a lot to store some historical data so I don't have to pull it in the future. It would be great if there was a way when creating the database, where I could lock them for editing and can only be edited by select usernames and passwords.

Thanks,

Chris

Hi all,

I often feel like workflows can easily become overly cluttered with Browses, especially around Join and other multi-output tools. I need to see the output of most of the data streams, so I can't necessarily just delete the Browses and be done with them (as I'll like need to see them over and over again).

To solve this problem, Alteryx could potentially add a "nested browse" view or tool. I've attached a picture to show what I mean. This would unclutter the area right after multi-output tools significantly.

What are your thoughts? Have I missed any neat trick or functionality that can already do something like this?

Nested Browse View Idea

I would love to see the ability to have a hyperlink (or even more formatting options) in my app output message. 

Currently I when I have an app that runs and I want my users to move off to a different web location they have to copy and paste the url that I have rather than just clicking a link and going to the external report.

I setup a generic template because the excel files do not have a consistent schema.   This is the template

which is interpreted as text

When I feed files into the dynamic input tool the output configuration is

This is the schema of the first file read by the DI tool.  Why didn't it use the template?

The requirement to have all the schemas match is difficult - especially with excel.

I would like to suggest the input tool have a checkbox to override the data driver and interpret all columns as text.

Read excel as text

https://www.connectionstrings.com/ace-oledb-12-0/treating-data-as-text/

The file geodatabase reader is very cumbersome especially when navigating through a server directory. Can this be fixed or reworked?

It would be awesome if we could perform a 'create or replace' on an excel file with the output tool. The tableau TDE extract has an output option that says "Overwrite existing extract file (Create if does not exist)" If the excel file format option could have this same output option that would help out a ton!

The Directory Tool would be more useful if it could output the file extension as a separate field.

Currently excel files with top lines frozen do not read into Alteryx. This causes extra manual work, as a default setting for the output of one of my reports freezes the top line automatically.

Give the option in the tags properties to place the tag to the right of the tool. 

Have this be the default setting for Browse and Output tools or others that would normally be found at the end of a workflow. This allows the detail to remain and a cleaner view of the module.

Please ignore this post! I just discovered the amazing dynamic input tool can accomplish exactly this 🙂

This is no longer a "good future idea" but simply a solution already provided by AlterYX!  Thanks AlterYX!

Hello everyone. I think it would be incredibly helpful if all input tools (database / csv files / etc..)  had an input stream for data processing.  

This input stream would cause the tool to fire if and only if at least 1 row of "data" was passed into it.  This would work similar to the Email tool, as the input would simply not fire if no records in the workflow were passed into it.

By making this change, AlterYX could then control the flow of execution when reading / writing to database tables and files without having to bring in Macros or chained applications.

The problem with having to use batch macros and block until done to solve this problem is that it obfuscates your workflow logic, making it much harder for another developer to look at the workflow and understand what is happening.   Below is an extremely simply example of where this is necessary.

Example: any time you are doing a standard dimentional warehouse ETL.

Step #1: Write data to a table with an auto-incremented Key

Step #2: Read back from that table to get the Key that you just generated

Step #3:  use that key as a foreign key in your primary Fact table.

Without this enhancment you need at least 2 different workflows (chained apps or marco's) to accomplish the task above, however with this simple enhancement the above task could be accomplished in 3 tools.

This task is the basic building block of almost all ETL's so this enhancement would be very useful in my opinion.

When attempting to connect to an oracle database, if the connection is unsuccesful, nothing happens so you just sit and stare and wait for the SQL window to pop up.  It would be helpful if there was an error message to tell you that the connection was unsuccesful.

It would be very helpful to have a SOQL Edit textbox for the entire SOQL statement not just the WHERE clause.   This would allow us to select fields based on parent or child relationships to the table as well.

In the designer it would be nice if the projection of a .shp file could automatically be read by its corresponding .prj file.

Just ran into this today.  I was editing a local file that is referenced in a workflow for input.

When I tried to open the workflow, Alteryx hangs.

When I closed the input file, Alteryx finished loading the workflow.

If the workflow is trying to run, I can understand this behavior but it seems odd when opening the workflow.

Hi,

Today I pressed F1 in the Output Tool to find out what the setting Transaction Size does. It turned out that this is not documented.

It would be a great idea to make a documentation that covers the options of a tool.

Regards,

Frank