Alteryx Designer Desktop Ideas

@MarcH I'm putting your name on this one:

Yesterday I was working with @Cedric via WebEx and we were building a macro together.  We were making several field substitutions and and Cedric stated the obvious, "Alteryx should make this easier".

Contains([Field_X],"XYZ")

He would double click [Field_X] and the result is a partial selection:  [Field_X].   The brackets don't get selected.

I'm sure that there is a good explanation for why this happens, it just doesn't make the UX wonderful.

Cheers,

Mark

It would be nice if when Alteryx crashes there is an autosave capability that when you re-open Alteryx it shows you the list of workflows that were autosaved and give you the immediate option to select which ones you want to save. SImilar to what Excel does.

I know about the current autosave feature, but I would still like to have it pop up or the option to have it pop up for me to select which to keep and which to discard.

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.

🙂

Description: I have configured a number of customized MapServer files rather than having to manually configure each layer in the ReportMap tool.

For reference, these are stored in the <Alteryx Data Install Folder>\AlteryxMap\TomTom_US_2015_Q3, for the TomTom US - Current Vintage reference base map. Below is a picture of the many versions of the .map configuration file I have created.

Rationale: Using these different files is cumbersome and inefficient. To switch out a map file, I have to rename the current .map file to a dummy name. Then I have to rename the desired file to be the name that the existing file was. Additionally, I can only have one .map file in use at any one time and all of the workflows running use the same one.

Idea: Allow user to choose which .map file to use from within the Report Map tool.

In the great workaround In-Database Sorting, the author explain how to distribute the sorting in ot the database.

Unfortunately, the Percent option is not available for a Hive Connection (I'm using Simba Hive ODBC driver v2.1 connection).

This is a behavior that my user would like to use in order to reduce the duration of the workflow (so they do not need to stream datas in and out).

We are using Alteryx 10.6 x64.

What do you think about my need ?

I was asked by a client @brianvigus to help him put the current date onto a daily Excel output file.  When they tried to prepend/append the date, it only would do so to the worksheet name and not to the workbook name.  I do like the ability to update the table (worksheet) name and understand their desire to update the workbook name too.

My solution was to create a COMPLETE PATH\FILENAME|SHEETNAME data element and use the existing option to change the entire file path.  That works.

I don't know if the solution to this idea is to update the help instructions to explain that table renames act differently than file renames or if the solution requires more functional options on append/prepend.

Thanks,

Mark

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

To navigate through XML document you need several parse tools to drill down to an element because you can only use element names

It would be nice if you case use an xml path (xpath) because of the rich syntax.

With xpath, we could specify ship_to/address/city or bill_to/address/city

This idea is concerned with suggesting values based on text box entry in an analytic app. This would be an autocomplete within the text box interface based on matches to a list of connected values. For example, if someone was posting "805 Wells Road" it would expand the text box window and supply potential matches to click on.

Quick and dirty photoshop image below:

You know how when you pull a new tool onto a canvas where you already have a workflow it wants to auto connect to the closest tool where it lands? While this can be useful it causes major issues when it moves the entire workflow you had in place. What makes this more frustrating is when it does this and you can't undo everything it did. Sometimes I spenda lot of of time fixing what it messed up. On top of which the tool it connected too was wrong!

Like I said it can be useful, but the adjustment of the entire workflow is HIGHLY unneccesary.

Could you PLEASE adjust this feature to auto connect without moving the entire module?!

Thank you 🙂

Hi,

Two things:

Can there either be more space between the Active Documents button (where all open modules are listed out) and the Close Document button (I'm not a fan of this, I use the close button next to module name) or make the Active Documents button a lot bigger (same size as Close Document button)? I've closed a few modules accidently trying to get to module list.

Also, there was a switch and now the Active Documents shows in alphabetical order, instead of the order they fall in on the canvas, which makes it hard to find modules that have your generic New Workflow#. Can you either switch Active Documents back to show display order or switch the canvas display order to rearrange itself into alphabetical order, that way the order they fall in on the canvas is the same order they show in in Active Documents (making it easier for people like me that remember order over name)? 

If you can't do any of these, could you at least add a Left & Right button so a user can just click thru open modules regardless of the module name (like you have on the toolbox)? 

Thanks!

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

This is the screen when trying to access HDFS through Alteryx:

When publishing a workflow that contains the user ID and using Kerberos, one would need to login to the Alteryx server and run the MIT Kerberos Ticket Manager.

It would be a great enhacement to add the possibility to allow the users to use the keytab file to authenticate alongside the existing authentication.

So, if one checks "Use Kerberos", there would be an option text box that would allow the user to select the keytab file. That would ensure that the ticket is always valid and there is no need to login to the server to renew the kerberos ticket every day manually (!).

[-t keytab_file]

Ref: https://kb.iu.edu/d/aumh

http://web.mit.edu/Kerberos/krb5-devel/doc/user/user_commands/kinit.html

Does anyone have any workarounds?

When connecting to a database (Oracle or other) with an Input tool, Alteryx gives you the ability to select a table from a list of available tables in the database. The Output tool has you type the table name in. What if you want to write to an existing table but type the name wrong by mistake? You could unintentionally write to a table that doesn't exist or write to the wrong table . I think it would be valuable for the Output and Write Data In-DB tools to have the option to pick from a list of available tables in the database just like the Input tool.

Extension: It would be great if Alteryx could compare the meta data of the data stream coming into the Output tool and the meta data of the database table itself to see if the data that will be written to the database table misaligns with the configuration of the database table. In other words to prevent the following from occurring: I was replacing the .yxdb output of a large process to output to an existing Oracle table instead. Alteryx successfully deleted the entire contents of the Oracle table, but when it began to write records, it errored because the field lengths of the Oracle table were not long enough. This wouldn't be a big deal except that the workflow takes 20 minutes to run and the database tables were wiped before the error was fully realized! I've heard that other ETL tools warn you against data that may violate the configuration of the database table that you're trying to write to.

Thank you for listening!

The Formula tool has lower case, upper case, and title case. But I often need to change multi-word notes text to sentence case, where only the first letter is capitalized. Instead of having to write a special formula, it'd be nice to have a sentence case function.

this is lower case

THIS IS UPPER CASE

This Is Title Case

This is sentence case

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.

A problem I'm currently trying to solve and feel like I'm spending way too much time on it..

I have a data set which has some data in it from multiple languages, and I only want English values.  I was able to get rid of the words with non English letters with a little regular expression and filtering.  However, there's some words that do contain all English letters but aren't English.  What I'm trying to do is bring in an English dictionary to compare words and see which rows have non English words according to the dictionary.  However, this is proving to be a bit harder than I thought.  I think I can do it, but it feels like this should be much simpler than it is.

It would be great to have a tool that would run a "spell check" on fields (almost all dictionaries for all languages are available free online).  This could also be useful also just for cleaning up open text types of data where people type stuff in quickly and don't re-read it! 🙂