Alteryx Designer Desktop Ideas

In the Explorer box configuration section, it would be great to add a navigation button to pick a URL address (pin point) to a directory/folder so that the user don't have to learn by heart (or copy paste) the exact URL address to make use of the tool.

I have three groups: a control group, a group that got product A, and then a group that got product B. There is a way to test the differences across all groups rather than running separate t-tests (which introduces type I error several times). If my outcome is the percent of people who were contacted, I want to see if the percent is different across groups.

Control Group % who were contacted: 10%

Product A group % who were contacted: 25%

Product B group % who were contacted: 33%

I shouldn't have to run a t-test comparing control to A, then another comparing control to B, and then a third comparing A to B. I know the method is pairwise comparisons but I'm not finding how I can do this in alteryx and I've looked on the community and surprisingly the answer seems to be "you can't" but this is not a rare statistical test!

A product analyst at alteryx help build a macro in R to run the tests but the variables need to be categorical rather than continuous. The ideal solution is that an additional predictive analytics tool can run these ANOVA tests and there's something to specify whether the variable is categorical or continuous.

-Justin

Hi,

As it is so important to be able to calculate and present time related concepts in modern businesses, it is not possible to have a better output choice?  I have seen the reporting chart tool, I have looked at the TS Plot tool and even noticed that the Laboratory Charting tool has disappeared.  So can you please provide an output tool that provides some focused functionality on this lacking part?

Kind regards,

Peter 

Loading large grd files takes a long time, I see they load as polygons.  I find the data crunches much faster as centroids.  Please add "load as centroid" as input option (same as mapinfo "tab" files). 

Also, would be great to load as integer (or select data type), since there are often too many decimals.

Last, but not least, the ability to export as grd or grc would be great since there are other platforms that use these files.

Thanks!

Gary

1. The Union tool 

When switching to Manual method and then adding fields up stream, the result is a warning "Field was not found". I don't look for warnings. This should create a red error. Having fields fall off the workflow is a pain.

2. Unique tool

Changing fields upstream causes the tool to error out when the workflow runs. No issues are shown before the run. 

3. Having containers all open up when I reopen a workflow is a nightmare when you have 20+ containers all over lapping.

One of my favorite features of Alteryx is the in-line browse in the results window, as well as the descriptive log, highlighting record counts into and out of tools.  As I develop bigger and longer-running workflows, I would love to be able to save off these results to provide my QA analyst with a "cached" version of a run without them having to run it themselves.  Providing them not only with a well-documented workflow, but with a complete data flow would be tremendously helpful in getting work checked.  Our current process is to pass workflows off, and encourage the QA analyst to run them with the "Disable all Tools that write Output" option checked.  While this is not an issue for smaller workflows, it is inefficient for larger ones, and also can cause some difficulties with access logistics like missing or inconsistent connection aliases.

