Alteryx Designer Desktop Ideas

We're currently using Regex and text to columns to parse raw HTML as text into the appropriate format when web scraping, when a tool to at least parse tables would be hugely beneficial.

This functionality exists within Qlik so it would be nice to have this replicated in Alteryx.

Obviously, we need to retain the ability to scrape raw HTML, but automatically parsing data using the <td>, <th> and <tr> tags would be nice.

In the following page there is a table showing the states and territories of the US:

With Qlik, you can input the URL and it will return the available tables in tabular format:

As this functionality exists elsewhere it would be nice to incorporate this into Alteryx.

Hi there,

My idea comes when I've built an application, where user select filter from drop-down list. However it contains thousands of records, so it takes lot's of time to find desired record.

In Excel and MS Access when you use filter you can put many letter and filter shows rows that match the input. In Alteryx user can only put first letter, which is huge drawback to my users.

This is how it works in Excel:

Hope you like it!

Currently, when one uses the Google BigQuery Output tool, the only options are to create a table, or append data to an existing table.  It would be more useful if there was a process to replace all data in the table rather than appending. Having the option to overwrite an existing table in Google BigQuery would be optimal.

I like the new cache option in 2018.3, but I would like it to function a little bit different. Let's say you cache at a certain point and then continue to build after that. If I reach another checkpoint and want to cache, it currently re-runs the entire workflow (ie it ignores my cache upstream and just goes back to the beginning of the workflow); instead, I would rather have it utilize the upstream cache. Personally, caching is usually an iterative effort during development where I keep caching along the way. The current functionality of the cache is not conducive to this. Thanks!

Currently the InDB tools require to select a DSN that is defined on your computer.

This makes any workflow which uses a DSN incredibly painful to deploy to the server, since the DSN needs to be created on every worker node and for a large server environment this can  mean creating DSN entries on 6+ worker nodes in prod plus prod server plus dev/UAT environment plus dev/UAT worker nodes.

Could we please change the InDB tools to default to DSN-less connections, where the connection persists the connection details in-line so that it can deploy to the server without a DSN setup (since all connection details are contained within the connection string)?

Thank you

Sean

CC: @rijuthav @jithinmony @HengHe @RajK @ydmuley @revathi @Deeksha @MPistone @Ari_Fuller @Arianna_Fuller @JoshKushner @samnelson @avinashbonu @Sunder_Sriram @Rahul_Thakur @Rahul_Singh

To get simple information from a workflow, such as the name, run start date/time and run end date/time is far more complex than it should be. Ideally the log, in separate line items distinctly labelled, would have the workflow path & name, the start date/time, and end date/time and potentially the run time to save having to do a calculation. Also having an overall module status would be of use, i.e. if there was an Error in the run the overall status is Error, if there was a warning the overall status is Warning otherwise Success.

Parsing out the workflow name and start date/time is challenge enough, but then trying to parse out the run time, convert that to a time and add it to the start date/time to get the end date/time makes retrieving basic monitoring information far more complex than it should be.

Hi there,

Just got a new 4k UHD monitor, and found that Alteryx Designer doesn't scale well in default settings in Windows.    Fonts are blurry but icons are the right size.

If instead you change compatabilty mode to allow the application to force scaling, then the fonts and icons end up all different sizes.

Could you change the fonts and icons to scale gracefully in Windows 10 to full 4k UHD HDR - especially on the large size monitors (30 inch plus)?

Shot 1: default mode - blurry text - badly scaled by Windows 10.    It's not easy to see here because the image is small - but all the text is blurry like a badly blown up BMP file.

Shot 2: Override Windows 10 DPI scaling and set to "Application" mode

You can see in the picture below that text is now super-sharp but the the play button; save button are all tiny; the fonts are different sizes (look in the properties tab on the left) etc.

Hello all,

As specified in the title, this idea is to distinguish between Append Prefix/Suffix to File and to Table on the Output Data Tool.


For most files (csv...), the table name does not really exist. However, for at least Excel files, if you choose this option, the result will be one sheet by suffix and the only option to have one file by suffix will be to change entire file path.

Best regards,

Simon

Very often, I used a container to make notes about certain parts of the workflow. Some of the comments that I created are pretty long. Could the user have the possibility to have at least rows for the title of the container?

I have created a screen to show what I have in mind. Potentially users could have the ability to turn this option on or inside the container?

Thank you to @LeahK for suggesting that this should be a separate idea (cc @JulieH; @TaraM, @LeahK, @JoeM😞

The lack of home use / learning editions of Alteryx is a serious mid-term competitive threat factor for Alteryx - and it's well worth both this Alteryx community; and the Alteryx Community Management team making this a key priority for the Alteryx platform.

Rationale:

The BI/Data science space is very competitive (as evidenced by the recent Gartner 2016 Magic Quadrants), and although Alteryx was given very favourable review in some factors - there were serious concerns about licensing costs; and time to productivity.

Clearly - Alterxy succeeds in direct proportion to the size of the active user base - so the question is "How do we increase the licensed / deployed user base" and I believe that there are 3 factors which all relate to the issue of learning-edition alteryx licenses.

a) Time to productivity:   Right now - I cannot ask one of my staff to learn Alteryx at home and prove their capability before paying several thousand dollars to give them a license.   Once I give them a license; it then takes them 2-3 months to become productive, and we run the lottery of finding out whether this person was a good fit for this kind of role in the first place.   Solution:  Make Alteryx available in a learning edition at home with a robust certification program; and a learning progression built in - that way I can tell my staff "I will give you a license once you demonstrate your competence by learning to this level".   How does this help Alteryx: lower time to productivity = more attractive product

