Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

0 Likes

I´ve looked in the forums, and the idea is new. It would be great if there would be an option to make it possible to give tooltips when writing a formular yourself not only in the "basis-language of the installation", but also in e.g. english (as Lingua Franca). The reasoning: in Excel or Tableau I know many a command in only one language - and have to undergo a timeconsuming process of A) thinking AND B) looking it up in the language you have to use at that project.

 

 

Even Tableau does not offer this - and you have to create a lot of  calculated fields. Alteryx could gain in UI-friendliness...

0 Likes

I´ve looked in the forums, and the idea is new, although it has similarities to others. Since Alteryx already supports Crtl+c and Crtl+v - why not support "F4" as well. In ALL MS-Office programs it repeats the last step and thus eases the burden on mouse and user...

 

I realize that repeating a whole process might (!) not be feasible - but single steps (e.g. "Formatting to the similar size like the last item....") would already be very helpful.

 

Since Tableau does not offer this - and it has a lot more to format and repeat - Alteryx could gain in UI-friendliness...

 

0 Likes

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.

0 Likes

Hi,

 

I recently started to take online trainings on Alteryx and came across Tile Tool. Though could understand the purpose to some extent, it would be great if the tool is explained in more depth along with more examples and also how the tile number is calculated for the examples.

 

Thanks,

Saipriya.

0 Likes

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.

0 Likes

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

0 Likes

Hi All,

 

I believe the following would help improve the functionality of Select Tool.

 

The idea is to have a defaulting option for each of the field in the Select Tool (which I believe should be a light weight Tool i.e. not adversely impacting performance and gives best exhaustive picture of all columns flowing through a (/particular point in ) pipeline).

 

Following are some of the cases where defaulting might come handy -

 

1) Fields which are supposed to hold monetary data - instead of Null, one can put 0.00 to help roll up summary properly.
2) Fields which are supposed to hold dates (say expiry date) - instead of Null, one can put some enterprise standards like 31-12-2099 to avoid mixing Nulls and 31-12-2099.
3) Fields which are supposed to hold purchase quantity/number of employees/number of merchandise - instead of Null, one can put 0 (and not 0.00) again to help with roll up summary.
4) Fields which are supposed to hold Currency - instead of Null, one can put USD.
5) Fields which are supposed to hold dates (say this time create date) - instead of Null, one can hardcode actual date, or an additional feature to put Now() kind of functions.

 

At present one of the options of achieving same might be to put a Formula Tool and to code whatever is desired inside the Formula Tool.

 

Benefits of having the functionality inside Select Tool would be -

 

1) It would be more user friendly and call for faster build to just write '0.00' or 'USD' or '31-12-2099' as compared to writing IF IsNull()... statements.
2) Inside Formula Tool, user needs to pull desired fields from the drop down and hence exhaustive view of all fields passing through pipeline is not available.


Pain in selection of fields from drop down and writing actual formulas might be aggravated with the number of columns increasing and might be more prone to human omission related errors.

 

Thanks,
Rohit Bajaj

0 Likes

If you copy a text box named ClientCode to another workflow, the name of the box will be reset to text box(#) in that new workflow. That can be a snag if the workflow the text box is contained in is deployed to gallery as an app that is ran via the gallery API... the API parameters will be looking for a text box named ClientCode but is now named text box(#). This happens almost in the background without the developer knowing they have renamed the text box and the ES eventually failing. This can be annoying; it would be great if the name were inhereted. 

0 Likes

If you copy a text box named ClientCode to another workflow, the name of the box will be reset to text box(#) in that new workflow. That can be a snag if the workflow the text box is contained in is deployed to gallery as an app that is ran via the gallery API... the API parameters will be looking for a text box named ClientCode but is now named text box(#). This happens almost in the background without the developer knowing they have renamed the text box and the ES eventually failing. This can be annoying; it would be great if the name were inhereted. 

0 Likes

During development it seems the syntax checker or whatever process runs behind the scenes after a tool is modified reviews the full workflow. 

Ex - Just from observation if I modify the file name in an output tool I don't see why it would rerun the full syntax check process.

 

This reduce the time waiting to continue development.

0 Likes

When using horizontal layout the status messages can overlap those of other tools meaning % progress can't be read:

 

Overlap Alteryx.png

Status labels would be better placed above the tools, not to the right.

0 Likes

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 IdeaNested Browse View Idea

0 Likes

Sometimes when I'm working on a workflow a connection string between two tools will take a path that either causes the workflow to become more cluttered or overlaps another tool etc. I usually format these strings to be wireless but if I am presenting my workflow to someone who is unfamiliar with Alteryx, wireless connections can cause much confusion. It would be great if I could determine the path a connection string takes, much the same way you can draw/manipulate a line in ppt or word (i.e. if the string could have nodes that could be dragged around tools, containers, etc.)

 

Thanks!

0 Likes

When you use a Find Replace tool, it would be GREAT if you had a select all option for what you want to append to the find data set.

 

It would be extra GREAT if you added the ability to draw a box over the ones you want to add, or have a feature where you could select the first on on the list and hold the shift+ctr to select multiple lines at once.

 

🙂

0 Likes

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.

0 Likes

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

 

 

 

0 Likes

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...

 

Rank  DBMSDatabase ModelAlteryx
AugJulAug   
201620162015   
1.11OracleRelational DBMSYes
2.22MySQL Relational DBMSYes
3.33Microsoft SQL ServerRelational DBMSYes
4.44MongoDB Document storeYes
5.55PostgreSQLRelational DBMSYes
6.66DB2Relational DBMSYes
7.78Cassandra Wide column storeYes
8.87Microsoft AccessRelational DBMSYes
9.99SQLiteRelational DBMSYes
10.1010Redis Key-value storeNo
11.1114Elasticsearch Search engineNo
12.1213TeradataRelational DBMSYes
13.1311SAP Adaptive ServerRelational DBMSYes
14.1412SolrSearch engineNo
15.1515HBaseWide column storeNo
16.1617FileMakerRelational DBMSNo
17.1818SplunkSearch engineNo
18.1716HiveRelational DBMSYes
19.1919SAP HANA Relational DBMSYes
20.2025MariaDBRelational DBMSNo
21.2122Neo4j Graph DBMSNo
22.2220InformixRelational DBMSNo
23.2321MemcachedKey-value storeNo
24.2424Couchbase Document storeNo
25.2528Amazon DynamoDB Document storeNo
26.2623CouchDBDocument storeNo
27.2730VerticaRelational DBMSYes
28.2829Microsoft Azure SQL DatabaseRelational DBMSYes
29.2927NetezzaRelational DBMSYes
30.3026FirebirdRelational DBMSNo
31.3131Riak KV Key-value storeNo
32.3340Amazon Redshift Relational DBMSYes
33.3232MarkLogicMulti-model No
34.3434dBASERelational DBMSYes
35.3535GreenplumRelational DBMSYes
36.3633IngresRelational DBMSNo
37.3739ImpalaRelational DBMSYes
38.3836SphinxSearch engineNo
39.3943HazelcastKey-value storeNo
40.4038EhcacheKey-value storeNo
41.4151Google BigQuery Relational DBMSYes
42.4350OrientDBMulti-model No
43.4241InterbaseRelational DBMSNo
44.4545Spark SQLRelational DBMSNo
45.4455TitanGraph DBMSNo
46.4668RethinkDBDocument storeNo
47.5081InfluxDBTime Series DBMSNo
48.4769AerospikeKey-value storeNo
49.4947CloudantDocument storeNo
0 Likes

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.

 Alteryx_4.jpg

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

   Alteryx_1.jpgAlteryx_2.jpg

 

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

Alteryx_3.jpg

 

 

Thank you for considering our request.

0 Likes

I will be using TS Model Factory tool for running ARIMA quite extensivelty and understand that existing tool does not allow for model customization options. I will really appreciate if we can have customization options which helps to specify order of AR or MA components like it can be done in ARIMA tool.

 

Thanks!

0 Likes

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

 

Capture1.JPG 

 

which is interpreted as text

 

  Capture3.JPG

 

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

 

Capture2.JPG

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/

 

Top Liked Authors