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.

Hi,

 

When you create a data model in excel you can create measures (aka KPI). These is then something you can then use when you pivot the data and measure would dynamically be updated as you segment the data in your pivot table.

 

By example, let's say you have a field with the customer name and a field with the revenue, you could create a measure that will calculate the average revenue per customer (sum of revenue / disctintcount of customer)

Now if you have a 3rd field in your data that inidcates your region, the measure would allow to see the average revenue by customer and by region (but the measure formula would remain the same and wouldn't refer to the region field at all)

 

Excel integrates well with PowerBI and currently these measures flow into PowerBI.

 

While we have a "Publish to PowerBI" in Alteryx I haven't seen any way to create such measures and export them to PowerBI.

 

Hence I still need to load to Excel to create these measures before I can publish to PowerBI, it'd be great to avoid that intermediate tool.

 

Thanks

 

Tibo

 

Like the ability to create data tables for reporting purposes, makes life a lot easier.  I would like to suggest the ability to be able to define the height of each row in the table.  There is a lot of wasted space between the rows and becomes challenging when you are trying to work with getting everything on one page or keeping the table contained within a box on the report.

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.

 

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.

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.

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 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.

 

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.

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.

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.

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

 

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: