This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Alteryx's spatial tools are really powerful and offer a lot of value for analysis. However, when rendering a map for output, there is currently no way to place an image inside of a polygon. This feature would be very useful for customized layers on maps and other spatial-based processes.
My rough suggestion would be to scale a selected image to the size of the polygon's bounding rectangle, and then trim the edges of the image to fit inside the polygon itself.
The new insight tool offers some great charting abilities but it does not integrate with other reporting tools. The tool doesn't support pictures,tables or any way to pull text from the data in the workflow in. This really prevents it from being a solution to any of the my reporting needs.
In user settings you can define a "Logging Directory" and if you do the system will send the Output Log (Results view messages) to a file in that folder. The name generated is Alteryx_Log_ + an apparent sequential number, example: Alteryx_Log_1519833221_1.
This makes it impossible to identify which flow it is associated with and which instance of execution simply by looking at the name, you have to parse the content to see the flow name and start/end timestamps. For trouble shooting we want to be able to look at the list of file names and quickly see which file, of possibly hundreds of files, we need to look at to see what went wrong.
Roughly, in all versions of Alteryx Designer, you can use the Annotations tab and rename a tool. This is awesome for execution in designer, because you can then easily search for certain tool names, better document your workflow, and see the custom tool name in the Workflow Results.
However, when log files are generated, either via email, the AlteryxGallery settings, or an AlteryxEngineCMD command, each tool is recorded using only its default name of "ToolId Toolnumber", which is not particularly descriptive and makes these log files harder to parse in the case of an error.
Having the custom names show in these log files would go a long way towards improving log readability for enterprise systems, and would be an amazing feature add/fix. For users who prefer that the default format be shown, this could be considered as a request to ADD renames in addition to the existing format. EG "Input Data 1" that I have renamed to "Load business Excel File" could be shown in the log as:
00:00:0.003 - ToolId 1 - Load business Excel File: 1 record was read from File Finished in 00:00:0.004
This appears to be a bug with either the Layout Tool or the Render Tool. When I setup two Tables using the Horizontal Layout Tool and export to Excel using the Render tool, the font size of the bottom-right cell of the first table is too large. No amount of changing the font properties within the Alteryx Reporting tools appears to fix this.
I know this has been posted before, but the posts are fairly old, and I have just confirmed with Support that it is still an issue. Seems to be a pretty basic request, so I'm putting it out there again under this new heading.
The issue is that if you have data in a field, and you have that data separated by a new line (\n), it will show up fine in a browse tool, or pretty much any other output (database file, Office Document file, etc.). But if you try to use the Table Tool under Reporting, it ignores the line break and strings the data together.
The field data looks like this in a browse or most other outputs:
Hello, my name is
and I love
But when I try to pull this field into a Table Tool, it shows up like this: Hello, my name is Michael Barone and I love Alteyrx
Putting this out here again in hopes that it gets lots and lots of stars so it gets put on the road map!!
This idea consists of a couple of requests that are related to the same topic - table styling using the formula field. As most probably know, the table tool offers column/row specific formatting. Some of the basic formatting offered in the configuration are: fonts, texts colors, and backgrounds. For anything that doesn't fall into these types of formatting rules, there is a "Formula" option that allows the user to define CSS-like statements to format the selected column, row, or cell. Related to this formula, I have two requests:
I would like a double border to be included as an option. After speaking with a support engineer, they do not believe this is currently available. The double border is used in most financial documents as the "sum line". I see a lot of uses for this, especially in my industry. I would expect a formula like this: "border-top: 1px solid double black;" to give a result like this:Desired OutputBut it gives a result like this:Current Alteryx Output
I would like to see additional documentation on this Style Formula field so users have a reference when attempting to do advanced styling on a table. I don't think it's sufficient to say, "Use of this requires a solid understanding of CSS styles" if all CSS styling options aren't available. Documentation would at least let us know that what we are attempting to do isn't possible.
It would be lovely if the Image tool supports GIFs when using the .PCXML and HTML options in the render tool. Understandably, it would use it's .PNG format when using other render options, such as PDF etc.
I've added a table tool that also has the bar graph enabled. The data I'm basing the bar graph off of is set to 5 decimal precision, but the bars round to the nearest whole number, making the feature essentially pointless in my scenario. Is there a way to have the bars dynamically adjust to the amount of decimal precision? I'm guessing most folks are exporting their data to a viz tool and not many folks are using the table tool in this context.
There is currently no way to export interactive output from the network graph tool. I would like to be able to export a png of the static network graph image, a pdf of the report, and a complete html of the whole (which means including the JSON and vis.js files necessary for creating the report).
Sometimes I get conversion error messages or warnings that really don't matter, and it would be great if there was a function similar to spell check or grammer check where I could say "Don't show me this again", so that once I've read the message I can choose whether or that particular message pops up again.
I have been going back and forth between output tool and render tool. The render tool works well when you want formatting. It's also great when you don't want an output created (when rec count=0) while output tool always generates a file regardless if there are records present or not. Output tool works well when you have a lot of fields but then you cannot easily control styling.
My issue is that I have a render tool connected to table tool. In the table tool everything looks neat; there's no wrapped text and no unnecessary white space (auto column width not necessary). However, with the render output, you don't know what to expect. Especially, when you have a lot of fields (30+) data gets truncated and column width is forcibly narrowed due to paper dimensions used in render tool. I skip letter and tabloid formats and now I have to mess with custom paper width (e.g.50) to get my reports looking right and when you have dynamic fields, this is not ideal.
Would it be possible to make the paper size/width automatic in the render tool just like in the table and layout tool? Then this tool also doesn't negate what layout/table tools do so well.
In the ‘Report – Table’ tool I would like to be able to force headings to multiple lines. For example If I have a heading such as “Catchment (%)” or “Spend (£)”, I would like there to be an easy way to make the (%) / (£) move to the second line when I have fixed width columns.
I have several regular outputs I use that are in both Excel and PDF (depending on who I am sending them to).
The format of these is always:
For Excel, create a summary sheet and set as the first tab, then create detailed sheets as additional tabs in the same .xlsx file. The summary sheet always has the same fields, but the fields may reference different detail tabs day to day.
After the output, I can manually open Excel and change the field to a formula that references the other tabs (hyperlink function). It would be great if I could just type the hyperlink formula in Alteryx and have that embedded into the Excel output.
The same goes for PDFs, except I would reference other pages (or if using PDF portfolio I would reference other PDFs in the same portfolio).