I have seen some requests asking for saving of browse results (https://community.alteryx.com/t5/Alteryx-Product-Ideas/Save-Browse-Results-Until-Next-Run/idi-p/1827), but these primarily seem to be geared at data caching for further workflow development.  My aim is to save the browse and results statuses of a completed workflow for the purpose of QA.

Note: I posed this as a question in the Data Preparation and Blending forum, but didn't receive an answer so thought I would propose it as an idea.

It would be great if the deselecting of fields in a select tool updated the output window(before next run) as a "review" to make sure you are removing what you expect and/or you can see other items left behind that should be removed. This would also be useful for seeing field names update as  you organize and rename.

Often I join tables w/o pre-selecting the exact fields i want to pass and so I clean up at the end of the join. I know this is not the best way but a lot of times i need something downstream and have to basically walk through the whole process to move the data along.

As recommended by HenrietteH at Alteryx to submit as a suggested future enhancement.

I have Oracle 11 and Oracle 12 clients on my machine. With Toad, I can toggle between either client's current home, but it appears that is not a feature in Alteryx. So now I am unable to execute ETL jobs off my machine or server because Alteryx gets confused. Currently, the only remedy I can think of is having 11 client uninstalled, which can cause dependency issues if I need it in the future.

In the DateTime tool, you should be able to specify AM PM.  Some other programs I use would do this with an 'a' at the end.  Here is an example of what I think it should be

MM/dd/yyyy hh:mm a

Maybe I am missing something and this is already doable, but so far I haven't found a clean way to do it. 

This may be too much of an edge case...

I would like to be able to feed a dynamic input component with a input file and a format template file, so make the input component completely dynamic.  This is because I have excel spreadsheets that I want to download, read and process hourly throughout the day.  Every 4 hours another 4 columns are added to the spreadsheet, thereby changing the format of the spreadsheet.  This then causes the dynamic input component to error because the input file does not match the static format template.  I would be happy to store the 6 static templates, but feed these into to the dynamic input with the matching input file, thus making the component entirely dynamic.  Does this make sense???

BTW, my workaround was to define six dynamic inputs, filter on the file type, then union the results:

Hi, 

I am currently using Oracle Discoverer Tool which has option to drag or place an results column of a table or cross tab on to page items so that I can further filter the results. This helps the user to filter large results set without even downloading the output. I have attached a screenshot of current tool with page items.

Regards,

Sunil

Hello all,

It would be awesome to see an obvious change to the Input Tool when you change the setting from Cached to Not Cached. Something simple so that as the process is running i can clearly see what that setting is opposed to having to stop the process and restart it.

Thoughts?

Nick

Alteryx current C5 implementation requires very carefully crafted data to work.

This is fine in an academic environment, however production datasets are rarely available with such low level of tolerances.

Competing products have implementations that will not fail as easily and Alteryx doesn't have any other multi-way decision tree option.

A good alternative would be otherwise a tool that does some dataset diagnostic so that we at least can know where the problem is without having days of data scientist time to comb the dataset.

Thank you,

Marco

Can we have string function that parse the string between 2 indices?

As FindString can find particular string occurrence,we can easily get required part of string easily from that index till required index.

or If we want entire remaining string we can have a function like:

Substring(String,StartIndex,EndIndex) Where endIndex can be : Length(String)-1

When working within the canvas/properties the mouse is the primary tool and allowing a middle click would be an easy way to initiate the workflow.

Currently, middle button can be used for moving in the canvas area (click and hold) and closing it (click on the tab).

Hi All,

I had posted in the Tool Master | Unique thread about how when I use this tool it does not preserve my sort.

This seems odd to me. I understand that it's "a blocking tool and that records are then sorted prior to executing the tool process" as @TaraM points out. However, in a program where data is explicitly manipulated to a condition, there is an expectation on my side (maybe mistakenly?) that if I sort something that it would not be changed unless stated or indicated in some fashion. 

For my use case I was sorting to eliminate the duplicates, then joining that data to eliminate other duplicates and outputting the resultant to my users and future-state will be automatically fed into a system, for each stage it matters that the sort function is kept intact.

I know it's a simple complaint / fix, but its unexpected behavior on my end and could mean less confusion and less tools on the board. which is always a good thing in my book.

Wonder if it would be possible to have a set of SQL tools in Alteryx which to the user would look like you are dragging in a tool to manipulate the data (such as filtering data) but in the background it is updating the SQL (such as adding a WHERE clause) meaning the module runs faster. This would be easier than having to manually update the SQL code and would run quicker than bringing all data through and filtering afterwards.

I know there is currently the Visual Query Builder, but this is quite fiddly to use so would be good to have something more user-friendly.

When enriching your date data, week information is pretty critical, I suggest adding %w to the format stings as well..

Several month based expressions can also be made weekly, data time first of week #31, last of week #45 etc....

Also came across a lot of questions at our community on how to turn week based data...

Writing the formula is obvious (Ceil(DateTimeDiff([Today],[Date],'days')/7))

but having a DateTimeDiff([Today],[Date],'weeks') is preferable don't you think?

Cheers

It would be nice to have the option to open a macro from the configuration window.  I often use the find tool to locate macros and sometimes they are in collapsed tool containers or buried under other tools and it makes it difficult to right click on the tool itself.  The find tool brings up the configuration window so if there was a button on that window it would make opening the macro more efficient.