Alteryx Designer Desktop Ideas

It would be awesome if I could re-display the users selections to them before I continue with the remainder of the workflow in an analytic app. That way, I could collect all of the UI inputs, do my validation on the values provided and then re-display the selections/options/text to the user so they can confirm that they are correct and they wish to continue, or they can stop the processing and make changes via the already-open UI without having to re-enter everything from scratch.

 

Then, when someone selects something that's potentially harmful or very time consuming, I can confirm their selections and alert them to potential issues.

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.

Add a button to the zoom tools toolbar that zooms the workspace to all selected tools.

Add a button to the zoom tools toolbar that zooms the workspace to all tools.

We use the test tool extensively in our App and Macro authoring. It would be very useful to have the ability to label the tested values so that when the Test tool writes to the output window it’s more descriptive.
Example:
Currently this is the report
Error: Market (1): Tool #235: The test "The count of Columns does not match the count of Labels." failed: TargetNumRecords(#2)==102, NumRecords(#1)==106
 
 
A more useful report would be
Error: Market (1): Tool #235: The test "The count of Columns does not match the count of Labels." failed: Columns (#2)==102, Labels (#1)==106

The Alteryx icon image on the Windows tab at the bottom of the screen should change or change color when running and when a module has finished running. I got this idea from Teradata SQL Assistance. When the query is finished the little icon (which is sunglasses) changes from red (running) to green when complete. 

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

 

I use detours to bypass areas when I do not need them in the loop and it would be great if i just had a enable button (kind of like how you would control in a macro).  That way i dont have to disable 3 detours but just disable "button."

Same button should work with tool container 'disable' and/or collapse.

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

Can you add an ExceptionHandler to the Tile Tool? The tool crashed on a large dataset.  I got an Error: Tile (1): No values found before GetMean() on the tile tool. I selected Smart Tile option on the ‘unique_zips_count’ field and grouped by ‘ID’.
To track the problem down, I had to use the sample tool to grab x number of recs and see if it would run through the Tile tool. I had to keep skipping and selecting first N recs until I narrowed the problem down to 20 records. As it turned out. all values were 0 in a specific group. I found a workaround by pulling all recs per group with a value of 0 and bypassing these with the Tile tool. Instead of doing that - could you add an ExceptionHandler and specify which RecNo it crashed on?

Can you also add option to use 1, 2, or 3 std dev in addition to smart? This way all my groups will be uniform.
  

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

When using an App from the gallery, I would like to keep track of how many (Allocate dataset) checkboxes a user has toggled real-time by having a counter on the same form. Functionality would be the same as a winform which may contain a label control that contains a counter that updates every time a checkbox is (un)toggled. Then I would make the ‘Next’ or ‘Continue’ button active when a certain threshold is reached by the counter. So it needs to be dynamic. Maybe in general make the forms/Apps more dynamic so you have to do less chaining of apps?

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".

 

In Many of our tools,Before processing any file We create backup and move it to some backup with the datetime stamp.

Can we have such option like "CreateBackup" with timestamp in input and output tools?