Alteryx Designer Desktop Ideas

It would be great to see the R tool updated with the same interface as the Python tool to reduce the need to rerun the workflow when testing.

Add the option to flip comment boxes, so they can be read down-up, instead of left-right... (see below in red, how it looks and how it could be). 

 

                                 

We need an option to schedule a continuous bi-weekly payroll workflow. It is every two weeks starting on a certain day of a week. Some months have 3 and other have 2. If we had an option to select the starting day in a particular month and then select bi-weekly bullet (or every 2 weeks) from that date it would be perfect. thanks

I would love to see a detailed change log to help when I encounter issues after upgrading from one version to the next. For concrete examples, I've come across these issues recently:

1) Files saved to %TEMP% were displayed to the end user in the 10.0 but not 10.1 when running in the gallery. 

2) The cross tab in 10.1 would run with a warning if you had column heading of "p_d" and "p d" where the space in the latter item is changed to a _ and then one of them is renamed with a 2 at the end ("p_d" and "p_d2").  In 10.5 you now get a warning and an error and the workflow stops. I've attached a sample workflow.

 

I'm all for bugs getting fixed and the improvements not always being backwards compatible, but I struggle with some of these when I can't reference a detailed change log. For some context, I've also attached a change log from some other software I used in a previous life. Anytime that a change in coding could affect past results, there was a note in the change log to identify these changes to the end user.

As we have the option to name the connector line in the Connection-Configuration, the option to color code those lines would be of great help. 

Hello,

I think it would be extremely useful to have a switch connector available in Alteryx. What I mean by a switch connector is a connecting line with an on/off state that will block the data stream through it when off. Something like below:


Switch Connector in an "Off" state

This would be extremely useful when you only want data to flow down some of the paths. In the example above, I might turn the switch connector to off because I want to see the Summarize results without outputting to a document.

The current methods for having a path/set of tools present but unused are insufficient for my needs. The two methods I and Alteryx support were able to find were:

I know there's the download but have a look at that topic, the easiest solution so far is to use an external API with import.io.

 

I'm coming from the excel world where you input a url in Powerquery, it scans the page, identify the tables in it, ask you which one you want to retrieve and get it for you. This takes a copy and paste and 2 clics.

Wouldn't it be gfreat to have something similar in Altery?

 

Now if it also supported authentication you'd be my heroes 😉

 

http://community.alteryx.com/t5/Data-Sources/Extract-a-table-from-Wikipedia/m-p/14531/highlight/fals...

 

Thanks

 

Tibo

 Add native support of Python, C#, and Java

I have two use cases here:

1) A single tool that I want to connect to several tools (e.g. an input connecting to a number of selects)

2) Several tools that I want to connect to a single tool (e.g. several inputs connecting to a single union tool)

The current interface requires that I establish these connections by connecting the tools individually. It would be great to have the ability to have a right-click option. Simplistically, it might work something like this...

1) Select the tools that you want connected to a single tool (e.g. all the selects); Right-click; Get connection from Tool...{drop down list}

2) Select the tools that you want to get their connection from a single tool (e.g. all the inputs); Right-click; Connect to Tool...{drop down list}

Everyone knows the importance of adding the appropriate controls and governance to your workflows - and often, this means including events that will generate notifications if a workflow is running with errors.

 

But who is the audience of that email? If it's not a developer, will that person know what they are reading and where to focus?

 

How about a developer that would like to customize the message that the end user will receive?

 

Porting some existing functionality from other tools in the Alteryx toolkit to the Events page could easily provide added flexibility to event generation:

 

1) Add a formatting bar to the tool like shown in the image below

-- Style changes

-- Alignment

-- Highlighting

-- Coloring

-- Images

 

2) Add a function bar to the tool like shown in the image below

-- Ability to view all available variables

-- Ability to apply formulas using variables

-- Ability to save formulas

 

 

What do you think? Give this post a thumbs up if you find the post helpful!

Hi everyone,

 

Add two additional features to a directory tool. Something like this:

Use cases:

1. Since it is not possible to use a folder browse on the Gallery, this could help a basic user create a list of possible folders to select from with the help of a drop-down

2. Directory analysis for cleaning purposes - currently, if you want to get a list of the folders with Alteryx, it takes forever for big file servers since Alteryx is mapping all the files

 

Both are achievable today through regex or a bat script.

 

Thank you,

Fernando Vizcaino

Hello all,

According to wikipedia :
https://en.wikipedia.org/wiki/Embedded_database

 

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application.

 

 

It's often like a single file/dll that you can use inside an application without the user having to connect (or at least to configure it) to it (it's all done inside the application). So, it's widely portable.


Why it does matter ?

As of today, there is not a single example of in database workflow because all the supported databases need the user to:

1/install an odbc driver (most of time, he won't have the rights to do so)

2/configure an odbc connection (sometimes, he doesn't have the rights to)

3/configure a connection on Alteryx (ok, he can)
So it requires IT action, which can be pretty long (in ùany organization, it requires several weeks !!). And even with all of that,the users must be granted privilege to access database and the customer need to develop its own examples and write its own specific documentation.

Well, this is not efficient.

What I suggest is Alteryx to use one of embedded database for training support/one tool examples. SQLlite seems good, maybe a more analytics oriented (like DuckDB ) would be more efficient.
The requirement are, I think, the following :
-OpenSource and free
-Fast
-SQL compliant
-With a bulk load ability

Best regards,

Simon

Can the inputs to app interface tools update other interface tools within the same app?  Right now, I believe the only way to do this is with chained-apps, but I don't wish to go that route again.

 

Just one example:

 

Can a Dropdown interface tool update a listbox interface tool with an action?  

Right now, I have two interface tools in an app:

1. Dropdown
2. Listbox.  

 

For the Listbox tool , it references an external source file for the NAME:VALUE pairs, let's call this file:  Category1.yxdb.

 

I would like for the resulting dropdown selection to update this external source file to say, Category1.yxdb or Category2.yxdb or Category3.yxdb, etc.

The different .yxdb files here have different name:value pairs within them.

 

It doesn't seem like this possible at the moment, but please let me know if this is something that's currently supported within Alteryx.

 

Thanks,

Collin

SOOOOoooooo many times it'd be great to just dictate the character length/count (fixed width) for the parse (just like you can in excel), instead of being constrained by a delimiter or being obligated to go create (potentially complex) REGEX.  Ideally you could go into the column and insert the <break> (multiple times if needed) after the given character where you'd like the parse to occur.  Anything past the last <break> would all be included in the final parse section/field. 

You could also do it a little less visual and just identify/type the character count you want for each column.  If you really want to enhance this idea, you could also include the ability to name the fields and prescribe the data type.  Those would just be gravy on the meat of the idea however, which is, provide the ability to parse by fixed length fields.

 

 

 

Hello!

Currently when using the formula tool, you can create a string using the two following methods:

With speech marks, or an apostrophe being used respectively.

 

I would expect both of these methods to behave the exact same way, however what is interesting is that if you type within the apostrophes anything that would prompt a formula, this is still prompted:

This is not the case within the speech marks:

This can cause mistakes with autocompletion when typing within the field. I propose a small QoL change that the formula tool will recognise a string is being written when within two apostrophes. I believe the logic is already built for that, given that it behaves in every other way the same, and highlights green too. 

 

 

Cheers,
TheOC

Data Cleansing Tool:   There should be a sub-category on the "Punctuation" cleansing.  Ideally to have an option to "Include Only" or conversely "Exclude these characters" which would allow you for example to remove all characters except   "." from a dollar formatted field .  There are times when you need to clean almost everything except a certain punctuation or not. 

Trying to solve some use cases, I realized that I had to simulate the factorial behaviour.

Having a factorial formula can make this process easier.

Thanks!

Hello,

 

It would be very helpful to have a search box for field names in the summary tool, I think it would help decrease errors by selecting fields by mistake with similar names and will help gain a couple of seconds while looking around for a specific field, particularly with datasets with a lots of them.

 

Like this: