Alteryx Designer Desktop Ideas

my company utilizes a lot of power pivot, but I am not seeing this as an available data source. Could this be implemented so that we could seamlessly incorporate our existing power pivot tools into ALteryx workflows?

In continental Europe, decimals and comma are used differently.  The number 1,345,678.99 would be written in some countries as 1.345.678,99

As a suggested enhancement request, it would be good in the Alteryx user settings to be able to select a country style setting to be applied to numbers throughout the software, such as in a browse, table, report etc. so they are displayed correctly for that user.

I have have the topic similar to this suggestion found here Export to Visio. However I came to the community to stick my neck out an suggest Alteryx provide a new product offering.

 

I believe it wouldn't be a big jump for Alteryx to provide a platform to process design, similar to Visio. Coming from a BA background, I didn't come up with a technical background. When I first viewed it, I rationalised the software as a process design program which was more than pictures it, it actually manipulated the data. The look and feel is already setup, just adding some swimlanes and some icons which don't do anything would be all that is required.

 

This could be offered as a add-on, a stand alone, or something else - I'd leave that to the marketers. I just know if I could wrap up a data work flow, and potentially a business process designed in the one platform - it would be an advantage.

 

 

I haven't seen this idea posted exactly this way...

Right now the browse results are only available while a workflow is open. It would be great if they could be saved until the next run, because sometimes I have to do things in stages, saving and closing a workflow, then continuing on it another time. I would love to have the browse results fromt the last run still be there until I re-run it.

Currently I am able to apply smart tile to only one field. If it could be applied to multiple fields at the same time it would optimize the workflow.

 

Thanks,

Keerthana

Please let me know if I've overlooked a suggestion and I'll be glad to upvote that post.  

 

Just as we're able to right click a input and turn it into a macro imput for example, it would be helpful to turn formula into In-Db formula and the same goes for all the other tools that are available both inside and outside In-Db.

 

I created several fields inside a formula tool and later on, I had to do the same but In-Db, the field names and rules were the same, if I could I would just turn the one I already had into an In-Db tool.

 

Thanks.

Generate an output to a database store.  Tell it you want to have a custom mapping.  You cannot resize the box.  If you have verbose column names, you wind up scrolling a lot.  I've done all of this super amazing work to aggregate data from N datasets, work I never would have thought to try to code, and at the last inch am resorting to scrolling back and forth like a chump!  

 

This is an easy, easy, easy fix.  

 

/endrant

I'm a brand new user to Alteryx. I have Designer + Scheduler. I had read about the advantages of MongoDB. I went into the Scheduler System Settings and changed it to MongoDB to find that the service didn't start, among other issues. 

 

Come to find out, MongoDB is not supported for Scheduler-only installs/licenses. 

 

Therefore, I believe that the option to change the db storage for scheduler-only installs should be disabled. 

TLDR: Add a parameter repeat (rep) to the Neural Network configuration panel, and probably other Predictive tools. This would make the tool return only the best trained model out of #rep.

 

I have done some research by comparing the R neuralnet function (from Neuralnet package) and the Alteryx Neural Network tool. I thought that the XOR example was a good one to evaluate a neural network system since it is one of the most basic non-linear tables.

 

• R Neuralnet function

