The Sharepoint file tools are certainly a step in the right direction, but it would be great to enhance the files types that it is possible to write to sharepoint from Alteryx.
The format missing that I think is probably most in demand is pdf. If we're using the Alteryx reporting suite to create PDF reports, it would be awesome to have an easy way to output these to Sharepoint.
After used the new "Image Recognition Tool" a few days, I think you could improve it :
> by adding the dimensional constraints in front of each of the pre-trained models,
> by adding a true tool to divide the training data correctly (in order to have an equivalent number of images for each of the labels)
> at least, allow the tool to use black & white images (I wanted to test it on the MNIST, but the tool tells me that it necessarily needs RGB images) ?
Question : do you in the future allow the user to choose between CPU or GPU usage ?
In any case, thank you again for this new tool, it is certainly perfectible, but very simple to use, and I sincerely think that it will allow a greater number of people to understand the many use cases made possible thanks to image recognition.
Thank you again
Kévin VANCAPPEL (France ;-))
Thank you again.
Alteryx Designer is slow when using In-DB tools.
We use Alteryx 2019.1 on Hive/HortonWords with the Simba ODBC Driver configured with SSL enabled.
Here is a compare In-DB / in Memory :
We found that Alteryx open a new connection for each action :
- First link to joiner = 1 connection.
- Second ling to joiner = 1 connection.
- Click on the canevas = 1 connection.
Each connection take about 2,5 sec... It really slow down the Designer :
Please, keep alive the first connection instead of closing it and creating a new one for each action on the Designer.
Lots of use cases involve concatenating some values based on group by clauses within the Summarize tool.
It will be great to have the option to Concatenate Unique as an aggregation method, so the results will have just one appearance for each value in the results.
Plus, having the option to get the chance to have them sorted or not will be awesome.
A simple quality of life improvement that I would love, is the ability to rename the output of the transpose tool in its configuration, rather than only having 'Name' and 'Value'
Would just let me drop the renaming of these fields afterwards :)
Many times, I want to summarize data by grouping it, but to really reduce the number of rows, some data needs to be concatenated.
The problem is that some data that is group is repeated and concatenating the data will double, triple, or give a large field of concatenated data.
As an example:
The above, if we concatenate by State would look like:
|A||New York, New York, New Jersey|
|B||Florida, Florida, Florida|
What I propose is a new option called Concatenate Unique so I would get:
|A||New York, New Jersey|
This would prevent us from having to use a Regex formula to make the column unique.
Whenever a Summarize tool is used, it renames the output field (e.g., sales becomes SUM_sales or AVG_sales).
I think a reasonable compromise is to by default not rename fields in the Summarize Tool, but to include an option (in the tool, or in global settings) to allow for renaming.
I have yet to come across a use case where automatic renaming of aggregated fields is desirable. What I have come across is the annoyance to rename the fields back to what they were with a Dynamic Rename tool, and sometimes having to do this multiple times (e.g., converting back a SUM_SUM_SUM_sales back to sales). Additionally, automatic field renaming causes workflow errors when workflows are later modified by adding/removing a Summarize tool (e.g., if you later add a Summarize tool, all downstream steps will expect the "sales" field and not know to use the "Sum_sales field).
Automatic Renaming feels very much like historic Excel with Pivot Tables field renaming and not reflective of modern code-based workflow best practices.
I appreciate you considering this improvement.
When using the transpose and cross tab tools, I find that I frequently need to reorder the columns selected in the "Key Columns" and "Group data by these values" sections of the tools respectively by using a select tool. It would be helpful to provide users with the ability reorder fields displayed in these tools similar to the functionality provided in the select, join, append, summarize tools etc. Currently the tools default to outputting these columns in the order they come in through the incoming data stream.
It would be ever so helpful and save a couple extra steps if a count distinct option could be added to the crosstab tool. Seems like a slam dunk since plain ole 'count' is already a choice.
It would be very helpful to have a search box for field names in the summary tool, I think it would help decrease errors by selecting fields by mistake with similar names and will help gain a couple of seconds while looking around for a specific field, particularly with datasets with a lots of them.
Currently both the formula and summarise tools round to 6.d.p for finance calculations such as IRR. People coming from Excel will be used to a higher precision then this. It would be great to up the precision in line with other platforms to 8.d.p +
The crosstab tool replaces any non-alphanumeric characters with underscores in column names. It would be helpful to keep the original values as column names (or to have the option to toggle whether or not special characters are replaced with underscores).
This is often an issue for reporting and for dynamically-populated app inputs (e.g. drop-down), where we need to retain the special characters.
For example, say I have the following dataset:
Currently, the crosstab tool produces this:
I would like this:
There are currently (somewhat cumbersome) workarounds such as adding an extra row with the original names, and then using Dynamic Rename to rename the columns, but it would be great to be able to use the data straight out of the crosstab!
Hi to all,
I have seen one or two posts requesting ability to total up rows and/or columns of numbers, however this idea also requests the ability to subtotal data by a field and also produce an overall total.
This could be an extension to existing tools such as 'Summarise' and 'Cross Tab' or could be a stand alone tool. Desired output of using a tool like this would produce something like this:
This would be incredibly useful for building reports within Alteryx as well as analysing the data, and cut down the amount of tools currently required to produce this. I have seen a third party tool which does some of this but this adds the ability to subtotal.
thanks - Roger
With the 2019.3 release the summarize tool now includes prefixes for grouped fields. While a nice addition, in application it makes using this data downstream (like joining to other tables) more involved because of needing to remove this prefix.
It would be nice to have this as an option (a checkbox to add/remove prefixes maybe) or just revert back to pre-2019.3 behavior...thanks!
I work with data where milliseconds is my saviour when I count distinct the datetime to get number of events. Alteryx ignores the millisecond part (as lots of other BI tool providers - I don't know what is going on with this idea that milliseconds are not needed). Yes I can convert it to string but it's not the best practice to create duplicate fields just so that I have date part for date-related calculation (plotting, time difference) and on the other hand string value for quick and easy counting..
Currently the cross tab tool automatically sorts alphabetically by the "New Column Headers" field. Often times I have to output data with dates across the columns and therefore have to do a cross tab to achieve this. The problem is when I have the dates formatted with month names, the crosstab automatically sorts it in alphabetical order instead of date order (i.e. Apr, Aug, Dec, etc vs Jan, Feb, Mar). To get around this issue, I have to use a dynamic rename tool. It would be great if there was a way to choose the order of the crosstab (i.e. in the order of the data, crosstab, another field, etc.).
Today I worked with summarize tool and need to merge/concatenate 10 string columns of dataset with different separator than is set up by default (",")
Current status is that you can multiple select columns that you want to concatenate (that's good) but when you want to set up for all output columns different separator than default, you must set up it for each column, in my case it was 10 columns..
one field is selected (Concatenate option is available)
More fields selected (Concatenate option is hidden)
Allow to multiple selection of fields that are concatenated and allow to set up separator for these fields. Benefit will be that you can mass setup different separator for various fields
Hello Alteryx Devs -
When I got to write some scripting in the formula tool, my data stream properties should be the first to be suggested once a user starts typing a letter, not the last.
uppercase(Ad -> gives me:
I think we would need a dedicated R macro to ascertain the chances anyone in is going to need [ReadRegistryString] before they need a column of their own data that starts with [Ad...]
Easy fix. Makes a big difference.
With the continued growth of Graph Databases, it would be nice for Alteryx to creates a new tool set that would allow input/output connectors for Graph Databases like Neo4j which software tools like Pentaho and Talend already have.
Hello, it would be helpful to be able to have multiple levels of detail in a summarize tool. So, rather than aggregating on the lowest level of the group-bys, being able to select the level or partition for the aggregate. The current workaround for this is having multiple summarize tools and joining back to get all the data in one table.
The configuration would look something like this:
|Field||Action||Aggregation||Output Field Name|
|Store Sales||Sum||Store; UPC||Item Store Sales|
|Store Sales||Sum||Metro; UPC||Item Metro Sales|
Item Region Sales
|Store Sales||Sum||Store||Total Store Sales|
With the aggregation field maybe being a pick-list of available "group by" columns. It should default to all the group by columns, but you could un-select some if you wanted a higher level of detail.
I would love to see a "Product" option added to the summarize tool. I can currently count, sum, mean etc., but I can't multiply my data while grouping. There are numerous "work arounds", but a native product function built into the summarize tool would be great.
Thanks for listening!
Is there a way we can turn on and off any tools in the workflow. This way we can run the tool and when a certain tool is marked off it is not executed. This way we can test the workflow and check different output without deleting the tools existing on the workflow, we can just turn then on or off.
Hi, I have searched through the community, and I wasn't able to find a duplicate for this idea. If in fact there is, I apologize and please point me to that post. I think that it would be a good idea to have date options in the summarize tool that would allow for grouping at higher levels of the date. I often have a date field that is specific to the day (i.e. 2018-01-01), and I just want to group by the year or month. Currently in order to do this, I have to create a formula before the summarize tool that formats the date according to how I want to group it, and then I am able to group off that field in the summarize tool. It would be nice if in the summarize tool, I could select the date field, and then have the option to group it at year, month, week, etc.