Alteryx Designer Desktop Ideas

In Alteryx enable connections to Oracle Databases that are configured to use External Authentication.

This should allow Alteryx workflows to connect to Oracle databases using different authentication mechanisms, e.g. Kerberos.

 

Please see this discussion for some analysis on what would be required in Alteryx to support Oracle Database External Authentication:

• https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Oracle-Kerberos-based-Autheticataion-W...

 

Essentially this would involve Alteryx allowing users to specify that a connection to an Oracle database will utilize external authentication.

Then when connecting to an Oracle database with external authentication, Alteryx would pass the relevant parameter to Oracle to indicate external authentication is required (and Alteryx would not pass user name and password info). Then authentication with the Oracle database would be controlled by the external authentication configuration on the computer running Alteryx.

 

For more information on Oracle Database External Authentication see:

• https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-authentication.html#...

Hi,

        I would like to have something similiar to in SSIS called as Sequence Container implemented in Alteryx. A sequence container would ensure that the process flows in a particular order. Lets say I would like to read 3 different files having different schema each and I want to read/validated it in particular order. I don't see any tool that would help me do this.

 

I would like to see more files types supported to be able to be dragged from a folder onto a workflow. More precisely a .txt and a .dat file. This will greatly help my team and I do be able to analyze new and unknown data files that we receive on a daily basis.  

 

 

Thank you. 

My specific use case relates to writing to AWS but am sure there are many other use cases for federated user session token support.

 

Specifically, using the S3 Upload tool or Athena Bulk Write (via SIMBA and Athena ODBC), the configuration works when using a IAM user, access key, and secret access key but when using a federated user via Okta there is no option to enter the session token and authentication fails.

Alteryx desktop should support federated users' session tokens.

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.

Currently, the default location for autosaved files is "C:\Users\[username]\AppData\Local\Alteryx\Autosave".  It would be nice to be able to customize, the same way you can for the working directory.

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

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