Alteryx Designer Desktop Ideas

Today the Autofield tool transforms the fields into byte by default when it considers that the content is suitable while we expect text in it and that it can simply be a field not filled in in the context current but which may be later.

The idea would be to be able to choose which type by default to implement on text or empty fields and not the default byte because a byte field is not recognized on a formula using an IN for example which can produce errors in the following workflows.

Hello,

My idea is that the current Download tool does not handle errors and continues its path even if it does not find for example a file in the transmitted URL or if it does not find the hostname it crashes.

In the case of a user with several URLs in a row, this is penalizing.

In the case of downloading files with recording, it still writes a file (thus overwriting the existing file) but which is not openable and is not in the correct format. (BLOCKED file!) Which then causes problems in workflows reading these files.

The idea would be to put a second output to this tool for all the URLs where there was a problem (non-existent hostname, file not found, HTTP KO) and one where it received the expected elements so as not to prejudice the processing. and allow better management of error cases.

Regards,

Bruno

Hi,

Since the Geocoders create point data, having the spatial field recognized as a centroid can be helpful to the user. If it's marked as a centroid, it makes it easier for the user to differentiate between point vs polygon/line, especially if the user is already using polygon data in the module. If I do a Spatial Match or Join, I can have two fields called SpatialObj, which I have to track back to figure out which is which. If after combining, it showed Centroid for my geocoded points and SpatialObj for my polygon data. Kind of like you do for the Create Points tool, if I use that the field is called Centroid.

Thanks,

 Hi Team,

I have a dataset of x,y values that I am plotting with an interactive chart tool. These values will vary widely so I can't use custom display ranges and have to rely on the "Auto" function for display range.

My problem is that the two axis are Auto scaled to different scaling and it is turning all my ellipse shapes into circles. Not a huge setback as you can check the Axis labels to see the scale but for this use case the shape of the data is what I am trying to portray and this makes my reports somewhat misleading.

I'm suggesting adding an option, maybe a tick box, under the interactive chart's "Auto" config that would allow both Axis to be scaled the same amount (That of the highest value).

Cheers,

Stephen

Currently users have the option of outputting to a PNG image but currently can only use Inches to get the size set. I want to be able to output with a pixel size not in inches. 

Alteryx crashed when I attempted to use a custom OTF font in Report Text. I thought it was supported because font options was not greyed out and preview window looked correct and I was able to resize. I clicked 'Apply' and Alteryx popup window appeared saying "only TTF font is supported". Then Alteryx crashed.

Please add OTF font support. Tableau and other packages already support it.

I'm not sure if this is the right forum for a bug report, but I just solved one that has been bugging me for ages. Of the six key commands to hide and reveal the various panels, only five work, and now I know why.

Apparently the 'Results' panel used to be the 'Output' panel? I found some outdated docs that mentioned Crtl + Alt + O to open/hide the Output panel. Sure enough, the reason Ctrl + Alt + R doesn't work in the current version is that, in spite of what the menu text says, it's O that is still mapped to that panel, and not R.

I only discovered this after making sure none of my other installed apps were stealing that key combination. Thank you, process of elimination.

Enable multiple sheet selection for excel

I would like to be able to connect to an AWS EMR resource.

And an AWS gov cloud endpoint.

Hello Team,

I have been using Alteryx for sometime now. The final output of any kind be it analytics or simple Excel outputs is expected to have some basic formatting.

A minimum of 3 Tools and humongous effort is need to format even basic headers and Cells with a border and color.

Using Table followed by Render and then column level setting for having borders for the set of data is little time consuming considering it has 0 impact on the actual data output.

Additionally Render tool to Excel will be in number format regardless of the data type. Same is the case for date fields.

Also the Render tool Layout changes impact the data as well as the column lengths adversely.

Can we have some simple option of overwriting a file where the formatted excel is merely overwritten with data without changing the datatype or format out the excel sheet.

It would be huge win if this is easily do-able wither via a new tool or as an option in the output tool.

While doing Find replace with the following settings,

The output limits to the number of characters comes with "Replace source". If the number of characters in "Replace  Found Text With Value" is more than the source then it will truncate the value to source. I feel it's not correct. 

Suggesting, that there should be an option to overwrite the "field size" or keep as it coming from source.

A lot of business processes require encryption and decryption, for either data transfer or authentication processes.  It would be great if Alteryx could expose some of the C# encryption functions from the System.Security.Cryptography library, as either functions in the Formula tool, or as new tools. 

I know that some of these algorithms require byte input, so a new tool might be the sensible option, so that user can pass various data types that are pre-coded to byte arrays before going into the algorithms.

I get the following message when running a macro with the Render tool inside

" Alteryx ppt testing1 (162) Tool #26: You have found a bug. Replicate, then let us know. We shall fix it soon."

I believe this happens when there is multiple line breaks next to each other and trying to put this into the render tool outputting to powerpoint within a table.I have the formula for updating the line breaks "Replace([Layout],"&lt;br /&gt;","<br />")" which works when there aren't very many line breaks but now I have integrated Python to regex out HTML the Render tool has stopped working

When using Dynamic Input with databases, the Database may be returning errors or other information that the tool cannot parse into a dataset.

It would be great if we could see the 'raw' response from the database somehow, as this might provide insight into why we are not getting the expected results. 

If the tool could output an optional error column that has the unparsed response from the database server, it might allow us to debug the problem ourselves. 

If the returned data is actually a string response from the database, but one that is flawed in some way, we might still be able to parse data out of it to 'ride over' the error.

Field selection in Multi-Field Formula seems to be 'All' or 'All of a Type' or, potentially, lots of manual tagging.  I have >600 fields and want to select about 150 adjacent fields.  Is it possible to implement a 'mass select' option within the Multi-Field Formula Tool, as found in other tools?

Configuration window - Add feature to zoom in or out of the configuration window similar to the canvas.  There is alot going on in the Configuration window and it would be helpful (especially for those of us with eyesight challenges) to be able to zoom in/out similar to the Canvas. 

More and more people are making use of Plotly and Plotly Express to develop really great graphics.  However it is extremely difficult to extract either interactive charts (HTML format) or static images (PNG or JPEG).

The main issue for Plotly to save static images is the ability to install and use Orca (application) for R and kaleido (library) for Python.  Despite my best efforts I have had no luck getting either approach to work with the respective Alteryx environments

Migrate old R based charts and create new statistical charts in the interactive chart tool to provide enhanced statistical charting and visual data exploration capabilities.

This includes:

• Error Bars
• Distribution Plots
• 2D Histograms
• Scatterplot Matrix
• Facet & Trellis Plots
• Tree Plots
• Violin Plots
• Heatmaps
• Log Plots
• Parallel Coordinates Plot

This these URLs for more examples:

https://plotly.com/python/statistical-charts/

https://plotly.com/python/scientific-charts/

The ability to create, modify and enhance interactive chart types through custom plotly code in either R or Python.  This would allow new style of visualisation to be created and shared with other authors.