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.

Have been using Alteryx GA component and found some issues, apart from the setup teething problems I was having.

So thought I’d let you know , in case it’s just not me who is suffering…

We do a fair amount of marketing for our Private business and like to measure conversion of the pipeline.

I’ve been looking at Lead -> Account -> Trade

Have been drilling into lead data with little source identifiers which are appearing in a NULL bucket..

When using Alteryx

I noticed that the Profiles for my id do not appear fully in Alteryx via the drop down..

It picks up QA profile data instead of the live profiles and does not show the whole set ?

Tableau works correctly showing the complete set of GA profiles

I don’t have the full set of profiles…

Maybe config related but why bring in some profiles and not others when I can access fine from GA directly and via Tableau ?

Trying to set these profiles and config files seemed problematic – reset to default removes the 4 config files, when you run again it doesn’t create them.

Had to keep a copy of these and put them back in manually or cpy an old widget and run a new one up from that …

Resetting the profile and saving caused other errors to appear related to the Tokens…

Found that annoying and a waste of time… immature (arghh) !

I think the Alteryx implementation is immature and not as good as Tableau and you have more work to do…! But may just be me !

Can you help improve it as I’d like to pull and blend reliably via Alteryx and do this for a range of dates to avoid sampling data

I do love the product but love this a little less than anything else …

I’d also love to be able to pull from Tableau data sources into Alteryx as we have all of our history in Tableau server

Has anyone else wanted the same ?

Obviously you can store to TDE but want the reverse… to pull from Tableau server

Below is a list of DBMS rankings as of August 2016

(for an updated and longer list see: http://db-engines.com/en/ranking)

I personally look for; HBase, Splunk, MariaDB, Couchbase, Amazon Dynamo, CouchDB connections...

I want to connect to Salesforce without Security Token.

Salesforce doesn't need Security Token when we set Login IP Ranges.

Actual Condition:

1. In Salesforce, I set Login IP Ranges like below so that Salesforce doesn't require Security Token.

2. I could connect to verify custom object definition viaSalesforce Input without Security Token

3. When workflow rub, Salesforce Input shows error message.

Thank you for considering our request.

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/

I would love the to get back the ability to use WHERE clauses in the custom SQL to manage the data that gets imported from xlsx files. I can currently use the legacy driver but would like to have that added in for the current driver.

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.