The neuralnet function is able to train and predict the 4 configurations of a XOR table (see page 3 of https://cran.r-project.org/web/packages/neuralnet/neuralnet.pdf for the test script).

 

However several attempts must be made. This is why the parameter

rep=5

is important, followed with

plot(net.xor, rep="best")

This way, instead of 1, 5 sets of initial parameters are randomly generated and 5 neural networks are trained independently. When plotting, only the neural network with the lowest error is plotted (I got 3% error). For XOR, around 5 tries seem to be enough to find a set of parameter that guesses the 4 situations of the table correctly.

 

Another parameter of the function is stepmax:

"The maximum steps for the training of the neural network. Reaching this maximum leads to a stop of the neural network’s training process."

This rules the max number of iteration for each single attempt viewed previously.

 

If one writes stepmax = 100 instead of rep = 5, the only resulting Neural Network usually does not have an average error below 5% (actually I get 49,7%).

 

• Alteryx Neural Network

The Neural Network tool in Alteryx has a parameter documented as follow

"The maximum number of iterations for model estimation: This value controls the number of attempts the algorithm can make in attempting to find improvements in the set of model weights relative to the previous set of weights. If no improvements are found in the weights prior to the maximum number of iterations, the algorithm will terminate and return the best set of weights. This option defaults to 100 iterations. In general, given the behavior of the algorithm, it is likely to make sense to increase this value if needed, at the cost of lengthening the runtime for model creation."

 

I tried this workflow with this parameter set to default value 100, and even greater values, and I cannot get an average error below 5% (I get stuck around 50%).

 

After reading carefully these pieces of documentation and testing, I can guess that this last parameter is the equivalent of stepmax. 

 

If this is right, then it would be practical to add an equivalent for the parameter rep to the configuration panel. This parameter seems more useful than rep to me. Maybe there is already a way to simulate this parameter; if that is so, please let me know, otherwise I am going to include an R script to my workflow.

Hi alteryx can you please create a poll or an forms to fill or approval processes kind of tools . I know we have some analytics app tools but can we create something like google forms where we can easily create forms and get data outputs. Emails notifications for those forms and approvals .. etc ..

Hello,

 

When working with my company’s IT department, they do not allow employees to have admin rights to their computers. This becomes problematic when trying to use the CASS download and not being able to install it. Is there a way to get the CASS data install to be a non-admin like the Alteryx tool? This would be very helpful!!

 

Thank you

Rapid Mouseless Development Step forward!  We're so close -

 

Please:

 

1.  Add a hotkey to bring the cursor to Global Search and/or engage global search whenever you start typing in a contextless location (whitespace)

2.  Enable arrow key navigation of the elements of global search

3.  Hitting Enter key from global search would insert the selected tool after the last touched tool on a workflow or in the workflow at a logical point (bottom rightmost bound etc), focus would not be transferred to the inserted tool, but should either remain context-less or stay in Global search

4.  Hitting the TAB key from global search would insert the selected tool, just like Enter but take you to the first element of the inserted tool's configuration.

 

Take your development speed to new levels by reducing the keyboard to mouse to keyboard back and forth.

 

 

 

 

 

Example Data:
MJE Text	Ref Fld 1	Ref Fld 2	Ref Fld 3	Date	NTID
Accrual	MJE Load			11/1/2019	DAVET
Fx Reval	Accrual			12/2/2019	MOLLYI
		Acc		3/4/2019	BOBH
Forex Fx			CCRUAL	7/9/2019	GREGA
FASB				8/5/2019	BOT7
Tax				10/6/2019	BOT88

 

I want to use contains to search multiple strings and "IN" for multiple targets within the same formula. 

 

IF Contains(([MJE Text]+[Ref Fld 1]+[Ref Fld 2]+[Ref Fld 3) IN("Accrual","Acc","CCRUAL")) THEN "Accrual" ELSE "" ENDIF

 

Result would be:
MJE Text	Ref Fld 1	Ref Fld 2	Ref Fld 3	Date	NTID	Group
Accrual	MJE Load			11/1/2019	DAVET	Accrual
Fx Reval	Accrual			12/2/2019	MOLLYI	Accrual
		Acc		3/4/2019	BOBH	Accrual
Forex Fx			CCRUAL	7/9/2019	GREGA	Accrual

 

Can this be developed?

I'd like to be able to quickly  see how many records were read from my inputs and written to my output so the Files choice in the result window is handy:

 

 

However it also shows all the Browses which if you have a large workflow can make you scroll to find the actual files. In the above example 10 of the 54 are files, the rest Browses.

 

I would prefer the Files button show JUST the Inputs and Output and not the browses. Either ditch the browses or add a separate button for that.

 

Cheers,

Bob

 

It would be nice if we could right click on a Tool from the canvas and add it to Favorites from there.

I paste data into text input tool, then i have two choices 1) rename each field manually according to my data source 2) add the dynamic rename to take the headers from the first row.

 

The first way is time consuming and prone to mistakes.

 

The second way breaks the downstream configurations (workflow needs to be run first), and affects how the text input tool auto-detects the field types (all strings)

 

Text input would be improved with a button that automatically takes the first row and turns them into headers, as if i typed them in myself.

 

Thanks!

It would be extremely helpful if you could add more parameters to the string functions to make them more powerful and useful. For example, adding a parameter into the get Word Function to match whole word only would be really nice in situations where you want to match the term VA, and not valley. Otherwise, you would end up building a regular expression to find what you are interested in when that may be overkill for the problem at hand.

Pretty simple but could be helpful when troubleshooting and reviewing.  Allow a user to have rows be banded in a different color, allow the user to select how to do the grouping to band.  For example, a large browse tool has several thousand rows, sorted by product name.  Each product has between 5 and 50 rows each.  If a user could set color banding by product,.. they could easily find the "breaks" between product rows.  This could be somewhat similar to the Excel table formatting option for banded rows,.. you could simply alternate bands,.. but would be nice to be able to group the bands by some column attribute in the data.

This may be a little easier than constantly opening new browse windows with the selected records,. or to use filters or other tools to group the data for review / troubleshoooting purposes.

Or ability to batch change the connection string from A --> B for all tools using A.

Or ability to set a default "saved connection" for a workflow and if you change it cascade the change to all tools.

 

Case:  you have numerous connections in a workflow to a database.  You then either:

a) move your data somewhere else and need to replace all the connecitons

b) OR have a standard process for working against DEV, Staging, etc. and want to switch the workflow to use a different saved connection