Alteryx Designer Ideas

I've been spending some time looking at low-code app development platforms, and one of the features that these have which it would be great to see added into Alteryx Analytic Apps is the ability to display results directly in the app interface pane.

At the moment when an app successfully runs the results can be shown in a pop-out window, as shown below:

An example from a low code built app is this:

Therefore the new feature it would be great to add is a browse result window within the interface tool, or a way to render the results and display that in the window.

Looking forward to hearing from others and what else have you seen with web apps that it would be great to improve Alteryx Analytic Apps with?

Alteryx is unlike many BI tools in the sense that it joins NULL. It is difficult to think of another platform that has this behaviour. Either people know about this and work around it or they don't and their joins are a ticking time bomb. Please add a check box to the Join and Join Multiple tools to allow or prevent joining NULL. This will serve to remove the need for workarounds as well as educate users about this default behaviour.

I like to suggest having a Batch Macro Container (besides the existing Container) which acts as a Batch Macro within a Workflow and is stored within the Workflow.

I understand that having a batch macro available as a separate tool can be very powerful and reduces redundant work.  However, very often Batch Macros are set up for a specific workflow only and are of no use for other workflows. The Creation of a Batch Macro in a container will significantly reduce the time to deploy a batch macro and keeps the Macro folder clean of one-time Batch Macros.

Attached a picture of how this could look like

Thanks

Manuel

I would like for it to be easier to change input (and output) tools to UNC pathing. I think adding it to the right click menu would be great. Currently, I have to go to options >> advanced >> workflow dependencies. A right click option would be easier.

Thanks!

When viewing results of a workflow that has Errors, could we add External error resolution data if the user clicks on the error message?  Like browse everywhere it could lookup the error in help and in community posts.  

cheers,

 mark

Currently, if you download and Alteryx package from an alternative version it doesn't allow import into a newer version.

Workflows allow this with a warning it would be good to allow it on packages too. 

Can we please have a tickbox (ideally one that remembers your preference to be ticked or unticked) on the Save to Gallery pop up that would allow us to save a (timestamped?) copy of that workflow on a local drive (perhaps one that is preset in the user settings)?

Idea: Build a version of Designer that runs on ARM devices without requiring an emulator.

Windows 10 on ARM is becoming an increasingly popular option for new devices.  Also, with Apple's move toward ARM, virtualized instances of Windows on Mac will either need to be the ARM version or will have much better performance over an emulated version of x64 Windows 10.

Emulated software is considerably slower than native binaries, so to maintain Alteryx's fast performance, an ARM version of Designer would be the best way forward for those looking to move to ARM platforms.

Have External Tables in Snowflake be accessible in the Visual Query Builder.

Current state: External tables in the Snowflake DBMS are not available in the "visual query builder" tab of the green input tool. These tables are only available in the "Tables" tab.

Alteryx doesnt support querying tables within Apache Ignite via Ignite ODBC connector. Connectivity from Ignite being an in memory database with Alteryx would help in better connectivity via ODBC.

https://apacheignite-sql.readme.io/docs/overview 

There is no way to natively connect to Xero. We also cannot use the download tool to connect to the API as it requires an OAuth2 Bearer Token generation step. Documentation for Xero can be found here: https://developer.xero.com/documentation/

I would request a tool similar to the Salesforce Input tool to be created.

Suggested process:

• Configuration Window to log into a Xero account
• Configuration Window to select the following
  • 1 or more companies ("all" should also be an option)
  • The specific "table" or "api call" you want to query - for example the "Sales Invoice" Data
  • Date Range filter (both from + to date combination as well as some generic "this month", "previous month", "this quarter" kind of selections)

I would also request that this tool be developed so that it can run on Server and Analytics Hub so that we can run end to end automation.

I've recently been playing with the 'Encrypt Workflow' capability within the platform, and it's great, apart from the fact that it is not possible to edit an encrypted asset, meaning users will have to store an unecrypted version of the file.

