Alteryx Designer Desktop Ideas

Is it possible to add some color coding to the InDB tool.  I am building out models InDB and I end up with a sea of navy blue icons.  Maybe they could generally correspond to the other tools.   For example the summary would be orange.  Etc  Formula Lime Green.

It would be great if I could save a tool and its configuration for future use. I'm sure this could be done now with a macro, and that's possibly how I'll do it.

 

The scenario is that we have numerous data inputs that require some finessing to import. Because the field headers are not in the first row, they aren't recognized accurately as comma delimited. But some of our fields also contain commas within the field, so the solution is to add a multi-field formula to replace things like ", Inc." with " Inc." and ", Ltd." with " Ltd."

 

But on occasion I find new text strings that need to be added to the formula, like ", Inc" (without the period) for instance.

 

I use this replacement technique with several workflows, so it would be great to change it just one time and have the other instances updated automatically.

 

Maybe in addition to our Favorites toolbar we could have a Custom or User toolbar where we could save tools along with their configuration.

Can we move the "Save" disc that's above the tool ribbon to someplace that is not so easily clicked?  Maybe by icons that aren't used as frequently used as the new and open folders are? 

When using ./*.csv for an input (relative path and wildcard), a preview does not show in the Properties area of the input tool.  Can this be added?

It would be great to just have a little tool like a comment box that could be based on whatever you want... like if you always want to see the max date at a certain point, or the grand total. It would be similar to how you can put formulas in the titles in Tableau like "Current as of <MAX(Date)>" or something like that. The best way (I think) would be to have it like the Annotations, but make it so you can turn it on or off at any stage in the workflow (right now annotations are only show or hide all) and make it dynamic based on results from the workflow up to that point. Right now I'm accomplishing this just by using a summary and browse tool, and then I put the result in the title of the toolbox manually.

Sometimes when you make changes to a filter tool or some other tool's configuration and immediately click on another tool on your workflow, the chanegs you made to your first tool won't register.  The only way to get them to register is if you click the canvas afterwards.

When scoring data if you have values in predictor fields not seen in the data that was used to build the model the score tool will not score the record.  Makes sense but it would be nice to know how impactful the issue is.  Please provide a count of records not scored for these reasons as well as a count of records not scored because of exceeding the limit in the configuration tab of the score tool. and a count for any other reason a record is not scored so we have a clear understanding of how many were scored and how many were not and why.


 

While trying to debug data parsing, I end up with browse tools all over the place and it makes the pallet a mess and time consuming to organize.

It would be much nicer to just have a little corner of all icons to have a sub icon or something I can click on to see output.  Multi output could be a little more tricky ... so better yet, maybe have small browse icons on the connectors you can click on for results of that feed?

Then have a menu option to turn all off/on.

I have the Show Properties Window selected, but it is not showing up on my screen. At first I thought it was just hidden and that I could just pull it back from being hidden, but I can't find it anywhere. 

Thanks! 

Like the ability to create data tables for reporting purposes, makes life a lot easier.  I would like to suggest the ability to be able to define the height of each row in the table.  There is a lot of wasted space between the rows and becomes challenging when you are trying to work with getting everything on one page or keeping the table contained within a box on the report.

I would love to have alteryx dump the excess amount of records on a new sheet in the same excel file that the user creates for dumping the output.

Problem: When you configure fields manually in the union control and then go back to remove a field it throws up an error that "XYZ field missing"
Solution: One needs to change the config to "arrange fields by name" then refresh before you can arrange fields manually

I would like this problem to be handled by some method that tracks for changes and warns the user rather than throw an error.

Correct me if I am wrong, when I use the trade area tool, the only non-spatial data appended to my input dataset is the RadiusSize field. Can this be expanded to include the Units selected (km, miles or minutes) and the dataset used for drive time, plus AreaSqMi, etc? Values like 10 in my RadiusSize field are useful but I would like to have all Trade Area details.

Actually, could you incorporate trade area tool into the spatial match tool since these tools are usually used one after the other?

Bedankt!

The tabs for the Workflow-Configuration sheet has the Canvas tab as the first one and defaults back to the Canvas tab after running.  I want to be able to have the Workflow tab be the first tab and return to the Workflow tab after running.  This can either be the default, or user-selectable ordering of the tabs.

Thanks.

I have a strong feeling Alteryx doesn't handle ascii control character End of medium (EM) when writing to an excel sheet. Created an unreadable excel file. However if you write the same data to csv and then open it in excel everything is fine. My idea is to have the bug fixed or to be informed what I did wrong.

I would like to use the precreate statement as part of a app. That means if a user selects ID '12345' from an interface tool, I would like to delete recs in SQL server with that same ID through the pre create statement, then afterwards I would append new records with the same ID.
What I really miss is having the ability to send one Name & Value to an interface tool like label or readonly textbox.Then I could use Label/Textbox->Action->Output and change the precreate statement that way. 
I tried the formula way but SQL think I am running a stored procedure.
It looks like I need to use a listbox or dropdown tool and do it that way but that means I am cluttering my app with unnecessary tools. 
Could you give interface tools a 'hide' property or allow a field to be passed to the pre-Create SQL statement?
Unless there's another way to do all this? 

Currently if I receive a file where fields are empty rather than Null(), the summarize won't count them with the CountNull option. Fairly easy to put a formula right before when there is just a couple of fields and change with an IF IsEmpty() but with a file with a large number of fields and large file size, a multiple field tool eats up a lot of time converting.  Not sure if it would just be trading processing speed in the summarize to do basically the same thing.

Hi ,
Today i stuck in one position where my current module gaves an error because it doesnt found the Fields name. I define the field name in Formula tool for validation and harmonization. So as my Fields changes formula is also changes. But i donot want to make any changes in my Module.

So what i am thinking it will be better that we can define a formula in any file format like (.xlsx or .csv) and take the Input in formula tool.
So we do not have to change the module again and again. We just need to change the mapping file against the lates file coming. So we can check the file and define the formula in mapping file.

Thanks in Advance.

Hello,

I think it would be extremely useful to have a switch connector available in Alteryx. What I mean by a switch connector is a connecting line with an on/off state that will block the data stream through it when off. Something like below:


Switch Connector in an "Off" state

This would be extremely useful when you only want data to flow down some of the paths. In the example above, I might turn the switch connector to off because I want to see the Summarize results without outputting to a document.

The current methods for having a path/set of tools present but unused are insufficient for my needs. The two methods I and Alteryx support were able to find were: