Alteryx Designer Desktop Ideas

hello,

Recently I used the optimization tool and it's awesome. However, there is no option for sensitivity analysis and It would be great to see it in a future version. Thank you!

King regards,

Teradata has a feature called query banding where a group of queries or more commonly a database session can have additional metadata tagged onto all of the individual queries. The Teradata workload management engine can use information provided in the query band for use in prioritizing query execution and resource allocation.

With normal input tools, the query band information can be populated in the "Pre-SQL" with a query such as:

SET QUERY_BAND = 'org=Finance;report=Fin123;' FOR SESSION;

However, with the In-DB tools, there is no concept of pre-SQL, and no great way to set the query band for the In-DB queries Alteryx submits. We would want to set the query band at the workflow level for performance prioritization and resource allocation monitoring purposes. 

Best regards,
Ryan

A function to generate relevant Random Mockup data to replace existing data or create new test data sets.

Insert into fields mock data for First Name, Family Name, Email Address, Country, Regular Address, Payment amount and information, etc.

This would be easy to code and could be used to easily replace existing fields with made up fields or jumbled up fields or numbers e.g. payment amounts randomised to a similar size and shape.  There are a number of internet sites that already provide this service but it would be so much better to bake this directly into a tool that allows you to generate random datasets for testing and anonymisation of existing data for demos etc.

This would make users of Alteryx much more productive and allow them to preempt datasets and allow much more rapid creation of solutions.

As per this discussion, I'd like to create constants that stay with me as I create new workflows rather than creating a user constant across multiple workflows.

This could perhaps be done by editing an xml file in the bin.

As you know, Developers and Analysts are very picky when it comes to their UI preferences. Regardless of their preferences, providing the option to change these settings is the KEY.

Currently, in the latest version, under the Edit User Settings menu option, there is no way to change the dark background colour of the Menu palette which comes by default with the new version. Give us the ability to customize this please.

Thanks!

Development can get super slow for larger workflows with the automatic syntax checking.  Would be nice to flip to "Pro Mode" that pauses the syntax checking until either un-paused or a run is kicked off to save on the wait time between tools during development and more particularly going back to make numerous changes.

Having the ability to minimize the toolbar would allow more screen space.  Once minimized, the tools should display when you hover over the tool category tab.

I'm looking to optimize how we allocate licenses at our organization.

Seeing who has a registered license via the public Gallery has been helpful; but is there a way we can quantify usage?

Possibly a tool usage or an overall workflow run count?

Alteryx's spatial tools are really powerful and offer a lot of value for analysis.  However, when rendering a map for output, there is currently no way to place an image inside of a polygon.  This feature would be very useful for customized layers on maps and other spatial-based processes.

My rough suggestion would be to scale a selected image to the size of the polygon's bounding rectangle, and then trim the edges of the image to fit inside the polygon itself.

The SharePoint List Input tool currently doesn't retrieve managed metadata columns from SharePoint lists (confirmed by @DanC in April 2018, Pulling Managed Metadata from a SharePoint List). This severely limits our use of the tool, as imports in Alteryx lack most metadata that is relevant for analysis and reporting.

Would be great if this could be added in a future release.

Thanks,

Lars

I think the Cache and Run Workflow option is a good addition in Alteryx 2018.3 but I think it needs more work to be useful.

For example I build a simple workflow where each tool is fed in by one tool and is used by one tool. So you have a sequence of tools. A -> B --> C --> D -- > E

Say I build A -> B -> C and I put a Cache and Run Workflow option on C, it will run the workflow and cache the output out of C.

But if I build D and E onto it after that event and put the option Cache and Run Workflow on E, it will run the whole workflow ignoring the cache output from C.

Can it be changed where E's Cache and Run Workflow will respect C's Cache and Run Workflow?

Thanks,

Mathew

Hi Community:

Is anyone else annoyed that the default Output Options for the output tool usually need to be changed? What I've found in my couple of years of using this (wonderful) tool is that for Excel and Tableau outputs especially, the default is always 'Create new [sheet OR Extract File]'. 

But when you use that option for your output tool, you can't use the Alteryx flow again; you get an error (Sheet already exists you moron, or Extract already exists stupid) (c'mon, you know Alteryx is judging you and the strikethroughs are there in spirit).

The 'stupid' is silent

If you ever want to run your workflow again, you've got to change it to 'Overwrite [Sheet (Drop) OR Existing Extract File (Create if does no Exist)]'. 

I'm not sure about you, but I've been (passive aggressively?) hoping that with each new release of Alteryx, I would get a means to change my defaults. I would LOVE the option to have my output tools default to the overwrite, rather than create, option automatically. That one step is just... annoying to do over and over again. 

So, I'm not going to be a passive-aggressive twit any longer. I am formally asking for what I want like an adult.

Can I please have an option in Options>User Settings>Defaults with a drop-down for Output tool preferences: Create by default, Overwrite by default, Append by default, and whatever the other options are generally categorised according to how the Output tools are done? I really only care about the overwrite one, but you're getting my gist at this point, right?

Thanks so much!

-Cedric

Colourless Green

There are a several ways to store the Avro schema in Hive:

1. Literal JSON string stored in the Hive table properties (Alteryx currently supports)
2. Reference to the schema file stored elsewhere
3. Pass in the schema as a run-time property in Hive

Alteryx only supports Option #1, but that runs into a 4000 Character Limitation which is the default schema limit in Hive’s internal DB. Is it possible to have Alteryx support the other two options to be able to support data sets with large schema definitions?

As more vendors start selling directly to Amazon, the need to use Amazon Retail Analytics specific to your products is increasing. Currently, the only way to do this is manually downloading data from the Amazon Vendor Central platform every week to make sure data is saved and then further prepared in excel or Alteryx. The Download Tool does not work in this situation because of the various login credentials and page navigation that is associated with the platform. It would be great if there was a Connector Tool that integrated the Amazon Retail Analytics data from Vendor Central directly into Alteryx.

On the Reporting palette, the Map Legend Builder tool has an extra "the" in the tooltip. I have enclosed an image below. Full disclosure: it isn't a bug, it doesn't affect functionality, and it's trivial. This is version 2018.3.4.51585.

HI,

Would love the option to pass a field to the AWS S3 Connector for the Key & Secret Access key. We are building an extensive datamart using AWS S3 and instead of manually changing keys each quarter (per our security) manually in each workflow & tool, we'd rather change it in one spot and have it filter into all affected workflows. 

Thanks.

The Text Box tool has a tickbox allowing a multi line "answer" to be supplied for the question.

But it does not allow you to easily setup the question as multi line i.e. with carriage returns

Please allow the ability to enter multi line text for the Question of the Text Box Tool.

At the moment, I force carriage returns to happen, by entering a bunch of space characters in the "Enter the text or question to be displayed" box of of the "Text Box" tool. This is obviously not ideal.

Example of desired layout for App question:

example showing how entering a bunch of spaces can be used to force a carriage return:

Currently, Alteryx can connect to FileMaker via an ODBC connection, and for the most part, it works great. The only issue I've hit thus far is when importing data with foreign text in it - Arabic and Cyrillic text specifically – sometimes the data comes in correctly, and sometimes it’s turned into garbage characters. I’m not sure how widely used FileMaker is, but the full support for it would be greatly appreciated. Thanks!

~Chrispy

If a user selects 10 Input tools, the ability to then right click and be able to "Insert After" to a Union tool and have all the Inputs attach to the Union would be great!