Alteryx Designer Desktop Ideas

Our company is still using 9.5 so if this is addressed in 10....I appologize.

Currently the Join Tool Options drop down has [Select-->Select All] and [Select-->Deselect All]. I think an additional [Select-->Select All Left] and [Select-->Select All Right] would be handy.

Thank You

When using Interactive Chart tool; or Insight tool - every time you click on it you are asked to configure, even if you've already configured this previously.

Please could you change this so that it displays the "Configure this tool" screen ONLY if there is no configuration in place.

This tool is already configured, but still you get the "configure this tool" dialogYou can see here that there is configuration already (looking at the XML)You can also see that this tool is already configured if you look at the config itself

Would be amazing if we can use a wildcard to input data from multiple sheets within an Excel workbook. 

This would be particularly useful when dealing with older Excel spreadsheets such as .XLS and .binary spreadsheets such as .XLSB.

I think it would be great, especially if you have browse tools at multiple phases in workflow, to be able to view Browse results while module is running, rather than having to wait until it's done. I think it would help with being able to head off problems sooner.

So - with Challenge 111 - many folk used the Optimization tool

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-111-Make-a-Weekly-Challenge-Dream-Team/m...

… and Joe has done a great training on this here

https://community.alteryx.com/t5/Live-Training/Live-Training-Prescriptive-Optimization/m-p/44779

But it's still to hard to use.   It requires you to have pre-knowledge of a bunch of parameters and different types of knowledge.

Can we improve the interface on this tool so that it can be used by folk who do not have a background in R - for example, take all the different inputs, and make them parameterized on drop-down boxes or input boxes on the tool?

Thank you all

S

CC: @JoeM

My team has requested that the user interface for one of our macros is color coded to indicate the priority of certain inputs. This would be a huge help in making our large interface easier for a user to fill out and utilize.

Would like to see the Directory tool output results for folders that are empty.

My particular use case is requiring me to join a dataset with a file system directory and identify each dataset record's corresponding folder in a file directory. Each folder in that directory has subfolders that require a document to be located inside, and I'd like to be able to use the Directory tool to identify which subfolders are empty for which records.

The current filter tool allows for a single clause to be applied without writing the code. 

Is it possible to have the ability to make a selection, for example "Y>X" then click AND or OR and then have the ability to simply add another filter clause without having to select "Custom" and lose the wizard functionality? 

I think I raised this before but I couldn't find it.

This seems like it would be a simple implementation.

M.

ps - Shoutout to @DataG8 for bringing this to my attention again.

Currently, the "SQL editor" window only contain a box for typing text in, we could not see the schema and table on it's side as a reference, we need to jump back and force between "Visual Query Builder" and "SQL Editor" search for table and column names. If we could see the database schema and table in the SQL Editor interface, it will save us a lot of time.

For those of us obsession with the look and feel of our workflows, it would be great to have the option to modify the paths of tool connections, as shown in the image below. 

use case : much of our users copy paste a formatted query to the Alteryx tools such as Connect in Db or Input Data (especially to reduce the data).

However, some of the formatting such a Carrier Return does not work

select 
 * from 
`re7_kerberos_za_e_*******_ee01pub_edd`.`v_*******_flux_20170511` 

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.

Hi, I've noted that there is not url-decode function in Alteryx. I guess I'm the first one to need that, so I'm posting this idea here. I think it would not be a big deal to do so if there's a url-encode function. 

Thanks. 

Hi all.

We're heavily using SalesForce and one of the reasons we've purchased so many licenses was support of SFDC.

However, our implementation is set up based on a Custom Domain.

Unfortunately at this point our connector does not support Custom Domains. 

Please, kindly review and possibly add SFDC authorization option that supports Custom Domain. Like Excel, Tableau and others does

The reporting tools do not currently support HTML structured or unstructured lists https://www.w3schools.com/tags/tag_ul.asp

All vertical combination creates tables which group the lines together.    Even if you manually create this - you get an error saying that ul (or ol or il) are not supported in composer

This creates a challenge in 2 ways:

a) When creating lists in reporting outputs - you lose the functionality of structured lists (numbering with letters; numbers etc)

b) additionally - selecting the text in tables behaves differently than selecting data that is created in lists.

Please could you add the ability to create lists in addition to tables in the reporting tools by supporting the ol; ul; and il tags?

NOTE: this could initially be done just by supporting the tags; and then later this could be a summarize option on the summarize tool; and a bullet option in the text tool.

Summarize using tablesdesired: summarise using listsList rendered with the list tags

The are a lot of SQL engines on top of Hadoop like:

• Apache Drill / https://drill.apache.org/
  Schema-free, low latency SQL Query Engine for Hadoop, NoSQL and Cloud Storage
  It's backed up at enterprise level by MapR
• Apache Kylin / http://kylin.apache.org/
  Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc.
• Apache Flink / https://flink.apache.org/
  Apache Flink is an open source platform for distributed stream and batch data processing. Flink’s core is a streaming dataflow engine that provides data distribution, communication, and fault tolerance for distributed computations over data streams. The creators of Flink provide professional services trought their company Data Artisans.
• Facebook Presto / https://prestodb.io/
  Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
  It's backed up at enterprise level by Teradata - http://www.teradata.com/PRESTO/

My suggestion for Alteryx product managers is to build a tactical approach for these engines in 2016.

Regards,

Cristian.

Is there a reason why Alteryx does not include hierarchical clustering?

Well it's sort of slow especially with huge data sets, computation effort increases cubic, but then when you need to do two step clustering,

"creating more than enough k-means clusters and joining cluster centers with hierarchical clustering" it seems to be a must...

P.s. Knime, SPSS modeler, SAS, Rapidminer has it already...

It would be great if there was a way for the Text to Columns tool did not drop the last empty when using Split to Rows.

For example, if I had the data:

Notice that each value has two commas (representing three values per cell), and If I configure to split into rows on the comma character, what would you expect the result to be:

Result A:

OR

Result B:

OR

Result C:

I would expect Result C if I selected "Skip Empty Fileds", and that is what happens if I select that option.

But If I do not want to skip empty fields, I would expect Result B, but what I get is Result A where the last value/field is dropped/skipped.

What would it take to Result B as the output from the Text to Columns tool?