It would be great if the 'Serial Numbers' could be extended to allow certain users to be able to not only run the workflow but also edit the workflow. 

Pretty simple one, but one that would be hugely valuable, preventing the need to maintain an unecrypted version of the workflow on your machine.

Ben

It will be really great if we add Single sign-on (SSO) in download tool. Many users are facing this issue when they're trying to download data from weburl. In some case the url will verfiy the sign-on and then redirect to link from where we can download data. Currently download tool fails to verfiy SSO or siteminder authentication.

There is no way to natively connect to Microsoft Dynamics 365 F&O. We also cannot use the download tool to connect to the API as it requires an OAuth2 Bearer Token generation step. Documentation can be found here: https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v1.0/

I would request a tool similar to the Salesforce Input tool to be created.

Suggested process:

• Configuration Window to log into a Microsoft Dynamics 365 F&O account
• Configuration Window to select the following
  • 1 or more companies ("all" should also be an option)
  • The specific "table" or "api call" you want to query - for example the "Sales Invoice" Data
  • Date Range filter (both from + to date combination as well as some generic "this month", "previous month", "this quarter" kind of selections)

I would also request that this tool be developed so that it can run on Server and Analytics Hub so that we can run end to end automation.

Sometimes I find myself having to union too many tools together and get bothered with the drag-and-drop repetition. It'd be nice to be able to select multiple tools and have a "Union All" in the right-click menu that creates a union tool that is connected to the output of all the selected tools. 

It's kind of like a smarter "Insert After"

Hello all,

From https://www.sqltutorial.org/sql-triggers/

Introduction to SQL Triggers

A trigger is a piece of code executed automatically in response to a specific event occurred on a table in the database.

A trigger is always associated with a particular table. If the table is deleted, all the associated triggers are also deleted automatically.

A trigger is invoked either before or after the following event:

• INSERT – when a new row is inserted
• UPDATE – when an existing row is updated
• DELETE – when a row is deleted.

When you issue an INSERT, UPDATE, or DELETE statement, the relational database management system (RDBMS) fires the corresponding trigger.

In some RDMBS, a trigger is also invoked in the result of executing a statement that calls the INSERT, UPDATE, or DELETE statement. For example, MySQL has the LOAD DATA INFILE, which reads rows from a text file and inserts into a table at a very high speed, invokes the BEFORE INSERT and AFTER INSERT triggers.

On the other hand, a statement may delete rows in a table but does not invoke the associated triggers. For example, TRUNCATE TABLE statement removes all rows in the table but does not invoke the BEFORE DELETE and AFTER DELETE triggers.



So basically, I would like to create some triggers from in db tools in Alteryx.

Best regards,

Simon

Hello all,

Some Database, including Hive, support natively scheduled queries (yes, the scheduling configuration is inside the database, not through etl/dataprep system). I think this would be an interesting feature for in-db workflow output : you play the worflow once and then only have to run it when it changes, the database do the scheduling. 



https://cwiki.apache.org/confluence/display/Hive/Scheduled+Queries

Intro

Executing statements periodically can be usefull in

• Pulling informations from external systems
• Periodically updating column statistics
• Rebuilding materialized views
  

Best regards,

Simon

It would be really great to have Dynamic Detour tool where you could specify the detour direction as an input to the tool rather than an imbedded control.

This would allow workflow branching.

Using a filter for this passes a dataset with no rows in it which causes dynamic in-db or dynamic input tools to error.

I think there should be a tool that can take two proportions from the same row (so four columns: numerator population 1, denom population 1, numerator population 2, denom population 2) and return the z-score between the two groups, with a check box to select the desired confidence level.

We monitor quarter-over-quarter changes in satisfaction diagnostics for some of our surveys, and we report the change in Top 2 box % (answers of very satisfied or somewhat satisfied); and we typically only investigate the changes that are statistically significant at a 95% confidence interval.

I have to write about 8 different formulas within the formula tool to get me the z-scores between the groups I'm investigating. A z-score tool would greatly reduce my workload!