Alteryx Designer Desktop Ideas

It would be very powerful to be able to multi-thread batch macros. Since the data for each batch is known and unrelated between batches, it seems like the processing of each batch could be distibuted to multiple processors without issue. This could dramatically increase performance in certain situations.

It would be great if we could output the coefficients of regression equation to a table so that one can use them in rest of the module. Currently, Alteryx can output the table/coefficients in charts/reports form which is not re-usable as such in the module. 
The values of coefficients/Residuals/Errors would be very useful in building macros for techniques like Missing Value Analysis which can't be done in Alteryx as of now.

Possibility to deselect fields directly in the input (shape, csv, tab, etc).

 

It would be useful to have the count of rows show up under Browse icons once a module was run.  While debugging, I often have a number of Browse icons scattered about.  It would be nice if I didn't have to click on each to see how many records made it that far.

Thanks!

Probably a small request, but please consider updating the Output and Browse tool icons so they are easier to tell apart from one another.

When working with large modules, I often need to update Output paths or make sure I'm not overwriting data, and the two tool icons are so similar they are hard to pick out.

Thanks!

Both of these can be partially accomplished with the output of the directory tool:

- List Directories - Summarize unique list of directories from the directory tool output

- Exclude Paths - use filter tool to exlude files or directories based on patterns

 

 However, here are some scenarios that aren't addressed cleanly:

- Directories are not listed unless there is a file contained within.  The tool is called Directory, but it only lists files.  The directory has to be non-empty to be listed.  An option is needed to either list files and/or directories (including empty optionally)

- I can't figure out whether the file specification is a wildcard expansion only or supports regular expression for inclusion/exclusion. I see in the File Browse tool that you can list multiple formats e.g. Text Files (*.txt)|*.txt|All Files (*.*)|*.*.  Here is a use case where this is required.  Our network shares have Windows file restore snapshots stored in a ~snapshot directory.  We don't want the directory tool to traverse this directory (because it literally takes hours to scan), but there isn't an elegant way to exclude it.  If you filter it from the directory tool output, it's already scanned it. What we've done is generate the top-level directory list outside of the tool and fed it into a macro that has a directory tool (with sub-directory scanning enabled) inside. 

- Another way to address this specific scenario woudl be to have an option to exclude traversal of "hidden" folders.  But a more generic approach is ideal.

I think it would be a nice feature if a user were able to export the list of tools and annotations in a way to use as the foundation of a process memo (or simply listed sequentially in an appendix). We're using Alteryx for tax data prep processes and documentation of the process is important.  So I believe getting the workflow into words would be a great addition.

I have several modules that need to run in sequence.   Can a ksh or some other program be used to string the modules together?  

So that if I have Step1.yxmd, Step2.yxmd and Step3.yxmd.  2 is dependent on 1, 3 is dependent on 2.  I want to tell it the jobs to run and then to wait until that module completes, then run the next.  


run Step1.yxmd
Wait

run Step2.yxmd
Wait

run Step3.yxmd
Wait


Or, if I have a group of modules that can run concurrently but subsequent jobs are dependent on all of them to finish, i can let all those jobs run and have the next step wait for those to complete to begin.  

run Step1A.yxmd
run Step1B.yxmd
run Step1C.yxmd
run Step1D.yxmd
Wait

run Step2.yxmd
Wait

run Step3.yxmd
Wait


I know this is very simplistic, but hoping it shows the need.  Also, we do have the scheduler set up to use, so if there is a way to set dependencies between modules within Scheduler, that might be helpful.  Just haven't found anything.  

Thanks!

It would be nice to have the ability to double click the top area of a container to either show or hide the container's objects. Only being able to show or hide containers using the arrow icon in the top right is quite cumbersome for large containers because it requires a lot of horizontal scrolling in order to change the desired view of the modules workflow.

Currently when I open and run an app in designer mode im unable to access any other modules while it runs.  It would be nice to be able to work on other modules while an app runs without opening a debug.

Seeing how we use browse to tools to help build out modules, but they slow down the modules because they write out temp files, it would be awesome to have a "record count" option similar to the input tool. This would allow us to see the data as it's flowing through the module without slowing it down.  Adding a sample tool before every browse would be fairly cumbersome. 

When building an expression (e.g. [Store Type] in ("Supermarket", "C-Store", "Gas Station") ) when the user selects the field variable, provide all the unique values in that field so user can double-click and add them to the expression, without having to look and see what values are in the table, what data type (shows quotes if string) and manually type the values, which can lead to errors.

This functionality is currently available in GIS programs such as ArcGIS and Quantum GIS (QGIS).

 

There is MD5 hashing capability,using MD5_ASCII(String) and MD5_UNICODE(String) found under string functions

it seems to be possible to encrypt/mask sensitive data...

 

BUT! using the following site it's child's play to decrypt MD5 --> https://hashkiller.co.uk/md5-decrypter.aspx

I entered password and encrypt it with MD5 giving me 5f4dcc3b5aa765d61d8327deb882cf99

Site gave me decrypted result in 131 m/s...

 

It may be wise to have;

SHA512_ASCII(String) and

SHA512_UNICODE(String)

 

Best

 

Altan Atabarut @Atabarezz

I've found that double-clicking in the expression builder results in varying behavior (possibly due to field names with spaces?)

 

It would be great if double-clicking a field selected everything from bracket to bracket inclusive, making it simpler to replace one field with another.

 

For instance:

 

Current:

IF [AVG AGE] >=5 THEN "Y" ELSE "N" ENDIF

 

Desired:

IF [AVG AGE] >=5 THEN "Y" ELSE "N" ENDIF

In some corporate instances that I have encountered, browsing to the internet is not supported. What I've also seen is private instances of wiki media and yammer. Perhaps we could extend the browse to support these types of instances.

Cheers,
Mark

Another seemingly minor one that would just make life a little easier and clean up workflows.  I often find myself renaming the Name/Value fields from a Transpose to be more descriptive.  Currently this requires a Select tool after each transpose, and it would be nice to put a couple of text boxes at the bottom of the transpose to rename Name/Value directly in the tool itself.

It would be really great if the formula tool could support statistical calculations.

I have tried calculating the binomial distribution and the beta function, but was unable to as there is no way to do 'factorial' or 'combinations'.

Perhaps the R tool could do this, but it would be really nice to do this in the formula tool.

I would like to be able to load large amounts of data into my MSSQL database using a faster interface.

To increase Performance on some old Buissness Logic, i am trying to switch an existing system to In-DB tools. This has given me a lot of headache because there is no Multi-Field Formular Tool in the In-DB section. It is a very tedious job to run through every workflow to manually set the same regex for a table with more than 20 Fields. 

 

I have had the idea to implement such a tool myself but i think this could be helpful for other developers in Alteryx Desktop too, so i am bringing this up here.

The Idea is to have a similar approach to the new Multi-Formular Tool like the other already existing Tool in Preperation.