Alteryx Designer Desktop Ideas

I know for - the most part - the Alteryx core data bundle is the only one part of allocate. It would be great if you could open up allocate to the user so we can add our own third party data sources. Just tell us what the requirements are to make our datasets ready for allocate and then we can load it ourselves. Then we can use the allocate workspace to query data in a similar way.

for example:

Geography(DMA,*)
Variable(CYADULT18P,CYADULT18P,False)

It would help if there is some option provided wherein one can test the outcome of a formula during build itself rather than creating dummy workflows with dummy data to test same.

 

For instance, there can be a dynamic window, which generates input fields based on those selected as part of actual 'Formula', one can provide test values over there and click some 'Test' kind of button to check the output within the tool itself.

 

This would also be very handy when writing big/complex formulas involving regular expression, so that a user can test her formula without having to
switch screens to third party on the fly testing tools, or running of entire original workflow, or creating test workflows.

It would be good if an option can be provided wherein on clicking a particular data profiling output (cellular level) one can see the underlying records.

 

May be configurator/designer can be given this option where she can select her choice of technical/business keys and when an end user (of Data Profiling report output) clicks the data profiling result he can be redirected to those keys selected earlier.

 

One option might be to generate the output of data profiling in a zip folder which would contain the data profiling results along with the key fields (hyperlinked files etc).

 

Since in such case even data would be maintained/stored, it would be good to either encrypt or password protect the zip file based on various industry standards.

 

This can be provided as an optional feature under something like advanced properties for the tool, making use of the industry best practices followed in context of report formatting and rendering.

 

The reason why this should be optional is, not always there might be a need to have the detailed linking back to source level records in place.

 

For e.g. if the need is only to highlight the Data Profiling outcome at a high level to a Data Analyst this might not be useful.

On the other hand if there is a need for the Data Steward to actually go and correct the data based on the Profiling results, the linking of profiling results back to source data might come handy.

Hello! Almost all statistical softwares allow for the analyst to use either a pairwise or a listwise option when applying clustering techinques. This option affects only how the inner distance matrix is built, and after that whichever algorithm you choose is peformed. However in Alteryx [K-Centroids] by default does listwise, classifying only those records where the selected variables have no nulls.

 

Please consider adding this option!

 

PS: the difference is pairwise will build the distance between 2 variables depending on those records that have no nulls on both variables, while listwise will run the distance matrix after it has checked for complete non null records in all variables of interest (not one at a time distance calculation).

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.

Dear Alteryx Solution Architects,

 

When we were implimenting analytics solution for goverment clinet in UAE, we came across a sititation in which, It requires validation of supporting documents for data quality issues.While working on this challenge we have arrived at the conclution that Alteryx has some limittaion in incorporating attchments to workflows.

 

I would like alteryx to come up with something to overcome this issue.

1. There should be some tool or technique to incorporate multiple attchments (I know  limitted feature of attchment is there in Alteryx but its not great)

2. There should be an option to visualize attachment in Results window if its possible, It will be grat value add.

 

Thanks

Ajin

Alteryx currently shows 100% in the profiling of spatial fields in the results window, regardless of if there are rows with missing spatial features. I opened a ticket about this & was told it is expected behavior.

 

Therefore, I submit the idea that the profiling for spatial fields should give an accurate profile of the field, & if there are nulls in the field, it should identify that column isn't 100% OK and show the % of records that have null values, like the profiling does for every other column in workflows.

 

 

 

 

 

 

 

 

 

 

Thank you!

Hi,

The imputation tool allows exchange of numbers. It would be great if we are given the option to impute string values and NULL value too

The Basic Data Profile tool cannot handle files larger than about 40 MB and 33 fields.  When I add the 34th field, and the file size stays at 40 MB (Browse tool rounding), it breaks.

 

I'm trying to get the count of non-nulls for the  "Empl Current" field.  Adding the 34th field drops the non-null count down from the correct 25,894 to 26, and if I add more fields, the count of non-nulls drops to zero.

 

The Basic Data Profile tool is configured with a 10 million limit on exact count and 100,000 limit on unique values.

 

The whole point of the BDP tool is to get one's hands around large data files that are too big to manually inspect, so this tiny limit is really a problem.

Hello all,

 

Would love to see an analysis too or a major upgrade to the browse tool.

 

9 times out of 10, if i want to understand the data that is in my browse tool, i have to export it into excel just to filter and sort. This functionality is very much so needed in alteryx in either a new Analysis tool or (more ideally) into the browse tool.

 

What are yall's thoughts?

Nick

Sometimes, when I am working with new data sources, it would be nice to have a dockable pane that would allow me to view the schema of all of my connected data sources. That way I could rename fields and change data types as needed without having to jump from one select tool to the other to see how the schemas compare.

Please add a tool to edit different cells in table randomly and update the source after editing. Similar to the "Edit Top 200 rows in SQL". That would be very much helpful

Hi All,

 

I believe the following would help improve the functionality of Select Tool.

 

The idea is to have a defaulting option for each of the field in the Select Tool (which I believe should be a light weight Tool i.e. not adversely impacting performance and gives best exhaustive picture of all columns flowing through a (/particular point in ) pipeline).

 

Following are some of the cases where defaulting might come handy -

 

1) Fields which are supposed to hold monetary data - instead of Null, one can put 0.00 to help roll up summary properly.
2) Fields which are supposed to hold dates (say expiry date) - instead of Null, one can put some enterprise standards like 31-12-2099 to avoid mixing Nulls and 31-12-2099.
3) Fields which are supposed to hold purchase quantity/number of employees/number of merchandise - instead of Null, one can put 0 (and not 0.00) again to help with roll up summary.
4) Fields which are supposed to hold Currency - instead of Null, one can put USD.
5) Fields which are supposed to hold dates (say this time create date) - instead of Null, one can hardcode actual date, or an additional feature to put Now() kind of functions.

 

At present one of the options of achieving same might be to put a Formula Tool and to code whatever is desired inside the Formula Tool.

 

Benefits of having the functionality inside Select Tool would be -

 

1) It would be more user friendly and call for faster build to just write '0.00' or 'USD' or '31-12-2099' as compared to writing IF IsNull()... statements.
2) Inside Formula Tool, user needs to pull desired fields from the drop down and hence exhaustive view of all fields passing through pipeline is not available.

Pain in selection of fields from drop down and writing actual formulas might be aggravated with the number of columns increasing and might be more prone to human omission related errors.

 

Thanks,
Rohit Bajaj

There is a great functionality in Excel that lets users "seek" a value that makes whatever chain of formulas you might have work out to a given value. Here's what Microsoft explains about goal seek: https://support.office.com/en-us/article/Use-Goal-Seek-to-find-a-result-by-adjusting-an-input-value-...

 

My specific example was this:

 

In the excel (attached), all you have to do is click on the highlighted blue cell, select the “data” tab up top and then “What-if analysis” and finally “goal seek.” Then you set the dialogue box up to look like this:

 Set cell: G9

To Value: 330

By changing cell" J6

 

And hit “Okay.” Excel then iteratively finds the value for the cell J6 that makes the cell G9 equal 330. Can I build a module that will do the same thing? I’m figuring I wouldn’t have to do it iteratively, if I could build the right series of formulas/commands. You can see what I’m trying to accomplish in the formulas I’ve built in Excel, but essentially I’m trying to build a model that will tell me what the % Adjustment rate should be for the other groups when I’ve picked the first adjustment rate, and the others need to change proportionally to their contribution to the remaining volume.

 

There doesn't really seem to be a way to do this in Alteryx that I can see. I hate to think there is something that excel can do that Alteryx can't!