Alteryx Designer Desktop Ideas

This may be a bit of a pipe dream but having an interface that would automatically and efficiently implement quantum computing functionality against different back ends would position Alteryx to be a user friendly interface to the quantum computing realm. My feeling is that, at the end of the day, most people will know quantum programming about as well as they currently know GPU programming, which is to say not at all. They'll need an easy-to-use tool to translate their wants to some form of quantum speed-up. Q#, Qiskit, Cirq and Bra-ket are neat, but suppose Alteryx had a "quantum solver" tool that would handle a lot of the dirty work of setting up, say, a quantum Grover Search, where the user just describes what they need.

I know some of the heavy hitters are already trying to simplify the interface to the quantum realm (e.g. as of 1/1/2021: Google Cirq, Microsoft Q#, IBM Aqua, AWS Braket all moving beyond basic enablement into realms of user friendliness.)

Just a thought!

Currently there is a maximum amount that can be passed into the Dynamic Input, 1MB. I often hit this limit and it is infuriating.  If this was upped to 5MB that would solve a lot of my issues, but 50MB would be AMAZING.

Thoughts?

-Nick

I'm stealing this idea from Tableau's number formatting, it's a timesaver.

In the DateTime tool if I've initially selected a value besides Custom in the "Select the format..." list then when I click Custom rather than having the Custom textbox be blank I'd like to have it automatically populated with whatever formatting string I just selected. Here's an example screenshot:

Using the Download Tool, when doing a PUT operation, the tool adds a header "Transfer-Encoding: chunked".  The tool adds this silently in the background.

This caused me a huge headaches, as the PUT was a file transfer to Azure Blob Storage, which was not chunked.  At time of writing Azure BS does not support chunked transfer.  Effectively, my file transfer was erroring, but it appeared that I had configured the request correctly.  I only found the problem by downloading Fiddler and sniffing the HTTPS traffic.

Azure can use SharedKey authorization.  This is similar to OAuth1, in that the client (Alteryx) has to encrypt the message and the headers sent, so that the Server can perform the same encryption on receipt, and confirm that the message was not tampered with.  Alteryx is effectively "tampering with the message" (benignly) by adding headers.  To my mind, the Download tool should not add any headers unless it is clear it is doing so.

If the tool adds any headers automatically, I would suggest that they are declared somewhere.  They could either be included in the headers tab, so that they could be over-written, or they could have an "auto-headers" tab to themselves.  I think showing them in the Headers tab would be preferable, from the users viewpoint, as the user could immediately see it with other headers, and over-ride it by blanking it if they need to.

Passing Access and Secret Keys to connect to AWS S3 poses a security risk. It would be great if the Amazon Redshift Bulk Connection tool was enhanced to include an authentication option to use a Native IM group instead of keys.

Hello gurus - 

Pretty much every coding framework supports this.  If we really want Alteryx to embrace no-code, we've got to have some ability to control commit / rollbacks across transactions.  As it stands currently, it is pretty easy to write out parent records, fail to be able to write out children, and wind up with a database state that makes the end users very sad.  

Thanks!

brian

When reading and writing large data frames to/from a python script in Alteryx it seems that there are limitations to the SQLite component of the tool. Given that this selection is recommended only when the user is having issues in the python tool why is the option selected by default? A colleague and I spent a couple of hours trying to work through an issue with importing a data frame larger than 1000x1000 and once we found this option (SQLite override) and unchecked it the data was written back to Alteryx without any problems.

Hint provided by the tool, "This changes the intermediate data format between Alteryx and Jupyter from yxdb to SQLite. Use only if running into issues. See help for more details."

SQLite override is default selection

Error message provided by the tool

After unchecking the option the workflow ran without any errors.

Recommendation: the python tool should default to SQLite override unchecked

Hi - think it would be great to have to open only one debug window, and where I add to my workflow, the debug automatically updates to include the new features of my workflow.

As it is now, I believe that I have to open a new Debug window where I have added new components to my workflow. 

Hello All,

We are new to Alteryx and we could see that the Supported Data Sources from IBM are of below :

• IBM DB2
• IBM Netezza/Pure Data Systems
• IBM SPSS

How about adding IBM Sterling to this?

We want Alteryx to support connection with IBM Sterling OMS which will help the Business requirements

Can anyone post some suggestions on this? How we can connect to Sterling?

Thanks,

Praveen C

Idea:

As a method of deploying preprocessing and ML models it would be awesome to be able to convert a workflow to java... 

Rationale:

models are needed to be deployed into Complex event processes or decision systems. Even for SAS there is a need to implement the datastep algorithms and procs to run in JVM.

Quickwin:

It is possible to convert a workflow into a PMML file and then use JMML package to convert that to Java. Yet the full workflow with all preprocessing alternatives and a series of ML methods may not be captured fully.

Competitor example:

For SAS case here is a similar solution: http://www.dullesresearch.com/carolina-features/

Posting this idea after searching the community postings and then submitting a question to confirm:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Function-to-convert-to-from-HEX-encode...

I could invest the time into creating a macro to do what I need, or per @MichaelF suggestion a custom formula. However, the functionality already exists in the Blob Convert tool, so I'm suggesting that Alteryx provides that existing functionality to customers in a Formula.

I checked the Conversion formulas:

https://help.alteryx.com/2019.1/Reference/Functions.htm

And found other users talking about making a macro to do this:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Hex-to-ASCII-Conversion/m-p/344126

Could Alteryx add a new Conversion formula to convert a field to/from HEX/Base64 formats similar to the current Code Page conversion functions?

Thanks,

Cameron

how to share Custom Tool Palette (along with Macros) with other users. 

For eg, I have created a custom tool palette named "Adhoc Analysis" with few macros; something like attached.

Now, how to make sure that all my user base can have same palette in their local alteryx designer. 

After some research, I did found that I could share macros with them by putting all relevant macros on Alteryx Server, and users could then pick the macros from there. 

Although, I wanted to suggest this as an Idea for future releases, it would be great to have an option or way, on how to share this with users in their local designer without much hassle.

Not sure, if this is something worth exploring from Alteryx development team side. But thought of suggesting to community if this could help others.   

Thanks for your help. 

Ravi Sharma

Please test/certify Teradata 16.2 for designer, server, scheduler, and Gallery applications.  

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.

I was trying to check the correctness of multiple URLs with the help of download tool connected to parsing tool that way I check the download status and filter the records to good and bad based on the HTTP status codes. To my suprise it allows 2 errors at the maximum ans stops checking next records which is not at all useful for me. I wondered if someone can help me. As @JordanB say it is the default behavior of the tool and can't be handled as of now. Hope you guys have the error handling feature in your next release. 

Saketh 

When I maximize the SQL Editor Window within the Input Tool only half of the screen show the SQL window.  The bottom half of the screen is useless grey space.  Why not have most all of the screen be the SQL window and only a small portion of grey border for the Test Qry, Ok, Cancel and Help button?  I'd like to see more SQL and less wasted space.  Thanks!

Similar to the regular formula tool, it would be great if we would be able to configure multiple text to column processes within one tool rather than having to line up several tools when having to convert various fields of different logic at the same time.

Is it possible to have a Sum(Column) or Total(Column) functions in formula tool? it will make the calculations much better as we don't need to use "Sum tool + Append tool + Formula tool + Select tool" or "couple of formula tools and then a select tool".