Alteryx Designer Desktop Ideas

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 the question type "DropDown/ListBox", there's an option to use an external file. The file should be able to influence whether the record is selected or not. Maybe there's a reserved column name called "SELECTED" which could contain True/False values which the UI would key off.

 

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?

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:

 

 

 

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. 

 

I would like to suggest to contemplate the option to add a new SDK based on lua language.

Why Lua?

o is open source / MIT license

o is portable

o is fast

o is powerful and simple

o Lua has been used to extend programs written in C, C++, Java, C#, Smalltalk, Fortran, Ada, Erlang

 

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/