Alteryx Designer Desktop Ideas

The actual Mongo output tool does not allow to specify field type (except for the primary _id field).  The tool just assumes that all fields are string.  Many of our CSV files incorporate string representation of ObjectId (ex: "56df422c08420b523aa00a77"). 

 

When we import those CSV we have to run a an additional script that will convert all the id into ObjectId fields.  Same thing with the date -> Mongo Date.

 

If the tool would allow us to do this, it would save us a billion time across all our ETL processes.

 

Regards,

 

Currently SharePoint List Input tool can only pull out Date/DateTime values in UTC

DateToLocal formula can be converted back to local time but it has the issue for Date Only values.

It will be great if Alteryx allow user to select to pull Date/DateTime values in UTC or Local Time.

Not sure if this has been submitted... or if this option is already in a newer version.

There should be an option, after correcting an issue/error within a workflow for users to start again at the error point instead of running the entire workflow again.

This option will help users to streamline the process of building workflows and avoid wasted time spent waiting for large complex workflows to complete or error out.    

A suggestion for the designer product...

 

When one right clicks on tab showing a workflow, an option should come up to duplicate workflow/macro/etc.

 

I have found a post where the grid size in the Grid Tool can be update using an interface tool -- which is really wonderful.

What I would love to see is the grid size text entry box being able to accept a field name/variable, so that this can be modified without needing the interface.

 

This would be useful because I have users uploading shapes to be analyzed -- they don't necessarily know the size of the shape so I would rather the grid size be automatically calculated based on the square mileage of the shape.

 

Our development team prefers that we connect to their MongoDB server using a private key through a .pem file, instead of a username/password. Could this option be built into the MongoDB Input?

In the question type "DropDown/ListBox", there's an option to use an external file. The file should be able to influence whether the record is selected or not. Maybe there's a reserved column name called "SELECTED" which could contain True/False values which the UI would key off.

Create the ability to randomly sample X number of records. For example, randomly select 16 samples from a data set.

For new users (and sometimes even veterans) understanding what an error message means can be a challenge.

 

I think it would be great to be able to right click on an error message (or warning) in the results window and have the option to "Search Community for error". 

 

There should be a page like this one for every error message:

  

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Error-Type-mismatch-in-operator/ta-p/34149

 

 (Nice job @AndrewL )

 

Or, if the Help had documentation on common error messages and their resolution then an option to "See Help document for this error". Currently the help has nothing that I could find.

 

Cheers,

Bob

 

Cheers,

Bob

 

When testing an app, I always use the Debug Mode.

However, if I have any files in the app that are using a relative reference (and are not being updated by the app), they continue to have that relative reference in Debug mode.  But in Debug Mode, this Debug workflow is located in a totally different computer location that my app - C:\Users\username\AppData\Local\Temp

So when I try to run the workflow in Debug mode, it can no longer find my files that used a relative reference path.

Can you make it so that when you are in Debug mode, the relative references are changed to absolute references so the files can be found?  I find it really inefficient to have to either:

1 - repoint my files that have a relative reference to their locations so they can be found when the workflow is run

2 - save the debug workflow to where the app is located so the relative reference works.

 

Thanks

I think it will be useful if I have an option to add field description when new fields are being created (eg. formula tool, transformation tools etc.)

 

The case for this is I tend to create a lot of calculated fields by combining fields and applying transformations for exploration predictive possibilities, I want to capture description of the fields while they are being created (its not always possible to set the names descriptive enough)

 

As of now I think I can add description using select tool but that's not optimal

 

 

Thanks,

Option to add a description for each newly created filed in all data preparation and transformation steps. Although a description can be added in the select tool but that's an additional tool in already cluttered (most workflows).

My use case for this is I tend to create a lot of fields (dummy, interaction and transformation) for predictive modelling to come up with a best model. I can not always name the same filed in such a way that is descriptive enough but I want to capture my thought on why I created a particular field right when I am creating it.

 

Thanks,

Ashish Singhal

It would be very helpful to be able to export your entire workflow to a poster-sized paper, either in paper or PDF format.  When explaining a workflow to others, or getting feedback, the ability to see the entire workflow or lay it out on a table is very helpful

There is a bug in DateTimeDiff(a, b, "months") whereby if a is a leap day DateTimeDiff() returns a value by less than 1 month.

Please see attached workflow where I demonstrate this bug.

 

It would be very useful to have a new Grid selection question type. This would allow you to see a grid of data that you can sort and pan through and make selections. Similar to a multi select but in grid form with multiple columns.

We just updated to 11.7 from 10.5.

 

The Container adding/removing rules were changed somewhere in there and the change made it much harder to remove tools from containers. Is there any way to undo these changes or look into a better set of rules to use?

 

Nick

Hi,

 

I understand that we can find tools that uses formula by ctrl+F. 

I wish we can find text and replace the formula like excel does.

Sincerely,

knozawa

When I save records out of a browser tool, an info window appears when the file is finished saving. Please add a hyperlink to that window that will open the newly saved file. This should work the same way as the hyperlink in the Output message window.

 

It would be a timesaver for workflow documentation if macro metadata could be passed through to the workflow where the macro is deployed.  The image below suggests that the Description encased in the macro could be copied across to the corresponding Annotation panel.  I would also suggest that the Meta Info panel have a checkbox to control this new funtionality.