Alteryx Designer Desktop Ideas

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:

I have been using the outputs from Spline Regression to facillitate analysis of demographic data (specifically Department of Labor Quarterly Employment data).  I have data from 1992Q1 to 2014Q1 and use Spline Regression to get fitted values for each quarter with predictors being the year/quarter, Year/quarter multiplied by a dummy variable for each of the 4 US Presidents, and a dummy variable for each president. 
So I can compare results across various groupings by geographic, and other levels as well as the BLS aggregation level. I can analyze raw data or have the values to be fitted indexed to 1992Q1.
I use the default settings for Spline and it builds the best fit including where the node periods for each spline section.  To help interpret the results, though, I use the output to compare the actual vs. fitted values (e.g. employment Level) and then look at the changes by quarter. 
With the spline regression building the best model with optimal line segments, the results make it possible to see how employment progress or regress correletat with with presidential terms of office or specific impacts of economic recessions on employment data.

I can supply an example of the process, if anyone is interested.

I'd appreciate any comments and/or suggestions to improve the process or interpret the results.  

I'd love the ability to Input an already-formatted Print Layout area within an Excel document, or a .PDF document in an effort to standardize reports needed on a regular basis.

Our department doesn't create everything that rolls into these reports, but we'd love the ability to incorporate external documents and save our company hours.

Is it possible to format an input tool to only look at the Print Area? If not, that capability would be wonderful.

Thanks!

I'd like to see some added configuration in the Chart tool to allow more space for the chart legend so that the names of elements don't have to be truncated.  The only way to eliminate truncation right now is to decrease the font size and/or increase the width of the table which also in effect reduces the font size.  This is specifically an issue in "Stacked Column" or similar charts.

Issue: When I use any of the Multi-Field Formula tool, I lose the variable names in the field description. This is a problem when I'm working with demographic data because the name of the variable is often something like PCT0010005. The user friendly name is in the field description metadata.

Solution: Please have the Multi-Field Formula tool behave as the Formula tool does by persisting the field Description values.

Thanks!

John Hollingsworth

When creating an Annalytic App, in the Actions tab, when creating an action, have the window display the actions in numerical order.  

I would like the ability to adjust the sort order of the tools displayed in the actions tab when creating a Macro, or at least have it conform to some sort order that can be easily identified. I can't currently make sense of this sort order which makes it hard to find the tool I’m looking for.

Currently SharePoint Input Tool allows downloading a file from SharePoint to local machine, then we can process it locally, this is great since the tool can only handle 3 types of files and won't support the rest like Zip or anything else.
SharePoint Output tool, only support the same 3 files type, but will not allow uploading to SharePoint a local file, similar to the input tool but in reverse. Why is this important:

1- We can create local files that is in a format like KML, KMZ, ZIP etc., which we can't upload it to SharePoint after.

2- updating multiple sheets on the same file, updating locally then uploading the file to SharePoint will be a lot faster and more efficient. 

 

it is easier to overcome above challenges if we use Alteryx Designer and Sync the SharePoint, or map it to local drive or folder. but it is impossible to do it when using and scheduling it on Alteryx Server.

Please update the SharePoint Output tool to allow uploading any type of file(s). Thank you.

1. Image Processing Tool functionality should be available in Reporting tools.

2. Image Output Location should allow for a temp file location

3. Image Processing should allow lock of aspect ratio when Cropping (like Scale)

4. Image Processing should allow for fieldname selection for Crop, Scale ...etc to allow for custom calculations.  Being able to generate custom values for width and height based upon the values generated in from image profile would be useful

When using certain tools, particularly market place tools like the SharePoint input/ output etc. it would be helpful to have a quick way to find out which version is being used in a workflow. Something along the lines of an option when you right click the tool, that displays the current version would be ideal. 

This would be helpful in several cases but primarily when handing over workflows. There are cases when I have multiple versions of the same tool installed so that I don't have any issues inheriting workflows. This does however, make things confusing when handing workflows back. Tool Version Labelling would solve this problem.

Regards - Pilsner

Anytime you create a formula in the formula tool, you get a data preview based on the values in the first row of data.  However, if you have a complex "IF c THEN t ELSEIF c2 THEN t2 ELSE f ENDIF" formula then the data combination that gives a TRUE result will likely exist on another row.  Therefore, you need to run the workflow, or place a filter tool upstream to isolate the specific row, to test if the formula result is correct.  

 

It would be easier if you could select the Input anchor of the Formula tool, then filter the data in the results window to isolate the row in questions, then the data preview would be based on that filtered data set.  I believe this would save a lot of time in the workflow development phase.