b) Size of committed user base:  As tech professionals - we take our tech bias with us to our new role (the "Affinity effect"), and often will have some leverage in tool selection.   The more people know Alteryx and are invested in their Alterxy skill set - the greater this "Affinity effect" will start to show in sales figures.   This also makes the tool more sticky, reducing the defector population if users can see and use latest features at home.

Solution: Give the learning edition away for free - Pentaho spoon is currently free for learning; as is Tableau Public; and MS Power BI is incredibly cheap to learn.   If Alteryx doesn't do this - others definitely will anyway, and this "Affinity Effect" will be washed out.

c) Increase the skill pool in the market:  The more wide-spread the skills are - the more likely I am to purchase a toolset.  So - if Alteryx skills are very broadly available in the market - it's easier to make the purchase decision for Alteryx rather than competitors.   However - right now the skillset growth is severely constrained, so Alteryx is making the "Buy Alteryx" decision needlessly harder.   

Solution: Make Alteryx available for training; learning; & Certification for free.   

Note: Although this is directly contrary to my personal interests in the short term (the smaller the number of people with skillX, the higher the market value), it is also long-term selfish because I will be able to increase the impact within my firm by having access to a greater pool of skilled and instantly productive workers in the market.

Although price may be an issue - this is a separate matter.   I believe that Alteryx can do a lot to create future sales pipeline, and a committed and very sticky user base by providing this home-learning & certification program.   In my mind - this is probably one of the biggest competitive opportunities & threats facing Alteryx right now, given the velocity of this particular industry & segment.

I'd be very happy to talk this through in detail with the Alteryx team if that's helpful (just PM me)

Many thanks

Sean

At present, Alteryx allows for users to run 2 versions of Alteryx at once - one installed using the "Admin Installer" and one via the "non-admin installer"

However, in corporate environments, only the Admin Installer can be used (all installers are repackaged for corporate environment / endpoint management)

This leads to a situation were we cannot run two or more different versions of Alteryx on one machine (like you can with Visual Studio or other platforms).   This also prevents us from participating in the BETA program because the BETA version would overwrite the users's current version.    Finally - this also makes version upgrades more risky since we cannot run the new version in parallel for a period to evaluate and identify any issues.

Request: Please can you change the installer for Alteryx to default to parallel install per version - so that a user can run 2019.1; 2019.2; and 2019.2 BETA on one machine in a way that is fully isolated (i.e. no shared components - have to be able to uninstall one instance cleanly and leave the others in a fully functional state).

Many thanks

Sean

There is no tool that exists that outputs all records that are duplicates (those sharing the selected values with at least one other record) and also outputs the records that are not duplicates (those not sharing the selected values with at least one other record).

The Unique Tool is not sufficient.  It only provides the first record of a unique duplicate group along with any non-duplicates and then provides a secondary output that only contains the additional records of a duplicate group.  Sometimes you only care about the duplicates and want to quickly see what differs between the unique groups.

For example, if there are 4 records with the City of Austin and I am looking for duplicates on City I want to see all 4 records with Austin in the output so I can quickly compare additional fields to see what might differ, or if they are all indeed truly duplicates.

I would like a way to disable all containers within a workflow with a single click.  It could be simply disable / enable all or a series of check boxes, one for each container, where you can choose to disable / enable all or a chosen selection. 

In large workflows, with many containers, if you want to run a single container while testing it can take a while to scroll up and down the workflow disabling each container in turn.  

Hello all,

We all love pretty much the in-memory multi-row formula tool. Easy to use, etc. However, the indb counterpart does not exist.

I see that as a wizard that would generate windowing functions like LEAD or LAG
https://mode.com/sql-tutorial/sql-window-functions/

Best regards,

Simon

For the Output tool, File Format of Microsoft Excel (*.xlsx) - the non-Legacy one - it doesn't have the "Delete Data & Append" option that the Legacy ad 97-2003 Excel formats have. 

Having the Delete Data & Append for the most recent version of Excel would be very beneficial. Without it, there does not appear to be a way to udpate an existing Excel sheet using an Alteryx workflow while preserving the formatting within the Excel sheet. The option to Overwrite/Drop removes all formatting. 

I have this workflow refreshing an Excel sheet daily, and then am emailing it to a distribution at the end of the workflow. Unfortunately, right now I have to use the 97-2003 format to preserve the formatting of the Excel sheet when it is automatically refreshed and emailed each day. 

Can you please assess adding this option? Thanks!

There is an extensive need from customers to be able to create emails but not send them (right away at least). This would be an enhancement to the email tool to allow for checking a box to say "Save in Draft" and if that box was checked the send email functionality would not be called but the email would be created. 

Hello,

As I mentioned in this previous idea : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-In-database-connection-please-stop-i...

field mapping in generic in-db connection is based on Microsoft Sql Server. Given the specificity of MSQL Server field types, I would like to change that in order to at least be able to use another database. Without that, this feature has no sense at all.

Best regards,

Simon

Please add xlsx files within the onedrive input/output tool

I would love to see a "Product" option added to the summarize tool. I can currently count, sum, mean etc., but I can't multiply my data while grouping. There are numerous "work arounds", but a native product function built into the summarize tool would be great.

Thanks for listening!