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.

Instead of being a module setting, showing counts should/could be a user setting.

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?

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.

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

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.

It would be great if there was a way to convert datatypes within the Table Reporting tool.  The specific example that sparked this idea is calculating percentages so they are shown in the report with the decimal place moved over.  Today, within the formula tool I need to calculate the percentage and then multiply it by 100 in order for it to display the way I'd like in the report.  However, if I need to leverage this percentage for another formula I most likely will have to divide the percentage I calculated first by 100 before I continue my calculation.

It would be nice to not have to multiply by 100 to move the decimal place over 2 spots and instead use the table tool to convert the number into a percentage we're all used to seeing.  I'm thinking something similar to excel where you can click percentage, currency, etc to convert your number.

It would helpful if you have a tool which will help us to filter out the data using CASS results column in a meaningful way. On the other day, I CASS'ed 2MM customers and ended up with 1500 combination of CASS result codes. I don't think we would have time to sit walk through all the 1500 combination to find out which I should call it as correct addresses and not the right ones. If you have one already that I didn't know of, please guide me.

Thanks
Arun